diff options
Diffstat (limited to 'test')
| -rw-r--r-- | test/misc3.test | 31 |
1 files changed, 30 insertions, 1 deletions
diff --git a/test/misc3.test b/test/misc3.test index 980ec5a74..1ccc92c7d 100644 --- a/test/misc3.test +++ b/test/misc3.test @@ -13,7 +13,7 @@ # This file implements tests for miscellanous features that were # left out of other test files. # -# $Id: misc3.test,v 1.6 2004/01/14 21:59:24 drh Exp $ +# $Id: misc3.test,v 1.7 2004/02/09 14:35:28 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -207,5 +207,34 @@ do_test misc3-4.3 { } } {64} +# Ticket #601: Putting a left join inside "SELECT * FROM (<join-here>)" +# gives different results that if the outer "SELECT * FROM ..." is omitted. +# +do_test misc4-5.1 { + execsql { + CREATE TABLE x1 (b, c); + INSERT INTO x1 VALUES('dog',3); + INSERT INTO x1 VALUES('cat',1); + INSERT INTO x1 VALUES('dog',4); + CREATE TABLE x2 (c, e); + INSERT INTO x2 VALUES(1,'one'); + INSERT INTO x2 VALUES(2,'two'); + INSERT INTO x2 VALUES(3,'three'); + INSERT INTO x2 VALUES(4,'four'); + SELECT x2.c AS c, e, b FROM x2 LEFT JOIN + (SELECT b, max(c) AS c FROM x1 GROUP BY b) + USING(c); + } +} {1 one cat 2 two {} 3 three {} 4 four dog} +do_test misc4-5.2 { + execsql { + SELECT * FROM ( + SELECT x2.c AS c, e, b FROM x2 LEFT JOIN + (SELECT b, max(c) AS c FROM x1 GROUP BY b) + USING(c) + ); + } +} {1 one cat 2 two {} 3 three {} 4 four dog} + finish_test |