[Akonadi] [Bug 305543] "Paramter count mismatch" during akonadi start-up due to broken SQL query

[Daniel Vrátil]

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

Daniel Vrátil <dvratil at 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 <dvratil at 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.