[Bug 250514] Akonadi SQL table names are not correct

Kévin FERRARE timid3000 at gmail.com
Mon Sep 13 10:08:53 BST 2010


https://bugs.kde.org/show_bug.cgi?id=250514





--- Comment #7 from Kévin FERRARE <timid3000 gmail com>  2010-09-13 11:08:52 ---
Yes, Mysql seems to be case sensitive by default which is not a standard
behaviour.
You say that you never used quotes in postgres, if so, please try the following
:
CREATE TABLE "Aa"();
CREATE TABLE "aa"();
That's perfectly valid because "Aa" and "aa" are different

CREATE TABLE Aa();
CREATE TABLE aa();
will throw an error because without quotes, Aa becomes aa so they are the same
table.

In akonadi for example, you attempt to create CollectionAttributeTable, but
collectionattributetable is created instead.

While it works, this is not correct in my opinion, and it makes the database
harder to read.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.


More information about the Kdepim-bugs mailing list