Revision 6fe8b07...

Go back to digest for 1st December 2013

Features in KDE-PIM

Dan Vratil committed changes in [akonadi/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

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

FIXED-IN: 1.11

File Changes

Added 6 files
  • /src/search
  •   server/searchcollector.cpp
  •   server/searchcollector.h
  •   server/searchinstance.cpp
  •   server/searchinstance.h
  •   server/searchresultsretriever.cpp
  •   server/searchresultsretriever.h
Modified 3 files
  •   server/src/storage/querybuilder.cpp
  •   server/src/storage/querybuilder.h
  •   server/tests/unittest/querybuildertest.cpp
9 files changed in total