| Index: third_party/sqlite/src/test/where8.test
|
| diff --git a/third_party/sqlite/src/test/where8.test b/third_party/sqlite/src/test/where8.test
|
| index a8dd5ed059e6c2f0eb921b980cdb9d9fd3d5ec05..a7d5edb3fd4ddea0fd2b490b3babfba0a7c4b7d0 100644
|
| --- a/third_party/sqlite/src/test/where8.test
|
| +++ b/third_party/sqlite/src/test/where8.test
|
| @@ -286,8 +286,9 @@ do_test where8-3.15 {
|
| SELECT c FROM t1, t2 WHERE a BETWEEN 1 AND 2 OR a = (
|
| SELECT sum(e IS NULL) FROM t2 AS inner WHERE t2.d>inner.d
|
| )
|
| + ORDER BY c
|
| }
|
| -} {I II I II I II I II I II I II III I II III I II III I II III I II III 9 0}
|
| +} {I I I I I I I I I I II II II II II II II II II II III III III III III 9 1}
|
|
|
| #-----------------------------------------------------------------------
|
| # The following tests - where8-4.* - verify that adding or removing
|
| @@ -398,6 +399,10 @@ do_test where8-4.1 {
|
| INSERT INTO t4 VALUES('his', 'of', 378678316.5);
|
| INSERT INTO t4 VALUES(271.2019091, 'viewed', 3282306647);
|
| INSERT INTO t4 VALUES('hills', 'all', 'peak');
|
| + CREATE TABLE t5(s);
|
| + INSERT INTO t5 VALUES('tab-t5');
|
| + CREATE TABLE t6(t);
|
| + INSERT INTO t6 VALUES(123456);
|
| COMMIT;
|
| }
|
| } {}
|
| @@ -639,9 +644,18 @@ foreach idxsql {
|
| 197 { SELECT * FROM t3, t4 WHERE g = 2643383279 AND f = g }
|
| 198 { SELECT * FROM t3, t4 WHERE g < 8979323846 }
|
| 199 { SELECT * FROM t3, t4 WHERE 'are' <= b }
|
| +200 { SELECT * FROM t3, t4 WHERE (a=1415926535 AND f=8628034825)
|
| + OR (a=6939937510 AND f=2643383279) }
|
| +201 { SELECT * FROM t3, t4, t5, t6
|
| + WHERE (a=1415926535 AND f=8628034825 AND s!='hello' AND t!=5)
|
| + OR (a=6939937510 AND f=2643383279 AND s='tab-t5' AND t=123456) }
|
| +202 { SELECT * FROM t3, t4, t5, t6
|
| + WHERE (a=1415926535 AND f=8628034825 AND s!='hello' AND t==5)
|
| + OR (a=6939937510 AND f=2643383279 AND s='tab-t5' AND t!=123456) }
|
|
|
| } {
|
| do_test where8-4.$A.$B.1 {
|
| + unset -nocomplain R
|
| set R [execsql $sql]
|
| if {![info exists results($B)]} {
|
| set results($B) $R
|
|
|