| Index: third_party/sqlite/sqlite-src-3100200/test/tt3_index.c
|
| diff --git a/third_party/sqlite/sqlite-src-3080704/test/tt3_index.c b/third_party/sqlite/sqlite-src-3100200/test/tt3_index.c
|
| similarity index 75%
|
| copy from third_party/sqlite/sqlite-src-3080704/test/tt3_index.c
|
| copy to third_party/sqlite/sqlite-src-3100200/test/tt3_index.c
|
| index b79768c6c71905faa59bdf9826ac30ac4d7f6a25..62f06ade4aac194eda4d0a965a8d0109ea675593 100644
|
| --- a/third_party/sqlite/sqlite-src-3080704/test/tt3_index.c
|
| +++ b/third_party/sqlite/sqlite-src-3100200/test/tt3_index.c
|
| @@ -14,7 +14,7 @@
|
| */
|
|
|
|
|
| -static char *create_drop_index_thread(int iTid, int iArg){
|
| +static char *create_drop_index_thread(int iTid, void *pArg){
|
| Error err = {0}; /* Error code and message */
|
| Sqlite db = {0}; /* SQLite database connection */
|
|
|
| @@ -22,22 +22,22 @@ static char *create_drop_index_thread(int iTid, int iArg){
|
| opendb(&err, &db, "test.db", 0);
|
|
|
| sql_script(&err, &db,
|
| -
|
| "DROP INDEX IF EXISTS i1;"
|
| "DROP INDEX IF EXISTS i2;"
|
| "DROP INDEX IF EXISTS i3;"
|
| "DROP INDEX IF EXISTS i4;"
|
|
|
| - "CREATE INDEX IF NOT EXISTS i1 ON t1(a);"
|
| - "CREATE INDEX IF NOT EXISTS i2 ON t1(b);"
|
| - "CREATE INDEX IF NOT EXISTS i3 ON t1(c);"
|
| - "CREATE INDEX IF NOT EXISTS i4 ON t1(d);"
|
| + "CREATE INDEX IF NOT EXISTS i1 ON t11(a);"
|
| + "CREATE INDEX IF NOT EXISTS i2 ON t11(b);"
|
| + "CREATE INDEX IF NOT EXISTS i3 ON t11(c);"
|
| + "CREATE INDEX IF NOT EXISTS i4 ON t11(d);"
|
|
|
| - "SELECT * FROM t1 ORDER BY a;"
|
| - "SELECT * FROM t1 ORDER BY b;"
|
| - "SELECT * FROM t1 ORDER BY c;"
|
| - "SELECT * FROM t1 ORDER BY d;"
|
| + "SELECT * FROM t11 ORDER BY a;"
|
| + "SELECT * FROM t11 ORDER BY b;"
|
| + "SELECT * FROM t11 ORDER BY c;"
|
| + "SELECT * FROM t11 ORDER BY d;"
|
| );
|
| + clear_error(&err, SQLITE_LOCKED);
|
|
|
| closedb(&err, &db);
|
| }
|
| @@ -53,9 +53,9 @@ static void create_drop_index_1(int nMs){
|
|
|
| opendb(&err, &db, "test.db", 1);
|
| sql_script(&err, &db,
|
| - "CREATE TABLE t1(a, b, c, d);"
|
| + "CREATE TABLE t11(a, b, c, d);"
|
| "WITH data(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM data WHERE x<100) "
|
| - "INSERT INTO t1 SELECT x,x,x,x FROM data;"
|
| + "INSERT INTO t11 SELECT x,x,x,x FROM data;"
|
| );
|
| closedb(&err, &db);
|
|
|
| @@ -67,8 +67,8 @@ static void create_drop_index_1(int nMs){
|
| launch_thread(&err, &threads, create_drop_index_thread, 0);
|
| launch_thread(&err, &threads, create_drop_index_thread, 0);
|
| launch_thread(&err, &threads, create_drop_index_thread, 0);
|
| - sqlite3_enable_shared_cache(0);
|
|
|
| join_all_threads(&err, &threads);
|
| + sqlite3_enable_shared_cache(0);
|
| print_and_free_err(&err);
|
| }
|
|
|