| Index: third_party/sqlite/sqlite-src-3080704/test/tkt-fc7bd6358f.test
|
| diff --git a/third_party/sqlite/sqlite-src-3080704/test/tkt-fc7bd6358f.test b/third_party/sqlite/sqlite-src-3080704/test/tkt-fc7bd6358f.test
|
| deleted file mode 100644
|
| index a1b13c463c70c42bed43eb9b214c1bac3bcd8ffd..0000000000000000000000000000000000000000
|
| --- a/third_party/sqlite/sqlite-src-3080704/test/tkt-fc7bd6358f.test
|
| +++ /dev/null
|
| @@ -1,78 +0,0 @@
|
| -# 2013 March 05
|
| -#
|
| -# 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. Specifically,
|
| -# it tests that ticket [fc7bd6358f]:
|
| -#
|
| -# The following SQL yields an incorrect result (zero rows) in all
|
| -# versions of SQLite between 3.6.14 and 3.7.15.2:
|
| -#
|
| -# CREATE TABLE t(textid TEXT);
|
| -# INSERT INTO t VALUES('12');
|
| -# INSERT INTO t VALUES('34');
|
| -# CREATE TABLE i(intid INTEGER PRIMARY KEY);
|
| -# INSERT INTO i VALUES(12);
|
| -# INSERT INTO i VALUES(34);
|
| -#
|
| -# SELECT t1.textid AS a, i.intid AS b, t2.textid AS c
|
| -# FROM t t1, i, t t2
|
| -# WHERE t1.textid = i.intid
|
| -# AND t1.textid = t2.textid;
|
| -#
|
| -# The correct result should be two rows, one with 12|12|12 and the other
|
| -# with 34|34|34. With this bug, no rows are returned. Bisecting shows that
|
| -# this bug was introduced with check-in [dd4d67a67454] on 2009-04-23.
|
| -#
|
| -
|
| -set testdir [file dirname $argv0]
|
| -source $testdir/tester.tcl
|
| -
|
| -do_test tkt-fc7bd6358f.100 {
|
| - db eval {
|
| - CREATE TABLE t(textid TEXT);
|
| - INSERT INTO t VALUES('12');
|
| - INSERT INTO t VALUES('34');
|
| - CREATE TABLE i(intid INTEGER PRIMARY KEY);
|
| - INSERT INTO i VALUES(12);
|
| - INSERT INTO i VALUES(34);
|
| - }
|
| -} {}
|
| -unset -nocomplain from
|
| -unset -nocomplain where
|
| -unset -nocomplain a
|
| -unset -nocomplain b
|
| -foreach {a from} {
|
| - 1 {FROM t t1, i, t t2}
|
| - 2 {FROM i, t t1, t t2}
|
| - 3 {FROM t t1, t t2, i}
|
| -} {
|
| - foreach {b where} {
|
| - 1 {WHERE t1.textid=i.intid AND t1.textid=t2.textid}
|
| - 2 {WHERE i.intid=t1.textid AND t1.textid=t2.textid}
|
| - 3 {WHERE t1.textid=i.intid AND i.intid=t2.textid}
|
| - 4 {WHERE t1.textid=i.intid AND t2.textid=i.intid}
|
| - 5 {WHERE i.intid=t1.textid AND i.intid=t2.textid}
|
| - 6 {WHERE i.intid=t1.textid AND t2.textid=i.intid}
|
| - 7 {WHERE t1.textid=t2.textid AND i.intid=t2.textid}
|
| - 8 {WHERE t1.textid=t2.textid AND t2.textid=i.intid}
|
| - } {
|
| - do_test tkt-fc7bd6358f.110.$a.$b.1 {
|
| - db eval {PRAGMA automatic_index=ON}
|
| - db eval "SELECT t1.textid, i.intid, t2.textid $from $where"
|
| - } {12 12 12 34 34 34}
|
| - do_test tkt-fc7bd6358f.110.$a.$b.2 {
|
| - db eval {PRAGMA automatic_index=OFF}
|
| - db eval "SELECT t1.textid, i.intid, t2.textid $from $where"
|
| - } {12 12 12 34 34 34}
|
| - }
|
| -}
|
| -
|
| -
|
| -finish_test
|
|
|