Changeset: 5b006e3d28e7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5b006e3d28e7
Modified Files:
sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
Branch: Dec2023
Log Message:
Enabled statements for parts: 23.sql 24.sql 29.sql and 40.sql
For the statements which produce a wrong result/behavior it is prefixed with
the new "skipif knownfail" line, so they are not executed in normal usage of
Mtest.py.
diffs (140 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
@@ -319,49 +319,66 @@ UPDATE v0 SET v1 = (SELECT LAG(v1 * v1)
statement ok
DROP TABLE v0
--- -- 23.sql
--- statement ok
--- CREATE TABLE v0 (v1 INTEGER PRIMARY KEY)
+-- 23.sql
+statement ok
+CREATE TABLE v0 (v1 INTEGER PRIMARY KEY)
+
+query I nosort
+SELECT 67 + 0 + -1 + 96 + 46463082.000000 + 30 AS v2 FROM v0 WHERE 255 = v1
LIMIT 66 OFFSET 16
+----
--- statement ok
--- UPDATE v0 SET v1 = -128 WHERE v1 = 1 AND v1 IN (WITH v0 AS (SELECT v1 * (95
- v1) FROM v0 ORDER BY v1, v1 DESC, ('x' < v1 AND v1 = 24)) SELECT 67 + 0 + -1
+ 96 + 46463082.000000 + 30 AS v2 FROM v0 WHERE 255 = v1 LIMIT 66 OFFSET 16) OR
(69 AND 30) OR ('x' >= 9)
+query I nosort
+SELECT v1 * (95 - v1) FROM v0 ORDER BY v1, v1 DESC, ('x' < v1 AND v1 = 24)
+----
--- statement ok
--- DROP TABLE v0
+statement error 42000!SELECT: identifier 'v1' unknown
+WITH v0 AS (SELECT v1 * (95 - v1) FROM v0 ORDER BY v1, v1 DESC, ('x' < v1 AND
v1 = 24)) SELECT 67 + 0 + -1 + 96 + 46463082.000000 + 30 AS v2 FROM v0 WHERE
255 = v1 LIMIT 66 OFFSET 16
+----
+
+skipif knownfail
+statement ok
+UPDATE v0 SET v1 = -128 WHERE v1 = 1 AND v1 IN (WITH v0 AS (SELECT v1 * (95 -
v1) FROM v0 ORDER BY v1, v1 DESC, ('x' < v1 AND v1 = 24)) SELECT 67 + 0 + -1 +
96 + 46463082.000000 + 30 AS v2 FROM v0 WHERE 255 = v1 LIMIT 66 OFFSET 16) OR
(69 AND 30) OR ('x' >= 9)
+
+statement ok
+DROP TABLE v0
-- 24.sql
--- statement ok
--- CREATE TABLE v0(v1 FLOAT)
+statement ok
+CREATE TABLE v0(v1 FLOAT)
--- statement ok
--- INSERT INTO v0 VALUES (0),(67),(127),(-1),(NULL),(NULL),(NULL),(NULL)
+statement ok
+INSERT INTO v0 VALUES (0),(67),(127),(-1),(NULL),(NULL),(NULL),(NULL)
--- query IT nosort
--- SELECT * , 'x' FROM v0 WHERE (SELECT 39 WHERE (v1 + -32768 NOT IN (14,
255))) * 87 + 2147483647
--- ----
--- 0
--- x
--- 67
--- x
--- 127
--- x
--- -1
--- x
+query IT nosort
+SELECT * , 'x' FROM v0 WHERE (SELECT 39 WHERE (v1 + -32768 NOT IN (14, 255)))
* 87 + 2147483647
+----
+0
+x
+67
+x
+127
+x
+-1
+x
--- statement ok
--- WITH v0 AS (SELECT 14, * FROM v0) INSERT INTO v0 SELECT v1 * 0 FROM v0
NATURAL JOIN v0, v0, v0 AS v2, v0, v0 AS v3 ORDER BY v1 * 0 / 77
+statement ok
+WITH v0 AS (SELECT 14, * FROM v0) INSERT INTO v0 SELECT v1 * 0 FROM v0 NATURAL
JOIN v0, v0, v0 AS v2, v0, v0 AS v3 ORDER BY v1 * 0 / 77
--- query I nosort
--- SELECT count(*) FROM v0
--- ----
--- 131080
+query I nosort
+SELECT count(*) FROM v0
+----
+131080
--- statement crashes server
--- SELECT * , 'x' FROM v0 WHERE (SELECT 39 WHERE (v1 + -32768 NOT IN (14,
255))) * 87 + 2147483647
+-- after the second insert, rerun same query as above, now it crashes server
+skipif knownfail
+query IT nosort
+SELECT * , 'x' FROM v0 WHERE (SELECT 39 WHERE (v1 + -32768 NOT IN (14, 255)))
* 87 + 2147483647
+----
+
-- mul_bte_bte_bte: ERROR: 22003!overflow in calculation 87*39.
--- statement ok
--- DROP TABLE v0
+statement ok
+DROP TABLE v0
-- 25.sql
statement ok
@@ -424,10 +441,11 @@ 0.000
statement ok
DROP TABLE v0
--- -- 29.sql
--- statement error
--- SELECT ALL ( SELECT - - - - - - - - - - 48 FROM ( SELECT NULL - - - - - - -
- 89 FROM ( VALUES ( - - - - - - - - - - 74 ) , ( - - - - - 128 ) , ( - - - - -
- 8 ) , ( - - - - 61 ) ) AS v1 ( v1 ) GROUP BY ( ) , GROUPING SETS ( GROUPING
SETS ( GROUPING SETS ( ( ) ) ) ) , ( ) ORDER BY - - - - - - - - - - 255 LIKE v1
/ CASE WHEN v1 IS NULL THEN - - 75 END DESC , v1 , v1 LIMIT 63 ) AS v1 UNION
SELECT - - - - - - - - - - - - - 74 WHERE - v1 < - 89088397.000000 ) FROM (
SELECT * FROM ( VALUES ( - - - - - - - 61 ) , ( - - - 42 ) ) AS v1 ( v1 ) ) AS
v1 ( v1 )
--- sql/server/rel_select.c:4614: rel_groupings: Assertion `next_set' failed.
+-- 29.sql
+skipif knownfail
+statement error
+SELECT ALL ( SELECT - - - - - - - - - - 48 FROM ( SELECT NULL - - - - - - - -
89 FROM ( VALUES ( - - - - - - - - - - 74 ) , ( - - - - - 128 ) , ( - - - - - -
8 ) , ( - - - - 61 ) ) AS v1 ( v1 ) GROUP BY ( ) , GROUPING SETS ( GROUPING
SETS ( GROUPING SETS ( ( ) ) ) ) , ( ) ORDER BY - - - - - - - - - - 255 LIKE v1
/ CASE WHEN v1 IS NULL THEN - - 75 END DESC , v1 , v1 LIMIT 63 ) AS v1 UNION
SELECT - - - - - - - - - - - - - 74 WHERE - v1 < - 89088397.000000 ) FROM (
SELECT * FROM ( VALUES ( - - - - - - - 61 ) , ( - - - 42 ) ) AS v1 ( v1 ) ) AS
v1 ( v1 )
+-- sql/server/rel_select.c:4616: rel_groupings: Assertion `next_set' failed.
-- 30.sql
statement ok
@@ -541,11 +559,15 @@ statement ok
DROP TABLE v0
-- 40.sql
--- statement ok
--- CREATE TABLE v0(v2 DOUBLE, v1 REAL)
+statement ok
+CREATE TABLE v0(v2 DOUBLE, v1 REAL)
+
+statement error 42S22!SELECT: no such column 'v0.v2'
+SELECT 2 FROM v0 AS WHERE v0 . v2 = ( SELECT v2 WHERE v2 = 2 ) + v0 . v1
--- statement ok
--- DELETE FROM v0 WHERE EXISTS (SELECT 2 FROM v0 AS WHERE v0.v2 = (SELECT v2
WHERE v2 = 2) + v0.v1)
+skipif knownfail
+statement error 42S22!SELECT: no such column 'v0.v2'
+DELETE FROM v0 WHERE EXISTS ( SELECT 2 FROM v0 AS WHERE v0 . v2 = ( SELECT v2
WHERE v2 = 2 ) + v0 . v1 )
--- statement ok
--- DROP TABLE v0
+statement ok
+DROP TABLE v0
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
