svn commit: r1664483 - in /subversion/trunk/subversion: libsvn_wc/wc-queries.sql tests/libsvn_wc/wc-queries-test.c

[rhuijben]

Author: rhuijben
Date: Thu Mar  5 21:05:03 2015
New Revision: 1664483

URL: http://svn.apache.org/r1664483
Log:
Following up on r1664476, r1664480, r1664481 fix statement definition to not
fail the wc-queries tests.

* subversion/libsvn_wc/wc-queries.sql
  (STMT_HAVE_STAT1_TABLE): Remove unneeded ';' that made sqlite ignore the
    LIMIT. Use lower case for column names.

* subversion/tests/libsvn_wc/wc-queries-test.c
  (slow_statements): Add STMT_HAVE_STAT1_TABLE.

Modified:
    subversion/trunk/subversion/libsvn_wc/wc-queries.sql
    subversion/trunk/subversion/tests/libsvn_wc/wc-queries-test.c

Modified: subversion/trunk/subversion/libsvn_wc/wc-queries.sql
URL: 
http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_wc/wc-queries.sql?rev=1664483&r1=1664482&r2=1664483&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_wc/wc-queries.sql (original)
+++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Thu Mar  5 21:05:03 
2015
@@ -1782,7 +1782,7 @@ WHERE wc_id = ?1
   AND (inherited_props not null)
 
 -- STMT_HAVE_STAT1_TABLE
-SELECT 1 FROM sqlite_master WHERE NAME='sqlite_stat1' AND TYPE='table';
+SELECT 1 FROM sqlite_master WHERE name='sqlite_stat1' AND type='table'
 LIMIT 1
 
 /* ------------------------------------------------------------------------- */

Modified: subversion/trunk/subversion/tests/libsvn_wc/wc-queries-test.c
URL: 
http://svn.apache.org/viewvc/subversion/trunk/subversion/tests/libsvn_wc/wc-queries-test.c?rev=1664483&r1=1664482&r2=1664483&view=diff
==============================================================================
--- subversion/trunk/subversion/tests/libsvn_wc/wc-queries-test.c (original)
+++ subversion/trunk/subversion/tests/libsvn_wc/wc-queries-test.c Thu Mar  5 
21:05:03 2015
@@ -108,6 +108,7 @@ static const int slow_statements[] =
   /* Slow, but just if foreign keys are enabled:
    * STMT_DELETE_PRISTINE_IF_UNREFERENCED,
    */
+  STMT_HAVE_STAT1_TABLE, /* Queries sqlite_master which has no index */
 
   -1 /* final marker */
 };