Re: MySQL Function Naming

[prev] [thread] [next] [lurker] [Date index for 2007/03/20]

From: Michael G Schwern
Subject: Re: MySQL Function Naming
Date: 21:22 on 20 Mar 2007
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
There's stuff above here

Generated at 14:43 on 31 Mar 2007 by mariachi 0.52