Changeset: 74ca0072fd01 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=74ca0072fd01
Modified Files:
sql/test/SQLancer/Tests/sqlancer02.sql
Branch: default
Log Message:
SQLancer: BATrangejoin: right inputs not aligned
diffs (28 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer02.sql
b/sql/test/SQLancer/Tests/sqlancer02.sql
--- a/sql/test/SQLancer/Tests/sqlancer02.sql
+++ b/sql/test/SQLancer/Tests/sqlancer02.sql
@@ -176,3 +176,24 @@ SELECT sum(CASE 0.8486491392276424017282
WHEN 0.82674200362462446634026491665281355381011962890625 THEN INTERVAL '1'
MONTH WHEN 0.16258430860651318372589457794674672186374664306640625 THEN
INTERVAL '5' MONTH
WHEN 0.94891882487575707205706976310466416180133819580078125 THEN INTERVAL '8'
MONTH WHEN 0.74703252230588967908175845877849496901035308837890625 THEN
INTERVAL '1' MONTH END) FROM t0;
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" INTEGER);
+COPY 10 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+-733291712
+383672170
+1913274279
+-709161370
+-1166455306
+-53279625
+1985993362
+-1
+386205865
+-780047338
+
+create view v0(c0, c1, c2, c3) as (
+select distinct cast(case time '03:52:21' when time '05:04:36' then r'0.2' end
as date),
+coalesce (t0.c0, length(coalesce (r't%QB', replace(r' ,yO_5G刵i稶bDßᶏ''',
r'0.8', r'-1e500')))), 1, timestamp '1970-01-16 13:47:20' from t0) with check
option;
+SELECT COUNT(*) FROM v0 LEFT OUTER JOIN t0 ON COALESCE(v0.c1, v0.c2) BETWEEN
v0.c2 AND t0.c0;
+SELECT ALL max(ALL v0.c3) FROM v0 LEFT OUTER JOIN t0 ON (-
(((v0.c2)-(COALESCE(v0.c2, v0.c1))))) NOT BETWEEN SYMMETRIC (v0.c2) AND
(t0.c0);
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
