-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Arjen Lentz wrote: > 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.
+1 from me. Can we get a verification on the SQL standard? If it says case-insensitive identifiers, I think it's reasonable to have Drizzle use case-insensitive identifiers for all identifiers. Like Eric B says, it is the inconsistency which is unfortunate. I prefer consistency over anything else, and if the SQL standard says case-insensitive, I think we should do all case-insensitive identifiers. I don't think it would be too difficult to make this happen. I will work on putting together a comprehensive test case for all identifiers. >> 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. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAknz7bYACgkQ2upbWsB4UtGsywCfQLG88C+OKyo83Au6G2XxXmtu mUsAn1WAEFsRlojO8dl8oLQkR446ld86 =s+Za -----END PGP SIGNATURE----- _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
