Changeset: eb160656afa7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/eb160656afa7 Modified Files: sql/test/BugTracker-2023/Tests/misc-crashes-7390.test Branch: Jun2023 Log Message:
Added some additional queries, and references to the original script names. diffs (152 lines): diff --git a/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test b/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test --- a/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test +++ b/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test @@ -1,3 +1,7 @@ +statement ok +drop table if exists v0 + +-- 01.sql statement ok CREATE TABLE v0 (v1 SMALLINT) @@ -10,6 +14,7 @@ SELECT NULL, v1 FROM v0 v0 ORDER BY v1+v statement ok drop table v0 +-- 02.sql statement ok CREATE TABLE v0(v1 VARCHAR(30)) @@ -17,13 +22,23 @@ query TTI SELECT DISTINCT v1 v1, v1, abs(v1)=10 FROM v0 WHERE lower (v1) IS NOT NULL ---- - statement ok drop table v0 +-- 03.sql statement ok CREATE VIEW v0 AS SELECT CAST (NULL AS INT) INTERSECT SELECT CAST (NULL AS INT) +query I +SELECT * FROM v0 +---- +NULL + +query I +SELECT row_number ( ) OVER ( ORDER BY 10 * 10 , ( CASE WHEN ( 10 IS NULL ) THEN 4 ELSE 10 END ) DESC NULLS FIRST ) FROM v0; +---- +1 + query IIT SELECT 2, row_number() OVER (ORDER BY 10*10, (CASE WHEN (10 IS NULL) THEN 4 ELSE 10 END) DESC NULLS FIRST), '.125e+3' FROM v0 LIMIT 1 ---- @@ -34,6 +49,7 @@ 1 statement ok drop view v0 +-- 04.sql statement ok CREATE TABLE v0 (v1 VARCHAR(255)) @@ -46,12 +62,24 @@ INSERT INTO v0 SELECT row_number () OVER statement ok INSERT INTO v0 SELECT row_number () OVER (ORDER BY 2 NULLS LAST) AS c0 FROM v0, v0 AS contains +query I +SELECT count(*) as cnt FROM v0 +---- +122850 + statement ok SELECT FIRST_VALUE(v1) OVER (PARTITION BY v1=5 ORDER BY 3003*v1 DESC NULLS FIRST, v1) FROM v0 LIMIT 1000000000 +query T rowsort +SELECT distinct FIRST_VALUE(v1) OVER (PARTITION BY v1=5 ORDER BY 3003*v1 DESC NULLS FIRST, v1) FROM v0 LIMIT 1000000000 +---- +122500 +5 + statement ok drop table v0; +-- 05.sql statement ok CREATE TABLE v0 (v1 INT) @@ -64,21 +92,37 @@ INSERT INTO v0 SELECT row_number () OVER statement ok INSERT INTO v0 SELECT row_number () OVER (ORDER BY 100 NULLS LAST) FROM v0, v0 AS contains +query I +SELECT count(*) as cnt FROM v0 +---- +545382 + statement ok SELECT FIRST_VALUE (v1) OVER (PARTITION BY 'HASHED' ORDER BY v1<=10 DESC NULLS FIRST, v1 DESC) FROM v0 LIMIT 300000 +query T rowsort +SELECT distinct FIRST_VALUE ( v1 ) OVER ( PARTITION BY 'HASHED' ORDER BY v1 <= 10 DESC NULLS FIRST , v1 DESC ) FROM v0 WHERE v1 IS NOT NULL LIMIT 300000 +---- +10 + statement ok drop table v0 -statement error +-- 06.sql +statement error HY013!Could not allocate space CREATE TEMP TABLE Table0 (Col0 INT, PRIMARY KEY(Col0), FOREIGN KEY (Col0) REFERENCES Table0) statement ok +drop table if exists Table0 + +-- 07.sql +statement ok CREATE VIEW v0 AS SELECT CAST (NULL AS INT) EXCEPT SELECT CAST (NULL AS INT) GROUP BY NULL statement ok -drop view v0 +drop view if exists v0 +-- 08.sql statement ok CREATE TABLE v0 (v1 INT NULL) @@ -91,17 +135,33 @@ INSERT INTO v0 SELECT v0.v1 FROM v0, v0 statement ok INSERT INTO v0 SELECT v0.v1 FROM v0, v0 AS c3_null, v0 AS col2 +query I +SELECT count(*) as cnt FROM v0 +---- +2197130 + statement ok SELECT v1, row_number() OVER (ORDER BY v1 * 3 NULLS LAST, NULL*0 DESC NULLS FIRST), 3 FROM v0 LIMIT 300000 statement ok drop table v0 +-- 09.sql statement ok CREATE TABLE v0 (v1 INT, v2 REAL) -statement error +statement error 42000!Table expression without table name SELECT * FROM v0 ORDER BY (SELECT *) +statement error 42000!SELECT: subquery must return only one column +SELECT * FROM v0 ORDER BY ( SELECT * FROM v0 ) + +query IR +SELECT * FROM v0 ORDER BY (SELECT -1) +---- + statement ok drop table v0 + +-- TODO: add remaining 10.sql to 40.sql tests and fix bugs + _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
