Index: test/tkt3346.test
==================================================================
--- test/tkt3346.test
+++ test/tkt3346.test
@@ -10,11 +10,11 @@
 #***********************************************************************
 #
 # This file implements regression tests for SQLite library.  The
 # focus of this file is testing the fix for ticket #3346
 #
-# $Id: tkt3346.test,v 1.2 2008/12/09 13:04:29 drh Exp $
+# $Id: tkt3346.test,v 1.3 2008/12/09 13:12:57 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 
 do_test tkt3346-1.1 {
@@ -25,10 +25,28 @@
    INSERT INTO t1 VALUES(3,'claire');
    SELECT *, ( SELECT y FROM (SELECT x.b='alice' AS y) )
      FROM ( SELECT * FROM t1 ) AS x;
   }
 } {2 bob 0 1 alice 1 3 claire 0}
+do_test tkt3346-1.2 {
+  db eval {
+    SELECT b FROM (SELECT * FROM t1) AS x
+     WHERE (SELECT y FROM (SELECT x.b='alice' AS y))=0
+  }
+} {bob claire}
+do_test tkt3346-1.3 {
+  db eval {
+    SELECT b FROM (SELECT * FROM t1 ORDER BY a) AS x
+     WHERE (SELECT y FROM (SELECT a||b y FROM t1 WHERE t1.b=x.b))=(x.a||x.b)
+  }
+} {alice bob claire}
+do_test tkt3346-1.4 {
+  db eval {
+    SELECT b FROM (SELECT * FROM t1 ORDER BY a) AS x
+     WHERE (SELECT y FROM (SELECT a||b y FROM t1 WHERE t1.b=x.b))=('2'||x.b)
+  }
+} {bob}
 
 # Ticket #3530
 #
 # As shown by ticket #3346 above (see also ticket #3298) it is important
 # that a subquery in the result-set be able to look up through multiple