diff options
Diffstat (limited to 'test/subselect.test')
| -rw-r--r-- | test/subselect.test | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/test/subselect.test b/test/subselect.test index a43bca355..055e15181 100644 --- a/test/subselect.test +++ b/test/subselect.test @@ -12,7 +12,7 @@ # focus of this file is testing SELECT statements that are part of # expressions. # -# $Id: subselect.test,v 1.14 2007/04/12 03:54:39 drh Exp $ +# $Id: subselect.test,v 1.15 2008/07/15 00:27:35 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -53,9 +53,15 @@ do_test subselect-1.3b { do_test subselect-1.3c { execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)} } {6} -do_test subselect-1.3c { +do_test subselect-1.3d { execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)} } {} +do_test subselect-1.3e { + execsql { + SELECT b FROM t1 + WHERE a = (SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY 1); + } +} {2} # What if the subselect doesn't return any value. We should get # NULL as the result. Check it out. |