[Digikam-devel] [Bug 189080] comments not saved with digikam 0.10.0 on KDE 4.2.2

[Marcel Wiesweg]

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





--- Comment #7 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-04-12 21:20:40 ---
Ok the cause of this problem is a SQL subtlety that I was not aware of:
"The UNIQUE constraint causes an unique index to be created on the specified
columns. All NULL values are considered different from each other and from all
other values for the purpose of determining uniqueness, hence a UNIQUE column
may contain multiple entries with the value of NULL."
There is a UNIQUE constraint in ImageComments for (imageid, type, language,
author). Now you have identical values for imageid, type and language and NULL
for author. Would author be '' (the empty string) there would not be duplicate
entries.
Now I have to find out how to solve that.

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