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

Side by Side Diff: third_party/sqlite/src/test/where2.test

Issue 2751253002: [sql] Import SQLite 3.17.0. (Closed)
Patch Set: also clang on Linux i386 Created 3 years, 9 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 unified diff | Download patch
« no previous file with comments | « third_party/sqlite/src/test/where.test ('k') | third_party/sqlite/src/test/where3.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
1 # 2005 July 28 1 # 2005 July 28
2 # 2 #
3 # The author disclaims copyright to this source code. In place of 3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing: 4 # a legal notice, here is a blessing:
5 # 5 #
6 # May you do good and not evil. 6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others. 7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give. 8 # May you share freely, never taking more than you give.
9 # 9 #
10 #*********************************************************************** 10 #***********************************************************************
(...skipping 747 matching lines...) Expand 10 before | Expand all | Expand 10 after
758 758
759 # Verify that all necessary OP_OpenRead opcodes occur in the OR optimization. 759 # Verify that all necessary OP_OpenRead opcodes occur in the OR optimization.
760 # 760 #
761 do_execsql_test where2-13.1 { 761 do_execsql_test where2-13.1 {
762 CREATE TABLE t13(a,b); 762 CREATE TABLE t13(a,b);
763 CREATE INDEX t13a ON t13(a); 763 CREATE INDEX t13a ON t13(a);
764 INSERT INTO t13 VALUES(4,5); 764 INSERT INTO t13 VALUES(4,5);
765 SELECT * FROM t13 WHERE (1=2 AND a=3) OR a=4; 765 SELECT * FROM t13 WHERE (1=2 AND a=3) OR a=4;
766 } {4 5} 766 } {4 5}
767 767
768 # https://www.sqlite.org/src/info/5e3c886796e5512e (2016-03-09)
769 # Correlated subquery on the RHS of an IN operator
770 #
771 do_execsql_test where2-14.1 {
772 CREATE TABLE t14a(x INTEGER PRIMARY KEY);
773 INSERT INTO t14a(x) VALUES(1),(2),(3),(4);
774 CREATE TABLE t14b(y INTEGER PRIMARY KEY);
775 INSERT INTO t14b(y) VALUES(1);
776 SELECT x FROM t14a WHERE x NOT IN (SELECT x FROM t14b);
777 } {}
778
768 finish_test 779 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/where.test ('k') | third_party/sqlite/src/test/where3.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698