Changeset: f61a60b61e09 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f61a60b61e09
Modified Files:
sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
sql/test/BugTracker-2023/Tests/ifnull-6933.test
sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
Branch: Dec2023
Log Message:
Remove trailing ; from SQL statements
diffs (162 lines):
diff --git a/sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
b/sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
--- a/sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
+++ b/sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
@@ -1,56 +1,56 @@
query I
-SELECT greatest(3, 4, 2, 1);
+SELECT greatest(3, 4, 2, 1)
----
4
query I
-SELECT least(3, 4, 2, 1);
+SELECT least(3, 4, 2, 1)
----
1
query I
-SELECT greatest(3, 4, '0', '5');
+SELECT greatest(3, 4, '0', '5')
----
5
query I
-SELECT least(3, 4, 1, 2, '0', '5');
+SELECT least(3, 4, 1, 2, '0', '5')
----
0
query R
-SELECT greatest(3.321, 4.4321, '0.210', '5.54321', -6.54321);
+SELECT greatest(3.321, 4.4321, '0.210', '5.54321', -6.54321)
----
5.543
query R
-SELECT least(3.321, 4.4321, '0.210', '5.54321', -6.54321);
+SELECT least(3.321, 4.4321, '0.210', '5.54321', -6.54321)
----
-6.543
statement error conversion of string 'A' to type bte failed.
-SELECT greatest(3, 4, '0', '5', 'A', 'z');
+SELECT greatest(3, 4, '0', '5', 'A', 'z')
statement error conversion of string 'A' to type bte failed.
-SELECT least(3, 4, 1, 2, '0', '5', 'A', 'z');
+SELECT least(3, 4, 1, 2, '0', '5', 'A', 'z')
query T
-SELECT greatest('!', 3, 4, '0', '5', 'A', 'z');
+SELECT greatest('!', 3, 4, '0', '5', 'A', 'z')
----
z
query T
-SELECT least('!', 3, 4, 1, 2, '0', '5', 'A', 'z');
+SELECT least('!', 3, 4, 1, 2, '0', '5', 'A', 'z')
----
!
query T
-SELECT greatest('!', 'z3', 'z4', 'z0', 'z5', 'A', 'z');
+SELECT greatest('!', 'z3', 'z4', 'z0', 'z5', 'A', 'z')
----
z5
query T
-SELECT least('!z3', '!z4', '!0', '!5', 'A', 'z');
+SELECT least('!z3', '!z4', '!0', '!5', 'A', 'z')
----
!0
diff --git a/sql/test/BugTracker-2023/Tests/ifnull-6933.test
b/sql/test/BugTracker-2023/Tests/ifnull-6933.test
--- a/sql/test/BugTracker-2023/Tests/ifnull-6933.test
+++ b/sql/test/BugTracker-2023/Tests/ifnull-6933.test
@@ -1,11 +1,11 @@
statement ok
-create unlogged table t6933 (i int, c varchar(8));
+create unlogged table t6933 (i int, c varchar(8))
statement ok
-insert into t6933 values (1, 'aa1'), (2, null), (null, 'bb2'), (null, null);
+insert into t6933 values (1, 'aa1'), (2, null), (null, 'bb2'), (null, null)
query ITTTIT
-select i, c, IFNULL(i, c) as "IFNULL(i,c)", IFNULL(c, i) as "IFNULL(c,i)",
ifnull(i, 999) as "ifnull(i,999)", ifnull(c, 'has null') as "ifnull(c,'x')"
from t6933;
+select i, c, IFNULL(i, c) as "IFNULL(i,c)", IFNULL(c, i) as "IFNULL(c,i)",
ifnull(i, 999) as "ifnull(i,999)", ifnull(c, 'has null') as "ifnull(c,'x')"
from t6933
----
1
aa1
@@ -33,8 +33,8 @@ 999
has null
statement error syntax error, unexpected ',', expecting ')' or OR in: "select
i, c, ifnull(i, c,"
-select i, c, IFNULL(i, c, 999) as "IFNULL(i,c,999)" from t6933;
+select i, c, IFNULL(i, c, 999) as "IFNULL(i,c,999)" from t6933
statement ok
-drop table t6933;
+drop table t6933
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
@@ -33,7 +33,7 @@ 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;
+SELECT row_number ( ) OVER ( ORDER BY 10 * 10 , ( CASE WHEN ( 10 IS NULL )
THEN 4 ELSE 10 END ) DESC NULLS FIRST ) FROM v0
----
1
@@ -75,7 +75,7 @@ 122500
5
statement ok
-DROP TABLE v0;
+DROP TABLE v0
-- 05.sql
statement ok
@@ -173,10 +173,10 @@ DROP TABLE v0
-- 11.sql
statement ok
-CREATE TABLE v0(v1 BIGINT UNIQUE PRIMARY KEY);
+CREATE TABLE v0(v1 BIGINT UNIQUE PRIMARY KEY)
statement error 42000!PARTITION BY: subqueries not allowed in PARTITION BY
clause
-UPDATE v0 SET v1 = v1 * 73 WHERE v1 = (SELECT SUM(v1) OVER (PARTITION BY 52,
(NOT EXISTS (SELECT 0 + (SELECT v1 WHERE v1 * v1 * v1 GROUP BY v1) AS v3 WHERE
v1 = 'x' OR 'x' OR v1)), v1, 37 ORDER BY v1 NULLS LAST) IS NOT NULL AS v2 GROUP
BY v1 HAVING v1 > 'x') AND NOT ((v1 = 66 AND v1 < 'x') AND v1 = 50) AND 35 >=
65;
+UPDATE v0 SET v1 = v1 * 73 WHERE v1 = (SELECT SUM(v1) OVER (PARTITION BY 52,
(NOT EXISTS (SELECT 0 + (SELECT v1 WHERE v1 * v1 * v1 GROUP BY v1) AS v3 WHERE
v1 = 'x' OR 'x' OR v1)), v1, 37 ORDER BY v1 NULLS LAST) IS NOT NULL AS v2 GROUP
BY v1 HAVING v1 > 'x') AND NOT ((v1 = 66 AND v1 < 'x') AND v1 = 50) AND 35 >= 65
statement ok
DROP TABLE v0
@@ -189,7 +189,7 @@ statement ok
INSERT INTO v0 (v1) VALUES (2),(10),(99),(1.100000),(3)
statement error 22018!conversion of string to type bte failed.
-UPDATE v0 SET v1 = (SELECT MIN(v1) OVER (ROWS 10 PRECEDING) WHERE (10 = v1 OR
v1 = ((3 - 10.100000))) AND 3 NOT LIKE v1);
+UPDATE v0 SET v1 = (SELECT MIN(v1) OVER (ROWS 10 PRECEDING) WHERE (10 = v1 OR
v1 = ((3 - 10.100000))) AND 3 NOT LIKE v1)
statement ok
DROP TABLE v0
@@ -212,7 +212,7 @@ DROP TABLE v0
-- INSERT INTO v0 VALUES (-1),(NULL),(57),(NULL),(NULL)
-- statement ok
--- UPDATE v0 SET v1 = v1 % (WITH v0 (v1) AS (SELECT -2147483648 WHERE (v1 < -1
OR v1 = 37 % 127) AND v1 - 85 = 45 AND v1 IS NOT NULL) SELECT DISTINCT -1 FROM
v0) + v1;
+-- UPDATE v0 SET v1 = v1 % (WITH v0 (v1) AS (SELECT -2147483648 WHERE (v1 < -1
OR v1 = 37 % 127) AND v1 - 85 = 45 AND v1 IS NOT NULL) SELECT DISTINCT -1 FROM
v0) + v1
-- statement ok
-- DROP TABLE v0
@@ -483,7 +483,7 @@ DROP TABLE v0
-- statement ok
-- DROP TABLE v0
--- 39.sq
+-- 39.sql
statement ok
CREATE TABLE v0 (v1 VARCHAR(30))
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
