Index: third_party/sqlite/src/test/selectA.test |
diff --git a/third_party/sqlite/src/test/selectA.test b/third_party/sqlite/src/test/selectA.test |
index 0338338902093da173ddf0015d03f5e614e86e3a..78d04be15d4ad047347ae57919eac23bf4613088 100644 |
--- a/third_party/sqlite/src/test/selectA.test |
+++ b/third_party/sqlite/src/test/selectA.test |
@@ -1434,5 +1434,14 @@ do_catchsql_test 5.4 { |
SELECT * FROM t8 UNION SELECT * FROM t9 ORDER BY a+b COLLATE NOCASE |
} {1 {1st ORDER BY term does not match any column in the result set}} |
+do_execsql_test 6.1 { |
+ DROP TABLE IF EXISTS t1; |
+ DROP TABLE IF EXISTS t2; |
+ CREATE TABLE t1(a INTEGER); |
+ CREATE TABLE t2(b TEXT); |
+ INSERT INTO t2(b) VALUES('12345'); |
+ SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t2) WHERE a=a; |
+} {12345} |
+ |
finish_test |