Hi Jay
On 26/04/2009, at 8:44 AM, Jay Pipes wrote:
drizzle> select * from t1 inner join t2 using (A);
ERROR 1054 (42S22): Unknown column 'A' in 'from clause'
Personally, I believe the new Drizzle behaviour should be the correct
one, no?
Correct is of course relative to whatever baseline you pick, but...
In SQL standard, identifiers are case-insensitive, and I think that
should be the way Drizzle does it.
Am I forgetting some MySQL compatibility mode around lower case field
names or something?
Yea, but that's purely for the filenames on disk (databases and
tables) which is just an artefact of MySQL using directories/files for
them and not having insulated the user from that from the start...
In any case... in queries, column names always case-insensitive.
In Drizzle, I would like table and database names to be case-
insensitive also.
There are switches for it in MySQL, but they can be ripped out as long
as the proper functionality remains.
Everything should to get lowercased on creation, and/or the
comparisons need to be done case-insensitively regardless of the
platform/filesystem. The code is already there. Just rip out the other
codepaths.
Cheers,
Arjen.
--
Arjen Lentz, Director @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL & related
technologies
Follow our blog at http://openquery.com/blog/
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
