[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-checkins
Subject:    MonetDB: default - One more sqlancer bug, mmath.atan2(X_4858:dbl...
From:       Pedro_Ferreira <commits+pedro.ferreira=monetdbsolutions.com () mon
Date:       2020-07-31 12:32:36
Message-ID: hg.eb8e26def16d.1596198756.-749480422288825700 () monetdb-vm0 ! spin-off ! cwi ! nl
[Download RAW message or body]

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
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list


[prev in list] [next in list] [prev in thread] [next in thread]