summaryrefslogtreecommitdiff
path: root/components/external/SQLite-3.8.1/test/transitive1.test
diff options
context:
space:
mode:
authorbernard <[email protected]>2017-11-02 13:50:42 +0800
committerbernard <[email protected]>2017-11-02 13:50:42 +0800
commitb2057f506a09e2adef81fc77efd697d16ae14bec (patch)
tree3affefabfe376a0ec1b3ac4a5eef957c1dd58dc8 /components/external/SQLite-3.8.1/test/transitive1.test
parent23582c8129228b4961ad35319cfd2d270039345f (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.test105
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