svn commit: r1567094 - /subversion/trunk/subversion/tests/libsvn_subr/sqlite-test.c

[rh...@apache.org]

Author: rhuijben
Date: Tue Feb 11 12:49:29 2014
New Revision: 1567094

URL: http://svn.apache.org/r1567094
Log:
* subversion/tests/libsvn_subr/sqlite-test.c
  (test_sqlite_reset): Tweak test to remove dependency on non-explicit
    result ordering. Define primary key to predefine index to avoid
    creating a temporary index while running the test, which would
    break this testcase.

Modified:
    subversion/trunk/subversion/tests/libsvn_subr/sqlite-test.c

Modified: subversion/trunk/subversion/tests/libsvn_subr/sqlite-test.c
URL: http://svn.apache.org/viewvc/subversion/trunk/subversion/tests/libsvn_subr/sqlite-test.c?rev=1567094&r1=1567093&r2=1567094&view=diff
==============================================================================
--- subversion/trunk/subversion/tests/libsvn_subr/sqlite-test.c (original)
+++ subversion/trunk/subversion/tests/libsvn_subr/sqlite-test.c Tue Feb 11 12:49:29 2014
@@ -71,13 +71,14 @@ test_sqlite_reset(apr_pool_t *pool)
 
   static const char *const statements[] = {
     "CREATE TABLE reset ("
-    "    one TEXT NOT NULL,"
+    "    one TEXT NOT NULL PRIMARY KEY,"
     "    two TEXT"
     ");"
     "INSERT INTO reset(one, two) VALUES ('foo', 'bar');"
     "INSERT INTO reset(one, two) VALUES ('zig', 'zag')",
 
-    "SELECT one FROM reset WHERE two IS NOT NULL AND error_second(one)",
+    "SELECT one FROM reset WHERE two IS NOT NULL AND error_second(one) "
+    "ORDER BY one",
 
     NULL
   };