So, Jeremy
there is not a real bug as of original message,
where Symbol regexp '^[A-Z][A-Z_]*\.(N|A|OB?)$';
[...]
| SPJ.A | 763280 |
| BPN | 763281 |
| SYNA.O | 763286 |
because "BPN" matched with pattern:
m/^[A-Z] [A-Z_]*\.(N|A|OB?)$/
B P N
--w
On Tue, Jan 29, 2002 at 10:27:10PM -0800, Jeffrey Friedl wrote:
|> Jeremy Zawodny <jzaw...@yahoo-inc.com> wrote:
|> SELECT "foo" RLIKE '^[A-Z][A-Z_]*\.(N|A|OB?)$';
Silly me -- a string literal, apparently even with single quotes, still
recognizes \n, \t, \\, etc., so even if one writes "\.", the result
is merely ".". Combined with the case-insensitive nature of the matching
explains things. Had I used "\\.", it would have worked.
Sorry for the false alarm. I can never understand this "regular expression"
stuff....
Jeffrey
How-To-Repeat: while (1)
7 messages in com.mysql.lists.bugsRe: MySQL Bug Report: REGEXP matches ...