diff options
| author | Sam Thursfield <sam@afuera.me.uk> | 2021-06-21 20:13:05 +0000 |
|---|---|---|
| committer | Sam Thursfield <sam@afuera.me.uk> | 2021-06-21 20:13:05 +0000 |
| commit | dca46303f4aaee4e6b58137472d8294a89451f05 (patch) | |
| tree | 362d51a9d93124a75beb45180bfe2e6cd65aeda0 | |
| parent | 22a162489690721b3df2f1a5846556d3ee9cfc35 (diff) | |
| parent | e36f74cdc3e948c9137ae5d2c91c0883005f3f7d (diff) | |
| download | tracker-dca46303f4aaee4e6b58137472d8294a89451f05.tar.gz | |
Merge branch 'wip/carlosg/no-update-from' into 'master'
libtracker-data: Avoid "UPDATE ... FROM ..." SQL syntax
Closes #307
See merge request GNOME/tracker!445
| -rw-r--r-- | src/libtracker-data/tracker-data-manager.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/libtracker-data/tracker-data-manager.c b/src/libtracker-data/tracker-data-manager.c index 775f561a0..f3104b980 100644 --- a/src/libtracker-data/tracker-data-manager.c +++ b/src/libtracker-data/tracker-data-manager.c @@ -4859,9 +4859,9 @@ tracker_data_manager_copy_graph (TrackerDataManager *manager, tracker_db_interface_execute_query (iface, &inner_error, "UPDATE \"%s\".Refcount AS B " - "SET Refcount = B.Refcount + A.Refcount " - "FROM (SELECT ID, Refcount FROM \"%s\".Refcount) AS A " - "WHERE B.ID = A.ID", + "SET Refcount = Refcount + " + "(SELECT Refcount FROM \"%s\".Refcount AS A " + "WHERE B.ID = A.ID)", destination, source); out: if (inner_error) { |