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

BATproject2: does not match always Looking into it


diffs (25 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer14.test 
b/sql/test/SQLancer/Tests/sqlancer14.test
--- a/sql/test/SQLancer/Tests/sqlancer14.test
+++ b/sql/test/SQLancer/Tests/sqlancer14.test
@@ -743,3 +743,21 @@ merge into t2 using (select * from t1) a
 
 statement ok
 ROLLBACK
+
+statement ok
+CREATE TABLE t0(c0 boolean, c1 int, c3 boolean)
+
+statement ok rowcount 1
+INSERT INTO t0(c1, c0) VALUES(3, false)
+
+statement ok rowcount 1
+INSERT INTO t0(c3, c1) VALUES(TRUE, 9)
+
+query T rowsort
+SELECT 'a' LIKE ifthenelse(t0.c3, (SELECT 'v' FROM t0 GROUP BY (SELECT 1 FROM 
t0 HAVING min(least(t0.c0, (SELECT FALSE GROUP BY 3)) AND t0.c3))), 's') FROM t0
+----
+False
+False
+
+statement ok
+DROP TABLE t0
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to