diff options
| author | danielk1977 <danielk1977@noemail.net> | 2009-04-02 17:23:32 +0000 |
|---|---|---|
| committer | danielk1977 <danielk1977@noemail.net> | 2009-04-02 17:23:32 +0000 |
| commit | e1fb65a0b83dd38692cdd81b37f6e1096f9b883f (patch) | |
| tree | 40ac0abcde3b8e80aadee2f547024427df712f16 /test/select1.test | |
| parent | de4679856939f285fb796efabe2d0dcd37a8adde (diff) | |
| download | sqlite-e1fb65a0b83dd38692cdd81b37f6e1096f9b883f.tar.gz sqlite-e1fb65a0b83dd38692cdd81b37f6e1096f9b883f.zip | |
Ensure the required VerifyCookie/Transaction/TableLock opcodes are added for "x
IN (SELECT c FROM t)" expressions. Ticket #3771. (CVS 6439)
FossilOrigin-Name: 058a2f20930d7707c03c3c27db8e761d5657ee46
Diffstat (limited to 'test/select1.test')
| -rw-r--r-- | test/select1.test | 22 |
1 files changed, 21 insertions, 1 deletions
diff --git a/test/select1.test b/test/select1.test index 59c3b5878..145a982d6 100644 --- a/test/select1.test +++ b/test/select1.test @@ -11,7 +11,7 @@ # This file implements regression tests for SQLite library. The # focus of this file is testing the SELECT statement. # -# $Id: select1.test,v 1.65 2008/08/04 03:51:24 danielk1977 Exp $ +# $Id: select1.test,v 1.66 2009/04/02 17:23:33 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -1041,4 +1041,24 @@ do_test select1-14.2 { } } {0} +# Check that ticket #3771 has been fixed. +# +do_test select1-15.1 { + execsql { + CREATE TABLE t1(a); + CREATE INDEX i1 ON t1(a); + INSERT INTO t1 VALUES(1); + INSERT INTO t1 VALUES(2); + INSERT INTO t1 VALUES(3); + } +} {} +do_test select1-15.2 { + sqlite3 db2 test.db + execsql { DROP INDEX i1 } db2 + db2 close +} {} +do_test select1-15.3 { + execsql { SELECT 2 IN (SELECT a FROM t1) } +} {1} + finish_test |