diff options
Diffstat (limited to 'components/external/SQLite-3.8.1/test/join2.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/join2.test | 75 |
1 files changed, 0 insertions, 75 deletions
diff --git a/components/external/SQLite-3.8.1/test/join2.test b/components/external/SQLite-3.8.1/test/join2.test deleted file mode 100644 index 0f558c5a3d..0000000000 --- a/components/external/SQLite-3.8.1/test/join2.test +++ /dev/null @@ -1,75 +0,0 @@ -# 2002 May 24 -# -# 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. -# -# This file implements tests for joins, including outer joins. -# -# $Id: join2.test,v 1.2 2005/01/21 03:12:16 danielk1977 Exp $ - -set testdir [file dirname $argv0] -source $testdir/tester.tcl - -do_test join2-1.1 { - execsql { - CREATE TABLE t1(a,b); - INSERT INTO t1 VALUES(1,11); - INSERT INTO t1 VALUES(2,22); - INSERT INTO t1 VALUES(3,33); - SELECT * FROM t1; - } -} {1 11 2 22 3 33} -do_test join2-1.2 { - execsql { - CREATE TABLE t2(b,c); - INSERT INTO t2 VALUES(11,111); - INSERT INTO t2 VALUES(33,333); - INSERT INTO t2 VALUES(44,444); - SELECT * FROM t2; - } -} {11 111 33 333 44 444}; -do_test join2-1.3 { - execsql { - CREATE TABLE t3(c,d); - INSERT INTO t3 VALUES(111,1111); - INSERT INTO t3 VALUES(444,4444); - INSERT INTO t3 VALUES(555,5555); - SELECT * FROM t3; - } -} {111 1111 444 4444 555 5555} - -do_test join2-1.4 { - execsql { - SELECT * FROM - t1 NATURAL JOIN t2 NATURAL JOIN t3 - } -} {1 11 111 1111} -do_test join2-1.5 { - execsql { - SELECT * FROM - t1 NATURAL JOIN t2 NATURAL LEFT OUTER JOIN t3 - } -} {1 11 111 1111 3 33 333 {}} -do_test join2-1.6 { - execsql { - SELECT * FROM - t1 NATURAL LEFT OUTER JOIN t2 NATURAL JOIN t3 - } -} {1 11 111 1111} -ifcapable subquery { - do_test join2-1.7 { - execsql { - SELECT * FROM - t1 NATURAL LEFT OUTER JOIN (t2 NATURAL JOIN t3) - } - } {1 11 111 1111 2 22 {} {} 3 33 {} {}} -} - -finish_test |
