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

SQLancer calc.between undefined error.

Our quests for bugs will never end :)


diffs (26 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer03.sql 
b/sql/test/SQLancer/Tests/sqlancer03.sql
--- a/sql/test/SQLancer/Tests/sqlancer03.sql
+++ b/sql/test/SQLancer/Tests/sqlancer03.sql
@@ -340,6 +340,22 @@ 1844355385 0.6101178479960011      1733503642
 select cast(group_concat(all r'0.5787210717348131') as decimal) from t0 group 
by - (abs(- (- (1061572565)))), least(t0.c0, least(cast(cast(0.09300166 as int) 
as interval month), t0.c0));
 ROLLBACK;
 
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" DECIMAL(18,3));
+COMMENT ON COLUMN "sys"."t0"."c0" IS 'jc~\006}ℵH{\015^aBPxpf+sP';
+COPY 8 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+0.626
+0.634
+0.133
+0.244
+19.000
+0.455
+0.715
+0.369
+
+SELECT ALL CASE t0.c0 WHEN VAR_POP(ALL t0.c0) THEN (t0.c0) BETWEEN SYMMETRIC 
(t0.c0) AND (t0.c0) END FROM t0 GROUP BY t0.c0;
+ROLLBACK;
+
 START TRANSACTION; -- Bug 6924
 CREATE TABLE "sys"."t0" ("a" INTEGER, "b" INTEGER NOT NULL, CONSTRAINT 
"t0_a_b_unique" UNIQUE ("a","b"));
 --This copy into must succeed 
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to