MonetDB: default - SQLancer bat.replace undefined. For now lets ...

[Pedro Ferreira]

Changeset: d3ca01324140 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d3ca01324140
Modified Files:
        sql/test/SQLancer/Tests/sqlancer04.sql
Branch: default
Log Message:

SQLancer bat.replace undefined. For now lets fix these bugs before running 
SQLancer again


diffs (36 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
@@ -89,3 +89,32 @@ create view v2(c0) as (select distinct coalesce(abs(interval 
'-1976292283' month), cast(greatest(r'Dnwxjm4btQ9cp&\c''a_', r'(y7,{q?][NHU,') 
as interval month)) from t1, t0 where ((upper(r''))not ilike(lower(r'''wAg_ z 
''PPxXßgrd⍮G'))));
 select all v2.c0 from v2 right outer join v1 on 
((r'8*By1q)*Oc<n')like(substr(r'', 1151312829, 406714197))) 
 where (case v1.c0 when v1.c0 then interval '104279220' second end) in 
(interval '2129103763' second) group by timestamp '1970-01-21 14:05:46';
 ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" DOUBLE NOT NULL DEFAULT 0.7383512, "c1" 
VARCHAR(277),CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"),CONSTRAINT 
"t0_c0_unique" UNIQUE ("c0"),CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
+COPY 7 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+0.1982342084128137     ""
+0.0705861623402474     NULL
+0.7383512      "0.7547346625402616"
+0.1405589229429235     NULL
+0.7259117208346431     NULL
+0.9832712376311843     NULL
+0.03311829699079161    "'X狆l[%Lt]ulp!9nR)"
+
+CREATE TABLE "sys"."t1" ("c0" DOUBLE,"c1" VARCHAR(277));
+COPY 11 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+1839750227     ""
+0.4660818799383487     "l*+>⡪kF*bRp薓ßtP| P!-?54JIT"
+0.98293459381004       "X웨e_灰u8y"
+NULL   "2B_"
+NULL   "9"
+NULL   ""
+NULL   ""
+0.18404121429597398    NULL
+0.6820837154477003     "8C7_7\015\015(wntWql j\n9"
+NULL   "]"
+NULL   "0.48396026646393187"
+
+SELECT PROD(ALL 0.14) FROM t0 JOIN t1 ON CAST(CASE t0.c1 WHEN t1.c1 THEN NOT 
(FALSE) WHEN t1.c1 THEN (t0.c0) NOT  BETWEEN ASYMMETRIC (t1.c0) AND (t0.c0) 
WHEN t0.c1 
+THEN (0.2) IN (0.3) END AS BOOLEAN) GROUP BY NOT (FALSE), 
COALESCE(((COALESCE(2, 4, 1))<<(COALESCE(5, -6))), ((COALESCE(r'-8', -4, 
6))|(COALESCE(-2, 3, 4, 5, -6))));
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list