https://bugs.kde.org/show_bug.cgi?id=305543
Daniel Vrátil <dvra...@redhat.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CONFIRMED |RESOLVED Version Fixed In| |1.11 Resolution|--- |FIXED Latest Commit| |http://commits.kde.org/akon | |adi/6fe8b071f183d64dd934663 | |c8cd1c5e4d587d93d --- Comment #7 from Daniel Vrátil <dvra...@redhat.com> --- Git commit 6fe8b071f183d64dd934663c8cd1c5e4d587d93d by Dan Vrátil. Committed on 27/11/2013 at 20:44. Pushed by dvratil into branch '1.11'. SQLite: Handle joins in UPDATE queries Since SQLite does not directly support JOIN expression in UPDATE or UPDATE on multiple tables at once, we have to convert the JOIN into a subquery in WHERE condition. The conversion is far from perfect, but it passes the unit-tests based on the query that does this (I think there's only one such query in Akonadi that does this, see FetchHelper::updateItemAccessTime()) This fixes updating atime on items from virtual collections when using SQLite backend. FIXED-IN: 1.11 A +88 -0 server/src/search/searchcollector.cpp [License: LGPL (v2+)] A +98 -0 server/src/search/searchcollector.h [License: LGPL (v2+)] A +62 -0 server/src/search/searchinstance.cpp [License: LGPL (v2+)] A +47 -0 server/src/search/searchinstance.h [License: LGPL (v2+)] A +82 -0 server/src/search/searchresultsretriever.cpp [License: LGPL (v2+)] A +57 -0 server/src/search/searchresultsretriever.h [License: LGPL (v2+)] M +52 -6 server/src/storage/querybuilder.cpp M +7 -0 server/src/storage/querybuilder.h M +18 -2 server/tests/unittest/querybuildertest.cpp http://commits.kde.org/akonadi/6fe8b071f183d64dd934663c8cd1c5e4d587d93d -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs