Changeset: 6ff587cf4789 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/6ff587cf4789
Removed Files:
sql/test/SQLancer/Tests/sqlancer22.test
Modified Files:
sql/test/SQLancer/Tests/All
sql/test/SQLancer/Tests/sqlancer17.test
Branch: pushcands
Log Message:
Merged with default
diffs (truncated from 376 to 300 lines):
diff --git a/sql/test/SQLancer/Tests/All b/sql/test/SQLancer/Tests/All
--- a/sql/test/SQLancer/Tests/All
+++ b/sql/test/SQLancer/Tests/All
@@ -19,4 +19,3 @@ sqlancer18
sqlancer19
sqlancer20
KNOWNFAIL?sqlancer21
-KNOWNFAIL?sqlancer22
diff --git a/sql/test/SQLancer/Tests/sqlancer17.test
b/sql/test/SQLancer/Tests/sqlancer17.test
--- a/sql/test/SQLancer/Tests/sqlancer17.test
+++ b/sql/test/SQLancer/Tests/sqlancer17.test
@@ -369,3 +369,49 @@ 1
statement ok
ROLLBACK
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0" ("c0" DECIMAL(18,3))
+
+statement ok
+COPY 10 RECORDS INTO "t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0.609
+0.000
+0.706
+0.159
+0.374
+0.484
+0.368
+3.000
+0.990
+0.785
+
+statement ok
+CREATE TABLE "t2" ("c0" DECIMAL(18,3))
+
+statement ok
+COPY 10 RECORDS INTO "t2" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0.744
+0.392
+0.870
+0.120
+0.452
+1241972446.000
+0.801
+NULL
+NULL
+0.071
+
+statement ok
+ALTER TABLE t0 ADD COLUMN c2 UUID
+
+statement error GDK reported error: BATsubcross: more than one match
+UPDATE t2 SET c0 = 1 FROM t0 WHERE (least(TRUE, FALSE) AND 0.63 = t2.c0) OR
(0.23 <= 0.1)
+
+statement ok
+ROLLBACK
+
diff --git a/sql/test/SQLancer/Tests/sqlancer22.test
b/sql/test/SQLancer/Tests/sqlancer22.test
deleted file mode 100644
--- a/sql/test/SQLancer/Tests/sqlancer22.test
+++ /dev/null
@@ -1,310 +0,0 @@
-statement ok
-START TRANSACTION
-
-statement ok
-CREATE TABLE "t0" ("c2" DATE, CONSTRAINT "t0_c2_pkey" PRIMARY KEY ("c2"))
-
-statement ok rowcount 2
-INSERT INTO "t0" VALUES (DATE '1970-01-04'), (DATE '1970-01-01')
-
-query T rowsort
-SELECT t0.c2 FROM t0 WHERE (t0.c2) IN (t0.c2, (VALUES (DATE '1969-12-10'),
(DATE '1970-01-01')))
-----
-1970-01-01
-1970-01-04
-
-query I rowsort
-SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((t0.c2) IN (t0.c2, (VALUES
(DATE '1969-12-10'), (DATE '1970-01-01'))) AS INT) as count FROM t0) as res
-----
-2
-
-statement ok
-CREATE TABLE "t1" ("c2" BIGINT NOT NULL, CONSTRAINT "t1_c2_pkey" PRIMARY KEY
("c2"))
-
-statement ok rowcount 4
-INSERT INTO "t1" VALUES (69), (-12), (9), (0)
-
-query I rowsort
-SELECT -3 < least((SELECT 1 WHERE FALSE), (SELECT DISTINCT 2 FROM t1)) FROM t1
-----
-True
-True
-True
-True
-
-query I rowsort
-SELECT t1.c2 FROM t1 WHERE -3 < least((SELECT 1 WHERE FALSE), (SELECT 2 FROM
t1 GROUP BY DATE '1970-01-11'))
-----
--12
-0
-69
-9
-
-query I rowsort
-SELECT least((SELECT 1 WHERE FALSE), (SELECT DISTINCT 2 FROM t1)) > -3 FROM t1
-----
-True
-True
-True
-True
-
-query I rowsort
-SELECT t1.c2 FROM t1 WHERE least((SELECT 1 WHERE FALSE), (SELECT 2 FROM t1
GROUP BY DATE '1970-01-11')) > -3
-----
--12
-0
-69
-9
-
-statement ok
-ROLLBACK
-
-statement ok
-START TRANSACTION
-
-statement ok
-CREATE TABLE "t0" ("c3" INTERVAL SECOND)
-
-statement ok rowcount 9
-INSERT INTO "t0" VALUES (INTERVAL '6' SECOND),(INTERVAL '9' SECOND),(INTERVAL
'1' SECOND),
-(INTERVAL '0' SECOND),(INTERVAL '9' SECOND),(INTERVAL '4' SECOND),(INTERVAL
'6' SECOND),(INTERVAL '1' SECOND),(NULL)
-
-query I rowsort
-SELECT (SELECT 2 WHERE FALSE) = ANY(SELECT 3 WHERE FALSE)
-----
-False
-
-query T rowsort
-SELECT t0.c3 FROM t0 WHERE ifthenelse((SELECT 2 WHERE FALSE) = ANY(SELECT 3
WHERE FALSE), 2, 1)
-----
-0:00:00
-0:00:01
-0:00:01
-0:00:04
-0:00:06
-0:00:06
-0:00:09
-0:00:09
-NULL
-
-query I rowsort
-SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(ifthenelse((SELECT 2 WHERE
FALSE) = ANY(SELECT 3 WHERE FALSE), 2, 1) AS INT) as count FROM t0) as res
-----
-9
-
-statement ok
-ROLLBACK
-
-statement ok
-START TRANSACTION
-
-statement ok
-CREATE TABLE "t2" ("c2" REAL)
-
-statement ok rowcount 142
-COPY 142 RECORDS INTO "t2" FROM stdin USING DELIMITERS E'\t',E'\n','"'
-<COPY_INTO_DATA>
-NULL
-0.18141033
-0.10420329
-NULL
--1.2681471e+09
-0.6239734
-NULL
-0.37928414
-0.7922281
-0.49325344
--1.7018686e+17
-0.070922926
-4
-8.981221e+07
-0.17222267
-0.21218215
-0.58062196
-0.419161
-0.84214187
-0.29322016
-0.29322016
--0
-0.7530656
-0
--1
--2.0448145e+09
-0.2540231
-0.49195638
-0.0023798633
-0.6432879
-7
-NULL
-0.61336726
-0.37398192
--9.4684614e+08
-0.18818615
-0.5136187
-3
-0.12575655
-0.29542512
-0.7088062
--8.094762e+08
-110847336
-0.3245087
-0.35633564
-0.311399
-0.9717446
--8
-1
-6
-0.43797848
-1.82855e+09
-0.5382776
-0.5785479
-NULL
-0.34842148
-0.35951182
-0
-0.3906244
-0.7785596
-0.9109514
-0.38354927
-0.28305355
-1.9593509e+08
-0.89934695
-0.9522356
-0.6559638
-0.2916218
--1.4625787e+09
-2
-0.9737825
-0.12143436
-1.9697553e+09
-4
-3.1415927
-0.18462433
--4.500457e-09
-0.5604565
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
--8.705452e+08
-0.24377942
--1
-1.5076613e+09
-NULL
-6
-0.7550721
--5.3695283
-2.0706463e+09
-0.51699466
-0.53571135
-1
--1.0872904e+09
-0.30670688
-7
-6.008104e+08
-0.5502465
-2.0706463e+09
-0.45825
-0.4935091
-0.86806786
-0.23549564
-1
-0.35711357
-0.2559728
-0
-3
-0.35711357
-1.9593509e+08
--6
-0.7928499
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
