Resending with How-To-Repeat: so that it gets past your spam filter....

|> Jeremy Zawodny <jzaw...@yahoo-inc.com> wrote: |> |> MySQL folks, |> |> We've found what looks like a bug here in MySQL's REGEXP/RLIKE |> |> implementation. I've uploaded a Datascope-yahoo.tar.gz |> |> Or, instead of loading that 50 megabyte table, the problem can be shown |> by executing this: |> |> 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)