[Akonadi] [Bug 402229] Sqlite backend error with schema update 36 & 37 (5.10.0)

[Daniel Vrátil]

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

--- Comment #5 from Daniel Vrátil <dvratil at kde.org> ---
Git commit 42d6c38c4dc619f23ca00ad42d9c538fc9ca2f78 by Daniel Vrátil, on behalf
of Konrad Rzepecki.
Committed on 06/02/2019 at 17:14.
Pushed by dvratil into branch 'Applications/18.12'.

Fix SQLite backend foreign key PRAGMAs

Summary:
SQLite backend contain "PRAGMA foreign_key_check=OFF/ON" which ins't correct
SQLite syntax.  Author intention was probably disengage key checking. In
SQLlite this can be achieved be temporary deffer key check.  Correct syntax is
in this case "PRAGMA defer_foreign_keys=ON/OFF".  This partial resolves bug
402229.

Reviewers: dvratil

Reviewed By: dvratil

Subscribers: lbeltrame, anthonyfieroni, kde-pim

Tags: #kde_pim

Differential Revision: https://phabricator.kde.org/D18781

M  +46   -46   autotests/server/dbtest_data/dbinit_sqlite
M  +50   -50   autotests/server/dbtest_data/dbinit_sqlite_incremental
M  +2    -2    src/server/storage/dbinitializer_p.cpp

https://commits.kde.org/akonadi/42d6c38c4dc619f23ca00ad42d9c538fc9ca2f78

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