Aaron Crane wrote:
> I'm prepared to believe that this is merely a bug in our particular
> point-release of the server, rather than a fundamental design flaw, but
> that doesn't stop it being incredibly hateful: if I'm looking for
> something equal to an exemplar, then, no, something vaguely similar is
> _not_ sufficient.
test]> select foo, concat("[", foo, "]") from foo where foo = "this";
+-------+-----------------------+
| foo | concat("[", foo, "]") |
+-------+-----------------------+
| this | [this ] |
+-------+-----------------------+
1 row in set (0.04 sec)
No such luck.
These are the people who decided it would be just spiffy if "LIKE" was case
insensitive.
test]> select foo, concat("[", foo, "]") from foo where foo like "THIS%";
+-------+-----------------------+
| foo | concat("[", foo, "]") |
+-------+-----------------------+
| this | [this ] |
+-------+-----------------------+
1 row in set (0.00 sec)
Also that the case-sensitivity of the table and database names should be
determined by the underlying filesystem because the idea of lower-casing the
name before using it as a filename was just beyond them.
Repeat this chant against MySQL hate: Pooooost Greeeeessss
