OLD | NEW |
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 Loading... |
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 |
OLD | NEW |