Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(2265)

Unified Diff: third_party/sqlite/sqlite-src-3080704/test/tkt-fc7bd6358f.test

Issue 2363173002: [sqlite] Remove obsolete reference version 3.8.7.4. (Closed)
Patch Set: Created 4 years, 3 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
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

Powered by Google App Engine
This is Rietveld 408576698