[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