Changeset: dc98039eaa0b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/dc98039eaa0b
Modified Files:
sql/test/SQLancer/Tests/sqlancer14.test
Branch: default
Log Message:
Query with wrong results
diffs (201 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer14.test
b/sql/test/SQLancer/Tests/sqlancer14.test
--- a/sql/test/SQLancer/Tests/sqlancer14.test
+++ b/sql/test/SQLancer/Tests/sqlancer14.test
@@ -93,3 +93,197 @@ update t2 set c0 = uuid 'ABeCdDdd-80Cd-D
statement ok
DROP TABLE t2
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0" ("c0" INTEGER NOT NULL,"c2" VARCHAR(64),"c3"
DECIMAL(18,3),"c4" VARCHAR(64),"c5" DECIMAL(18,3),
+ CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"),CONSTRAINT "t0_c0_unique"
UNIQUE ("c0"),CONSTRAINT "t0_c2_c3_c0_unique" UNIQUE ("c2", "c3", "c0"))
+
+statement ok
+COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0 "" -1.000 NULL 0.422
+-3 "Q" 0.421 NULL 0.110
+5 "" 0.500 NULL NULL
+-241330779 "" 0.193 "TRUE" 0.377
+
+statement ok
+CREATE TABLE "t1" ("c0" UUID NOT NULL,"c2" DECIMAL(18,3),"c4"
DECIMAL(18,3),"c5" VARCHAR(64) NOT NULL,
+ "c6" UUID NOT NULL,CONSTRAINT "t1_c0_pkey" PRIMARY KEY
("c0"),CONSTRAINT "t1_c0_unique" UNIQUE ("c0"))
+
+statement ok
+COPY 3 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+ac3be9d0-109d-3c26-9dbb-e715c78aaded -5.000 NULL
"2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e" ab3d0d27-a79c-5df2-ce72-d5b824df7b54
+ac118dae-fcf5-ed3f-accd-2b07daf44f8f 0.390 0.140
"3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6" ab5a6b6b-c95b-3abc-bedd-f66ceb7fef33
+e0cafdba-1e30-b8ef-5a15-82259f6f5851 0.068 NULL "*zd \n+~U["
f2daaf10-5caf-cbf8-4230-9daedbacccfd
+
+statement ok
+CREATE TABLE "t2" ("c0" VARCHAR(64) NOT NULL,"c2" DECIMAL(18,3) NOT NULL,"c3"
DOUBLE PRECISION,CONSTRAINT "t2_c0_pkey" PRIMARY KEY ("c0"))
+
+statement ok
+COPY 6 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+"-2145663488" -0.637 NULL
+"DOmV}KEp<" -0.637 NULL
+"毺" -0.637 NULL
+"-1597273906" 7.000 0.8478250121719998
+".4601199041541437" 0.584 -2
+"-{" 2.000 0.8377131873426266
+
+query T rowsort
+SELECT t1.c5 FROM t2, t1 CROSS JOIN (SELECT DISTINCT t0.c0 FROM t0) AS sub0
WHERE CASE 2 WHEN 3 THEN t2.c3 > t1.c2 ELSE TRUE END
+----
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+2b1fb0c3-bfa0-863f-9afc-5adfbe2c007e
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+3dcfce29-ebb2-de1f-c3b9-c2830bdffaa6
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+*zd \n+~U[
+
+query T rowsort
+SELECT CASE 2 WHEN 3 THEN t2.c3 > t1.c2 ELSE TRUE END FROM t2, t1 CROSS JOIN
(SELECT DISTINCT t0.c0 FROM t0) AS sub0
+----
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+
+statement ok
+ROLLBACK
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
