[Kmymoney-devel] [kmymoney4] [Bug 341304] New: upgrade database to version 1 does not work with sqlite

[Christian David]

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

            Bug ID: 341304
           Summary: upgrade database to version 1 does not work with
                    sqlite
           Product: kmymoney4
           Version: git master
          Platform: Compiled Sources
                OS: All
            Status: UNCONFIRMED
          Severity: minor
          Priority: NOR
         Component: database
          Assignee: kmymoney-devel at kde.org
          Reporter: christian-david at web.de

MyMoneyStorageSql::upgradeToV1() uses the query "ALTER TABLE kmmSplits ADD
PRIMARY KEY (transactionId, splitId);" which will always fail in SQLite because
it does not support adding primary keys in alter table
(http://sqlite.org/lang_altertable.html).

KMyMoney will not open SQLite databases of version 0 - that issue must be there
for five years already. So we have to decide if it will be fixed as nobody
complained before. I found it only because the databasemrgtest persistently
fails/crashes on my system.

-- 
You are receiving this mail because:
You are the assignee for the bug.