Changeset: da8a610ed29c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/da8a610ed29c
Modified Files:
        sql/test/SQLancer/Tests/sqlancer15.test
Branch: Jul2021
Log Message:

Added function call with subquery on the left side of comparison case


diffs (26 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer15.test 
b/sql/test/SQLancer/Tests/sqlancer15.test
--- a/sql/test/SQLancer/Tests/sqlancer15.test
+++ b/sql/test/SQLancer/Tests/sqlancer15.test
@@ -752,6 +752,22 @@ 0
 69
 9
 
+query T rowsort
+SELECT least((SELECT 1 WHERE FALSE), (SELECT DISTINCT 2 FROM t1)) > -3 FROM t1
+----
+True
+True
+True
+True
+
+query I rowsort
+SELECT t1.c2 FROM t1 WHERE least((SELECT 1 WHERE FALSE), (SELECT 2 FROM t1 
GROUP BY DATE '1970-01-11')) > -3
+----
+-12
+0
+69
+9
+
 statement ok
 ROLLBACK
 
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to