Changeset: 7555d6c89341 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7555d6c89341
Modified Files:
sql/test/SQLancer/Tests/sqlancer13.test
Branch: default
Log Message:
BATrangejoin: right inputs not aligned
diffs (78 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer13.test
b/sql/test/SQLancer/Tests/sqlancer13.test
--- a/sql/test/SQLancer/Tests/sqlancer13.test
+++ b/sql/test/SQLancer/Tests/sqlancer13.test
@@ -265,3 +265,74 @@ MERGE INTO t2 USING (SELECT * FROM t1) A
statement ok
ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "sys"."t0" (
+ "c2" UUID NOT NULL,
+ "c3" SMALLINT,
+ CONSTRAINT "t0_c2_unique" UNIQUE ("c2")
+)
+
+statement ok
+CREATE TABLE "sys"."t1" (
+ "c2" DOUBLE NOT NULL,
+ CONSTRAINT "t1_c2_pkey" PRIMARY KEY ("c2"),
+ CONSTRAINT "t1_c2_unique" UNIQUE ("c2"),
+ CONSTRAINT "t1_c2_fkey" FOREIGN KEY ("c2") REFERENCES "sys"."t1" ("c2")
+)
+
+statement ok
+CREATE TABLE "sys"."t2" (
+ "c2" INTEGER NOT NULL,
+ CONSTRAINT "t2_c2_pkey" PRIMARY KEY ("c2"),
+ CONSTRAINT "t2_c2_unique" UNIQUE ("c2")
+)
+
+statement ok
+COPY 10 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+3
+-268352476
+1
+6
+8
+4
+0
+-1
+1498232900
+26
+
+query I rowsort
+SELECT min(ALL least(t0.c3, 5)) FROM t2, t0, t1 WHERE (+ (t1.c2)) BETWEEN
ASYMMETRIC (NULLIF(3, t2.c2)) AND ("second"(INTERVAL '2139020636' SECOND))
GROUP BY sqrt(t1.c2), "epoch_ms"(DATE '1970-01-12')
+----
+
+statement ok
+ROLLBACK
+
+statement ok
+CREATE TABLE t1(c2 DOUBLE PRECISION)
+
+statement ok
+CREATE TABLE t2(c2 DECIMAL, c4 tinyint)
+
+statement ok
+INSERT INTO t2(c4) VALUES (89), (9), (2), (6), (2), (5), (3), (0)
+
+statement ok
+TRUNCATE t2
+
+statement ok
+INSERT INTO t2(c2) VALUES (10), (6)
+
+query I rowsort
+SELECT 1 FROM t2, t1 WHERE t1.c2 BETWEEN t2.c2 AND 10
+----
+
+statement ok
+DROP TABLE t1
+
+statement ok
+DROP TABLE t2
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
