Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(1)

Unified Diff: third_party/sqlite/sqlite-src-3170000/test/tt3_index.c

Issue 2747283002: [sql] Import reference version of SQLite 3.17.. (Closed)
Patch Set: Created 3 years, 9 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
Index: third_party/sqlite/sqlite-src-3170000/test/tt3_index.c
diff --git a/third_party/sqlite/sqlite-src-3170000/test/tt3_index.c b/third_party/sqlite/sqlite-src-3170000/test/tt3_index.c
new file mode 100644
index 0000000000000000000000000000000000000000..62f06ade4aac194eda4d0a965a8d0109ea675593
--- /dev/null
+++ b/third_party/sqlite/sqlite-src-3170000/test/tt3_index.c
@@ -0,0 +1,74 @@
+/*
+** 2014 December 9
+**
+** The author disclaims copyright to this source code. In place of
+** a legal notice, here is a blessing:
+**
+** May you do good and not evil.
+** May you find forgiveness for yourself and forgive others.
+** May you share freely, never taking more than you give.
+**
+*************************************************************************
+**
+** create_drop_index_1
+*/
+
+
+static char *create_drop_index_thread(int iTid, void *pArg){
+ Error err = {0}; /* Error code and message */
+ Sqlite db = {0}; /* SQLite database connection */
+
+ while( !timetostop(&err) ){
+ 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 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 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);
+ }
+
+ print_and_free_err(&err);
+ return sqlite3_mprintf("ok");
+}
+
+static void create_drop_index_1(int nMs){
+ Error err = {0};
+ Sqlite db = {0};
+ Threadset threads = {0};
+
+ opendb(&err, &db, "test.db", 1);
+ sql_script(&err, &db,
+ "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 t11 SELECT x,x,x,x FROM data;"
+ );
+ closedb(&err, &db);
+
+ setstoptime(&err, nMs);
+
+ sqlite3_enable_shared_cache(1);
+ 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);
+ launch_thread(&err, &threads, create_drop_index_thread, 0);
+ launch_thread(&err, &threads, create_drop_index_thread, 0);
+
+ join_all_threads(&err, &threads);
+ sqlite3_enable_shared_cache(0);
+ print_and_free_err(&err);
+}

Powered by Google App Engine
This is Rietveld 408576698