Changeset: 89dff439d84f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/89dff439d84f
Modified Files:
sql/test/BugTracker-2020/Tests/values-groupby.Bug-7013.test
sql/test/BugTracker-2021/Tests/WITH-alias-DELETE-2.deletes-too-many-tuples.Bug-7133.test
sql/test/BugTracker-2022/Tests/values.Bug-7336.test
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
sql/test/BugTracker-2024/Tests/7550-select-statistics-auth.test
sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test
sql/test/BugTracker-2024/Tests/exp_ref-Bug-7479.test
sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test
Branch: clean_parser
Log Message:
approved output
ie quoted table, column
add column lables after as.
diffs (195 lines):
diff --git a/sql/test/BugTracker-2020/Tests/values-groupby.Bug-7013.test
b/sql/test/BugTracker-2020/Tests/values-groupby.Bug-7013.test
--- a/sql/test/BugTracker-2020/Tests/values-groupby.Bug-7013.test
+++ b/sql/test/BugTracker-2020/Tests/values-groupby.Bug-7013.test
@@ -2,7 +2,7 @@ statement ok
START TRANSACTION
statement ok
-CREATE VIEW v AS SELECT a1, a2 FROM (VALUES (1,2)) as (a1,a2) GROUP BY a1, a2
+CREATE VIEW v AS SELECT a1, a2 FROM (VALUES (1,2)) as a(a1,a2) GROUP BY a1, a2
query I rowsort
SELECT a1 from v
diff --git
a/sql/test/BugTracker-2021/Tests/WITH-alias-DELETE-2.deletes-too-many-tuples.Bug-7133.test
b/sql/test/BugTracker-2021/Tests/WITH-alias-DELETE-2.deletes-too-many-tuples.Bug-7133.test
---
a/sql/test/BugTracker-2021/Tests/WITH-alias-DELETE-2.deletes-too-many-tuples.Bug-7133.test
+++
b/sql/test/BugTracker-2021/Tests/WITH-alias-DELETE-2.deletes-too-many-tuples.Bug-7133.test
@@ -61,7 +61,7 @@ SELECT COUNT(*) FROM extra
12
query TTTI rowsort
-select table, column, type, count from sys.storage() where table = 'extra'
+select "table", "column", type, count from sys.storage() where "table" =
'extra'
----
extra
extra
diff --git a/sql/test/BugTracker-2022/Tests/values.Bug-7336.test
b/sql/test/BugTracker-2022/Tests/values.Bug-7336.test
--- a/sql/test/BugTracker-2022/Tests/values.Bug-7336.test
+++ b/sql/test/BugTracker-2022/Tests/values.Bug-7336.test
@@ -2,7 +2,7 @@ query IIR nosort
select a,b,c
from (values (10, 20, 0.5),
(20, 10, 0.5)
-) as (a,b,c)
+) as v(a,b,c)
----
10
20
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
@@ -21,22 +21,18 @@ 0
query T nosort
SELECT greatest(3.321, 4.4321, '0.210', '5.54321', -6.54321)
----
-5.54321
+5.5432
query T nosort
SELECT least(3.321, 4.4321, '0.210', '5.54321', -6.54321)
----
--6.54321
+-6.5432
-query T nosort
+statement error 22018!conversion of string 'A' to type bte failed.
SELECT greatest(3, 4, '0', '5', 'A', 'z')
-----
-z
-query T nosort
+statement error 22018!conversion of string 'A' to type bte failed.
SELECT least(3, 4, 1, 2, '0', '5', 'A', 'z')
-----
-0
query T nosort
SELECT greatest('!', 3, 4, '0', '5', 'A', 'z')
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
@@ -32,7 +32,7 @@ NULL
999
has null
-statement error syntax error, unexpected ',', expecting ')' or OR in: "select
i, c, ifnull(i, c,"
+statement error syntax error, unexpected ',' in: "select i, c, ifnull(i, c,"
select i, c, IFNULL(i, c, 999) as "IFNULL(i,c,999)" from t6933
statement ok
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
@@ -562,11 +562,12 @@ DROP TABLE v0
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
+query I
+SELECT 2 FROM v0 AS v0 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 )
+DELETE FROM v0 WHERE EXISTS ( SELECT 2 FROM v0 AS v0 WHERE v0 . v2 = ( SELECT
v2 WHERE v2 = 2 ) + v0 . v1 )
statement ok
DROP TABLE v0
diff --git a/sql/test/BugTracker-2024/Tests/7550-select-statistics-auth.test
b/sql/test/BugTracker-2024/Tests/7550-select-statistics-auth.test
--- a/sql/test/BugTracker-2024/Tests/7550-select-statistics-auth.test
+++ b/sql/test/BugTracker-2024/Tests/7550-select-statistics-auth.test
@@ -8,7 +8,7 @@ create table abc(col1 int)
@connection(id=c2, username=test, password=test)
query TTT nosort
-SELECT schema, table, column FROM sys.statistics where schema = 'test'
+SELECT schema, "table", "column" FROM sys.statistics where schema = 'test'
----
test
abc
@@ -16,7 +16,7 @@ col1
@connection(id=c2, username=test, password=test)
query TTT nosort
-SELECT schema, table, column FROM sys.statistics() where schema = 'test'
+SELECT schema, "table", "column" FROM sys.statistics() where schema = 'test'
----
test
abc
diff --git a/sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test
b/sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test
--- a/sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test
+++ b/sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test
@@ -4,7 +4,7 @@ CREATE MERGE TABLE testagain (a int, b v
statement ok
CREATE TABLE sublimits2 (a int, b varchar(32))
-statement error 42000!SELECT: no such unary operator 'addtwo'(tinyint)
+statement error 42000!SELECT: no such operator 'addtwo'(tinyint)
ALTER TABLE testagain ADD TABLE sublimits2 AS PARTITION IN (-100 * 2, '-90',
'120', addtwo(55), 11.2)
statement ok
diff --git a/sql/test/BugTracker-2024/Tests/exp_ref-Bug-7479.test
b/sql/test/BugTracker-2024/Tests/exp_ref-Bug-7479.test
--- a/sql/test/BugTracker-2024/Tests/exp_ref-Bug-7479.test
+++ b/sql/test/BugTracker-2024/Tests/exp_ref-Bug-7479.test
@@ -1,25 +1,25 @@
query I nosort
-WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS
+WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS a
----
1
1
query I nosort
-WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS WHERE x IN
( SELECT x FROM x AS )
+WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS a WHERE x
IN ( SELECT x FROM x AS b)
----
1
1
-statement error syntax error, unexpected ')' in: "with x as ( select 1 x union
select - '199419' ) select 1 from x as where x in ("
-WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS WHERE x IN
( SELECT min ( x ) OVER ( PARTITION BY x ) AS )
+statement error 42000!syntax error, unexpected ')' in: "with x as ( select 1 x
union select - '199419' ) select 1 from x as a where x in ( select min ( x )
over ( partition by x ) as )"
+WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS a WHERE x
IN ( SELECT min ( x ) OVER ( PARTITION BY x ) AS )
query I nosort
-WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS WHERE x IN
( SELECT x FROM x , ( SELECT min ( x ) OVER ( PARTITION BY x ) ) AS )
+WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS a WHERE x
IN ( SELECT x FROM x , ( SELECT min ( x ) OVER ( PARTITION BY x ) ) AS b)
----
1
1
statement error GDK reported error: BATsubcross: more than one match
-SELECT ( WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS
WHERE x IN ( SELECT x FROM x , ( SELECT min ( x ) OVER ( PARTITION BY x ) ) AS
) )
+SELECT ( WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS a
WHERE x IN ( SELECT x FROM x , ( SELECT min ( x ) OVER ( PARTITION BY x ) ) AS
b) )
----
diff --git a/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test
b/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test
--- a/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test
+++ b/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test
@@ -4,22 +4,22 @@ WITH x AS ( SELECT 1 x UNION SELECT 1 )
1
query I nosort
-WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM ( SELECT ( CASE WHEN 1
THEN x END ) x , 1 * x FROM x) AS
+WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM ( SELECT ( CASE WHEN 1
THEN x END ) x , 1 * x FROM x) AS b
----
1
query I nosort
-WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM ( SELECT ( CASE WHEN 1
THEN x END ) x , 1 * x FROM x UNION SELECT 1 , 1 ) AS
+WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM ( SELECT ( CASE WHEN 1
THEN x END ) x , 1 * x FROM x UNION SELECT 1 , 1 ) AS b
----
1
query I nosort
-WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM x WHERE ( SELECT x FROM
( SELECT ( CASE WHEN 1 THEN x END ) x , 1 * x FROM x UNION SELECT x , x ) AS )
+WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM x WHERE ( SELECT x FROM
( SELECT ( CASE WHEN 1 THEN x END ) x , 1 * x FROM x UNION SELECT x , x ) AS b)
----
1
query I nosort
-SELECT ( WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM x WHERE (
SELECT x FROM ( SELECT ( CASE WHEN 1 THEN x END ) x , 1 * x FROM x UNION SELECT
x , x ) AS ) )
+SELECT ( WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM x WHERE (
SELECT x FROM ( SELECT ( CASE WHEN 1 THEN x END ) x , 1 * x FROM x UNION SELECT
x , x ) AS b) )
----
1
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
