aboutsummaryrefslogtreecommitdiff
path: root/test/select1.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/select1.test')
-rw-r--r--test/select1.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/test/select1.test b/test/select1.test
index 47dcd0fe4..b4d62554a 100644
--- a/test/select1.test
+++ b/test/select1.test
@@ -1184,5 +1184,18 @@ do_catchsql_test select-19.21 {
ORDER BY 1;
} {1 {table t1 has 1 columns but 15 values were supplied}}
+# 2020-01-01 Found by Yongheng's fuzzer
+#
+reset_db
+do_execsql_test select-20.10 {
+ CREATE TABLE t1 (
+ a INTEGER PRIMARY KEY,
+ b AS('Y') UNIQUE
+ );
+ INSERT INTO t1(a) VALUES (10);
+ SELECT * FROM t1 JOIN t1 USING(a,b)
+ WHERE ((SELECT t1.a FROM t1 AS x GROUP BY b) AND b=0)
+ OR a = 10;
+} {10 Y}
finish_test