diff options
Diffstat (limited to 'third_party/sqlite/test/select6.test')
| -rw-r--r-- | third_party/sqlite/test/select6.test | 14 |
1 files changed, 12 insertions, 2 deletions
diff --git a/third_party/sqlite/test/select6.test b/third_party/sqlite/test/select6.test index 7223b5e..ef0bfd5 100644 --- a/third_party/sqlite/test/select6.test +++ b/third_party/sqlite/test/select6.test @@ -12,7 +12,7 @@ # focus of this file is testing SELECT statements that contain # subqueries in their FROM clause. # -# $Id: select6.test,v 1.27 2008/07/12 14:52:20 drh Exp $ +# $Id: select6.test,v 1.29 2009/01/09 01:12:28 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -300,7 +300,7 @@ do_test select6-5.2 { # Tests of compound sub-selects # -do_test select5-6.1 { +do_test select6-6.1 { execsql { DELETE FROM t1 WHERE x>4; SELECT * FROM t1 @@ -500,6 +500,16 @@ do_test select6-9.9 { SELECT x FROM (SELECT x FROM t1 LIMIT -1 OFFSET 1); } } {2 3 4} +do_test select6-9.10 { + execsql { + SELECT x, y FROM (SELECT x, (SELECT 10+x) y FROM t1 LIMIT -1 OFFSET 1); + } +} {2 12 3 13 4 14} +do_test select6-9.11 { + execsql { + SELECT x, y FROM (SELECT x, (SELECT 10)+x y FROM t1 LIMIT -1 OFFSET 1); + } +} {2 12 3 13 4 14} |