Changeset: eb8e26def16d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eb8e26def16d
Modified Files:
sql/test/SQLancer/Tests/sqlancer04.sql
Branch: default
Log Message:
One more sqlancer bug, mmath.atan2(X_4858:dbl, X_4860:dbl, nil:BAT, nil:BAT)
undefined. I think this is a leftover from the ce cleanup
diffs (13 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
@@ -155,3 +155,9 @@ SELECT ALL MAX(ALL CASE WHEN (DATE '1970-01-04') IS NULL
THEN CAST(CASE t1.c0 WHEN t1.c0 THEN TIME '11:33:56' END AS VARCHAR(524)) ELSE
sql_max(r'iDfwsFjp藖1J洅ៅR-?0OT^.', r'0.6') END) FROM t1
JOIN (SELECT ALL t0.c0, greatest(CAST(INTERVAL '6' SECOND AS TIME), TIME
'10:25:00') FROM t1, t0) AS sub0 ON (COALESCE(-3, -6, 3)) NOT IN (CASE WHEN
TRUE THEN -3 END, ((-4)&(-5)), - (6))
WHERE ((r'%')ILIKE(r'6')) GROUP BY COALESCE(CAST(least(0.4, 0.7) AS
VARCHAR(506)), CAST(nullif(TIME '14:14:35', TIME '02:49:23') AS VARCHAR(388))),
abs(0.6);
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE t0(c0 INTERVAL SECOND, c1 serial);
+create view v0(c0) as (select distinct t0.c1 from t0);
+SELECT ALL AVG(ALL CASE COALESCE(CAST(v0.c0 AS REAL), atan(v0.c0, v0.c0)) WHEN
abs(0.7471649) THEN INTERVAL '1865286244' MONTH END) FROM v0 GROUP BY
COALESCE(((((v0.c0)+(v0.c0)))&(v0.c0)), v0.c0, CAST("second"(TIME '01:32:22')
AS INT));
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
