Changeset: a2e4085c8253 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a2e4085c8253
Modified Files:
sql/test/SQLancer/Tests/sqlancer17.test
Branch: Jan2022
Log Message:
Backported setjoin tests from default into Jan2022, plus new crash
diffs (94 lines):
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
@@ -561,3 +561,90 @@ INSERT INTO tz(c1) VALUES(CASE WHEN EXIS
statement ok
ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE t2 (c0 VARCHAR(217))
+
+query I nosort
+SELECT 1 FROM t2 WHERE (SELECT tx.c0 = ANY(SELECT 'a' FROM t2) FROM t2 AS tx)
+----
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "rt0" ("c0" REAL,"c1" DECIMAL(18,3))
+
+statement ok
+create view vx(vc0, vc1) as (values (inet '229.210.31.233', 1),
(greatest((select inet '187.205.97.37/28'), (select inet '136.216.53.173/0')),
1))
+
+statement ok
+create view vy(vc0, vc1) as (select distinct 208, 49 from sys.vx as tv5l0n1)
+
+query I nosort
+SELECT 1 FROM vy, vx GROUP BY COALESCE('b', (SELECT 'c' FROM rt0)) HAVING
max(1 IN ((SELECT 2 FROM rt0), 3))
+----
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+create or replace view vx(vc0, vc1) as (values (blob 'aa', 2), (case 4 when 2
then (values (blob 'dd')) end, 0.5))
+
+statement ok
+create or replace view vy(vc0) as (select vz.vc0 <> all(select blob '' from
(select 2) vw(x)) from vx as vz)
+
+query I nosort
+(SELECT 1 FROM vx) INTERSECT ALL (SELECT least(2, 3) FROM vx, vy)
+----
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE tz (c0 INT)
+
+statement ok
+create or replace view vy(vc0) as (values (1))
+
+statement ok
+create or replace view vx(vc0, vc1) as (select 2, 3 from vy)
+
+query I nosort
+SELECT 1 FROM tz, vx WHERE (vx.vc1 + tz.c0) <> ALL(VALUES (4)) AND vx.vc0 <>
ALL(VALUES (5))
+----
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE rt0 (c0 INT)
+
+statement ok
+create or replace view vx(vc0) as (select 'a')
+
+statement ok
+create or replace view vy(vc0) as (values (2))
+
+query I nosort
+SELECT 1 FROM rt0 CROSS JOIN (SELECT CASE sub0.c2 WHEN 4 THEN 'c' END,
+least(3, sub0.c1) FROM vx JOIN (SELECT 4, vy.vc0 FROM vy) AS sub0(c1,c2) ON
TRUE) AS sub0(c0,c2)
+----
+
+statement ok
+ROLLBACK
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
