[prev] [thread] [next] [lurker] [Date index for 2007/03/20]
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 GreeeeessssThere's stuff above here
Generated at 14:43 on 31 Mar 2007 by mariachi 0.52