[#CIB-1011] Case sensitivity of DB identifier names

Pulse

Case sensitivity of DB identifier names

Created: 15/Mar/07 05:43 AM Updated: 21/Mar/07 02:11 PM

Component/s:

None

Affects Version/s:

1.2.19

Fix Version/s:

1.2.20

Description

« Hide

MySQL is the first supported database that treats identifiers case-sensitively, but only on some platforms:

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Note that only database and table names are affected. This affects the SQL used in upgrade tasks: they must all use the same case for table names.

All

Comments

Change History

Sort Order:

[ Permlink | « Hide ]

jason - 15/Mar/07 08:28 AM

I have added a note to the wiki mentioning this issue and the current workaround for non-Windows platforms.

[ Permlink | « Hide ]

jason - 21/Mar/07 02:10 PM

Immediate problems in upgrade tasks fixed in change 3144. all tables use uppercase, and we need to keep it that way (upgrade tests will detect any problems). Further DB refactoring needs to wait until 2.0.