Index: third_party/sqlite/sqlite-src-3100200/test/misc8.test |
diff --git a/third_party/sqlite/sqlite-src-3100200/test/misc8.test b/third_party/sqlite/sqlite-src-3100200/test/misc8.test |
deleted file mode 100644 |
index 3ff52e56f1e203b31fead02be4d910ce6fe4820a..0000000000000000000000000000000000000000 |
--- a/third_party/sqlite/sqlite-src-3100200/test/misc8.test |
+++ /dev/null |
@@ -1,98 +0,0 @@ |
-# 2014-11-10 |
-# |
-# 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. |
-# |
-#*********************************************************************** |
-# This file implements regression tests for SQLite library. |
-# The focus of this script is testing the "eval.c" loadable extension. |
-# |
- |
-set testdir [file dirname $argv0] |
-source $testdir/tester.tcl |
- |
-load_static_extension db eval |
-do_execsql_test misc8-1.0 { |
- CREATE TABLE t1(a,b,c); |
- INSERT INTO t1 VALUES(1,2,3),(4,5,6); |
- SELECT quote(eval('SELECT * FROM t1 ORDER BY a','-abc-')); |
-} {'1-abc-2-abc-3-abc-4-abc-5-abc-6'} |
-do_execsql_test misc8-1.1 { |
- SELECT quote(eval('SELECT * FROM t1 ORDER BY a')); |
-} {{'1 2 3 4 5 6'}} |
-do_catchsql_test misc8-1.2 { |
- SELECT quote(eval('SELECT d FROM t1 ORDER BY a')); |
-} {1 {no such column: d}} |
-do_execsql_test misc8-1.3 { |
- INSERT INTO t1 VALUES(7,null,9); |
- SELECT eval('SELECT * FROM t1 ORDER BY a',','); |
-} {1,2,3,4,5,6,7,,9} |
-do_catchsql_test misc8-1.4 { |
- BEGIN; |
- INSERT INTO t1 VALUES(10,11,12); |
- SELECT a, coalesce(b, eval('ROLLBACK; SELECT ''bam'';')), c |
- FROM t1 ORDER BY a; |
-} {0 {1 2 3 4 5 6 7 bam 9}} |
-do_catchsql_test misc8-1.5 { |
- INSERT INTO t1 VALUES(10,11,12); |
- SELECT a, coalesce(b, eval('SELECT ''bam''')), c |
- FROM t1 |
- ORDER BY rowid; |
-} {0 {1 2 3 4 5 6 7 bam 9 10 11 12}} |
-do_catchsql_test misc8-1.6 { |
- SELECT a, coalesce(b, eval('DELETE FROM t1; SELECT ''bam''')), c |
- FROM t1 |
- ORDER BY rowid; |
-} {0 {1 2 3 4 5 6 7 bam {}}} |
-do_catchsql_test misc8-1.7 { |
- INSERT INTO t1 VALUES(1,2,3),(4,5,6),(7,null,9); |
- BEGIN; |
- CREATE TABLE t2(x); |
- SELECT a, coalesce(b, eval('ROLLBACK; SELECT ''bam''')), c |
- FROM t1 |
- ORDER BY rowid; |
-} {1 {abort due to ROLLBACK}} |
- |
- |
-reset_db |
- |
-proc dbeval {sql} { db eval $sql } |
-db func eval dbeval |
- |
-do_execsql_test misc8-2.1 { |
- CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER) WITHOUT ROWID; |
- CREATE TABLE t2(c INTEGER PRIMARY KEY, d INTEGER, x BLOB); |
- INSERT INTO t1 VALUES(0,0); |
- INSERT INTO t1 VALUES(10,10); |
- INSERT INTO t2 VALUES(1,1,zeroblob(200)); |
- INSERT INTO t2 VALUES(2,2,zeroblob(200)); |
- INSERT INTO t2 VALUES(3,3,zeroblob(200)); |
- INSERT INTO t2 VALUES(4,4,zeroblob(200)); |
- INSERT INTO t2 VALUES(5,5,zeroblob(200)); |
- INSERT INTO t2 VALUES(6,6,zeroblob(200)); |
- INSERT INTO t2 VALUES(7,7,zeroblob(200)); |
- INSERT INTO t2 VALUES(8,8,zeroblob(200)); |
- INSERT INTO t2 VALUES(9,9,zeroblob(200)); |
- INSERT INTO t2 VALUES(10,10,zeroblob(200)); |
- SELECT a, c, eval( |
- printf('DELETE FROM t2 WHERE c=%d AND %d>5', a+c, a+c) |
- ) FROM t1, t2; |
-} { |
- 0 1 {} 10 1 {} |
- 0 2 {} 10 2 {} |
- 0 3 {} 10 3 {} |
- 0 4 {} 10 4 {} |
- 0 5 {} 10 5 {} |
- 0 6 {} 10 {} {} |
- 0 7 {} 10 {} {} |
- 0 8 {} 10 {} {} |
- 0 9 {} 10 {} {} |
- 0 10 {} 10 {} {} |
-} |
- |
- |
-finish_test |