diff options
| author | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
|---|---|---|
| committer | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
| commit | b2057f506a09e2adef81fc77efd697d16ae14bec (patch) | |
| tree | 3affefabfe376a0ec1b3ac4a5eef957c1dd58dc8 /components/external/SQLite-3.8.1/test/transitive1.test | |
| parent | 23582c8129228b4961ad35319cfd2d270039345f (diff) | |
[External] Remove external from RT-Thread
Diffstat (limited to 'components/external/SQLite-3.8.1/test/transitive1.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/transitive1.test | 105 |
1 files changed, 0 insertions, 105 deletions
diff --git a/components/external/SQLite-3.8.1/test/transitive1.test b/components/external/SQLite-3.8.1/test/transitive1.test deleted file mode 100644 index 4cf439bb45..0000000000 --- a/components/external/SQLite-3.8.1/test/transitive1.test +++ /dev/null @@ -1,105 +0,0 @@ -# 2013 April 17 -# -# 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 of transitive WHERE clause constraints -# - -set testdir [file dirname $argv0] -source $testdir/tester.tcl - -do_execsql_test transitive1-100 { - CREATE TABLE t1(a TEXT, b TEXT, c TEXT COLLATE NOCASE); - INSERT INTO t1 VALUES('abc','abc','Abc'); - INSERT INTO t1 VALUES('def','def','def'); - INSERT INTO t1 VALUES('ghi','ghi','GHI'); - CREATE INDEX t1a1 ON t1(a); - CREATE INDEX t1a2 ON t1(a COLLATE nocase); - - SELECT * FROM t1 WHERE a=b AND c=b AND c='DEF'; -} {def def def} -do_execsql_test transitive1-110 { - SELECT * FROM t1 WHERE a=b AND c=b AND c>='DEF' ORDER BY +a; -} {def def def ghi ghi GHI} -do_execsql_test transitive1-120 { - SELECT * FROM t1 WHERE a=b AND c=b AND c<='DEF' ORDER BY +a; -} {abc abc Abc def def def} - -do_execsql_test transitive1-200 { - CREATE TABLE t2(a INTEGER, b INTEGER, c TEXT); - INSERT INTO t2 VALUES(100,100,100); - INSERT INTO t2 VALUES(20,20,20); - INSERT INTO t2 VALUES(3,3,3); - - SELECT * FROM t2 WHERE a=b AND c=b AND c=20; -} {20 20 20} -do_execsql_test transitive1-210 { - SELECT * FROM t2 WHERE a=b AND c=b AND c>=20 ORDER BY +a; -} {3 3 3 20 20 20} -do_execsql_test transitive1-220 { - SELECT * FROM t2 WHERE a=b AND c=b AND c<=20 ORDER BY +a; -} {20 20 20 100 100 100} - -# Test cases for ticket [[d805526eae253103] 2013-07-08 -# "Incorrect join result or assertion fault due to transitive constraints" -# -do_execsql_test transitive1-300 { - CREATE TABLE t301(w INTEGER PRIMARY KEY, x); - CREATE TABLE t302(y INTEGER UNIQUE, z); - INSERT INTO t301 VALUES(1,2),(3,4),(5,6); - INSERT INTO t302 VALUES(1,3),(3,6),(5,7); - SELECT * - FROM t301 CROSS JOIN t302 - WHERE w=y AND y IS NOT NULL - ORDER BY +w; -} {1 2 1 3 3 4 3 6 5 6 5 7} -do_execsql_test transitive1-301 { - SELECT * - FROM t301 CROSS JOIN t302 - WHERE w=y AND y IS NOT NULL - ORDER BY w; -} {1 2 1 3 3 4 3 6 5 6 5 7} -do_execsql_test transitive1-310 { - SELECT * - FROM t301 CROSS JOIN t302 ON w=y - WHERE y>1 - ORDER BY +w -} {3 4 3 6 5 6 5 7} -do_execsql_test transitive1-311 { - SELECT * - FROM t301 CROSS JOIN t302 ON w=y - WHERE y>1 - ORDER BY w -} {3 4 3 6 5 6 5 7} -do_execsql_test transitive1-312 { - SELECT * - FROM t301 CROSS JOIN t302 ON w=y - WHERE y>1 - ORDER BY w DESC -} {5 6 5 7 3 4 3 6} -do_execsql_test transitive1-320 { - SELECT * - FROM t301 CROSS JOIN t302 ON w=y - WHERE y BETWEEN 2 AND 4; -} {3 4 3 6} -do_execsql_test transitive1-331 { - SELECT * - FROM t301 CROSS JOIN t302 ON w=y - WHERE y BETWEEN 1 AND 4 - ORDER BY w; -} {1 2 1 3 3 4 3 6} -do_execsql_test transitive1-332 { - SELECT * - FROM t301 CROSS JOIN t302 ON w=y - WHERE y BETWEEN 1 AND 4 - ORDER BY w DESC; -} {3 4 3 6 1 2 1 3} - -finish_test |
