Changeset: 9578991e9f5c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9578991e9f5c
Modified Files:
sql/test/SQLancer/Tests/sqlancer04.sql
Branch: default
Log Message:
SQLancer inputs not the same size. I guess the like projection function is
missing a candidate list version?
diffs (29 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer04.sql
b/sql/test/SQLancer/Tests/sqlancer04.sql
--- a/sql/test/SQLancer/Tests/sqlancer04.sql
+++ b/sql/test/SQLancer/Tests/sqlancer04.sql
@@ -174,3 +174,25 @@ SELECT 1 FROM t0 WHERE 'b' = COALESCE('1
SELECT MAX(ALL 0.47279814) FROM t0 WHERE ((r'Vቕ*2DGj!K-?')NOT
ILIKE(COALESCE(r'뷿', upper(r'1285890467'), r'R B+ ]%''?E}%<[cöjö媘թ丅MJV%r&伉',
CASE WHEN -681304440 THEN r'+s' WHEN -2104930505 THEN r'M[' END))) GROUP BY
t0.c0, t0.c1;
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t1" ("c0" CHAR(240));
+COPY 5 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+"2m^OqPm/3DḞZ02"
+"2m^OqPm/3DḞZ02"
+"2m^OqPm/3DḞZ02"
+"2m^OqPm/3DḞZ02"
+"2m^OqPm/3DḞZ02"
+
+SELECT 1 FROM t1 WHERE COALESCE(FALSE, t1.c0 = '0' AND t1.c0 LIKE t1.c0);
+SELECT SUM(agg0) FROM (
+SELECT ALL sum(ALL abs(INTERVAL '1507781126' SECOND)) as agg0 FROM t1
+WHERE COALESCE(FALSE, (((((((((((t1.c0) NOT BETWEEN ASYMMETRIC (t1.c0) AND
(t1.c0))AND(((t1.c0)>=(t1.c0)))))AND(NOT
(TRUE))))AND(((t1.c0)LIKE(t1.c0)))))AND(((t1.c0)NOT
ILIKE(t1.c0)))))OR(COALESCE(FALSE, FALSE))))
+UNION ALL
+SELECT sum(ALL abs(INTERVAL '1507781126' SECOND)) as agg0 FROM t1
+WHERE NOT (COALESCE(FALSE, (((((((((((t1.c0) NOT BETWEEN ASYMMETRIC (t1.c0)
AND (t1.c0))AND(((t1.c0)>=(t1.c0)))))AND(NOT
(TRUE))))AND(((t1.c0)LIKE(t1.c0)))))AND(((t1.c0)NOT
ILIKE(t1.c0)))))OR(COALESCE(FALSE, FALSE)))))
+UNION ALL
+SELECT sum(ALL abs(INTERVAL '1507781126' SECOND)) as agg0 FROM t1
+WHERE (COALESCE(FALSE, (((((((((((t1.c0) NOT BETWEEN ASYMMETRIC (t1.c0) AND
(t1.c0))AND(((t1.c0)>=(t1.c0)))))AND(NOT
(TRUE))))AND(((t1.c0)LIKE(t1.c0)))))AND(((t1.c0)NOT
ILIKE(t1.c0)))))OR(COALESCE(FALSE, FALSE))))) IS NULL)
+as asdf;
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
