[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

RE: svn commit: r1879198 - /subversion/trunk/subversion/libsvn_wc/wc-metadata.sql

From: <bert_at_qqmail.nl>
Date: Thu, 25 Jun 2020 19:41:37 +0200

It looks like you get failures on this when you compile recent SQLite versions with OMIT_DEPRECATED.
(I just bumped several dependencies on the Windows buildbot in an attempt to fix the python breakage)

This should probably be backported...

        Bert

-----Oorspronkelijk bericht-----
Van: rhuijben_at_apache.org <rhuijben_at_apache.org>
Verzonden: donderdag 25 juni 2020 19:12
Aan: commits_at_subversion.apache.org
Onderwerp: svn commit: r1879198 - /subversion/trunk/subversion/libsvn_wc/wc-metadata.sql

Author: rhuijben
Date: Thu Jun 25 17:11:44 2020
New Revision: 1879198

URL: http://svn.apache.org/viewvc?rev=1879198&view=rev
Log:
Fix invalid escape sequence in working copy queries which causes
upgrades from Subversion 1.7 working copies to fail with recent
SQLite versions (>= 3.29.0).

* subversion/libsvn_wc/wc-metadata.sql
  (STMT_UPGRADE_TO_30): Use '' to delimit values and "" to escape column names.

Modified:
    subversion/trunk/subversion/libsvn_wc/wc-metadata.sql

Modified: subversion/trunk/subversion/libsvn_wc/wc-metadata.sql
URL: http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_wc/wc-metadata.sql?rev=1879198&r1=1879197&r2=1879198&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_wc/wc-metadata.sql (original)
+++ subversion/trunk/subversion/libsvn_wc/wc-metadata.sql Thu Jun 25 17:11:44 2020
@@ -636,7 +636,7 @@ ON NODES (wc_id, moved_to, op_depth);
 
 CREATE INDEX IF NOT EXISTS I_PRISTINE_MD5 ON PRISTINE (md5_checksum);
 
-UPDATE nodes SET presence = "server-excluded" WHERE presence = "absent";
+UPDATE nodes SET presence = 'server-excluded' WHERE presence = 'absent';
 
 /* Just to be sure clear out file external skels from pre 1.7.0 development
    working copies that were never updated by 1.7.0+ style clients */
Received on 2020-06-25 19:41:52 CEST

This is an archived mail posted to the Subversion Dev mailing list.