Changeset: 1e98748ea422 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1e98748ea422
Modified Files:
sql/test/SQLancer/Tests/sqlancer04.sql
Branch: default
Log Message:
sqlancer type mismatch str := bat[:str]. Code generation problem?
diffs (20 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
@@ -161,3 +161,16 @@ CREATE TABLE t0(c0 INTERVAL SECOND, c1 s
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;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" DOUBLE,"c1" INTERVAL MONTH);
+COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+NULL 1876068957
+NULL 1798321013
+0.8609488658910056 496732801
+0.6220338267946794 1689393833
+
+SELECT 1 FROM t0 WHERE 'b' = COALESCE('1', CASE WHEN 2 THEN 'a' END);
+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;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
