Changeset: 68784d372bc7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=68784d372bc7
Modified Files:
sql/test/SQLancer/Tests/sqlancer04.sql
Branch: Oct2020
Log Message:
SQLancer query with wrong results. Will look when I get time
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
@@ -395,3 +395,32 @@ INSERT INTO t2(c0) VALUES(null);
UPDATE t2 SET c0 = 0.2818413675323882 WHERE
sql_min((0.0194696766772712859250304973102174699306488037109375)
BETWEEN (t2.c0) AND (0.8918001896191873), (t2.c0) NOT IN (-682776732));
DROP TABLE t2;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" BOOLEAN,CONSTRAINT "t0_c0_unique" UNIQUE ("c0"));
+INSERT INTO "sys"."t0" VALUES (true), (false);
+create view v3(vc0) as (values (least(909916901, - (1451705231))));
+
+create view v4(vc0, vc1, vc2, vc3) as (select case sql_min(true, r'TRUE') when
(-1243138496) not between
+asymmetric (-1723862249) and (253857921) then least(-1523235132,
-1.04665549E9) end, cast(nullif(r'', r'') as bigint),
+weekofyear(sql_sub(date '1970-01-10', interval '58931850' month)),
0.16610325448814467 where least(false, false));
+
+create view v6(vc0, vc1, vc2) as (values (cast((true) = true as int),
cast(((1576421008)&(null)) as decimal),
+((((0.15598454)-(-235033638)))<<(((0.50459784)/(1078999181))))), (abs(20223),
+ (cast(0.6995354 as real)),
+cast(-1695180722 as bigint)));
+
+SELECT v3.vc0 FROM v3, v6 CROSS JOIN (SELECT ALL ((sign(0.9241489178039545))*
+(scale_down(0.74460343372682225027148206208948977291584014892578125,
0.33816958610011738084466514919768087565898895263671875)))
+FROM t0 LEFT OUTER JOIN (SELECT DISTINCT upper(r'bŀ') WHERE FALSE) AS sub0 ON
TRUE WHERE greatest(t0.c0, TRUE)) AS sub0
+LEFT OUTER JOIN (SELECT DISTINCT 5688 FROM v4 WHERE (v4.vc0) IN (-2081865947,
30436)) AS sub1 ON least(FALSE, TRUE)
+RIGHT OUTER JOIN (VALUES (CAST(greatest(r'77',
0.10216334194461484941029993933625519275665283203125) AS STRING(478)))) AS sub2
+ON ((greatest(r'', r'32228'))NOT ILIKE(CAST(30792 AS STRING(381)))) WHERE
(((v6.vc1)-(v6.vc1))) IS NOT NULL;
+
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST((((v6.vc1)-(v6.vc1)))
IS NOT NULL AS INT) as count FROM v3, v6 CROSS JOIN
+(SELECT
((sign(0.9241489178039545))*(scale_down(0.74460343372682225027148206208948977291584014892578125,
+0.33816958610011738084466514919768087565898895263671875))) FROM t0 LEFT OUTER
JOIN (SELECT DISTINCT upper(r'bŀ') WHERE FALSE)
+AS sub0 ON TRUE WHERE greatest(t0.c0, TRUE)) AS sub0 LEFT OUTER JOIN (SELECT
DISTINCT 5688 FROM v4
+WHERE (v4.vc0) IN (-2081865947, 30436)) AS sub1 ON least(FALSE, TRUE) RIGHT
OUTER JOIN (VALUES (CAST(greatest(r'77',
+0.10216334194461484941029993933625519275665283203125) AS STRING(478)))) AS
sub2 ON ((greatest(r'', r'32228'))NOT
+ILIKE(CAST(30792 AS STRING(381))))) as res;
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
