Changeset: ebfbcbd7c0dc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/ebfbcbd7c0dc
Modified Files:
sql/test/Dependencies/Tests/dependency_DBobjects.test
sql/test/SQLancer/Tests/sqlancer09.test
sql/test/cte/Tests/test_correlated_recursive_cte.test
sql/test/emptydb/Tests/check.SQL.py
Branch: clean_parser
Log Message:
approved output
diffs (130 lines):
diff --git a/sql/test/Dependencies/Tests/dependency_DBobjects.test
b/sql/test/Dependencies/Tests/dependency_DBobjects.test
--- a/sql/test/Dependencies/Tests/dependency_DBobjects.test
+++ b/sql/test/Dependencies/Tests/dependency_DBobjects.test
@@ -662,6 +662,9 @@ SELECT v.name, tri.name, 'DEP_TRIGGER' f
query TTT nosort
SELECT f1.name, f2.name, 'DEP_FUNC' from sys.functions as f1, sys.functions as
f2, sys.dependencies as dep where f1.id = dep.id AND f2.id = dep.depend_id AND
dep.depend_type = 7 order by f2.name, f1.name
----
+date_to_str
+dayname
+DEP_FUNC
describe_type
describe_columns
DEP_FUNC
@@ -683,6 +686,9 @@ DEP_FUNC
sq
get_remote_table_expressions
DEP_FUNC
+date_to_str
+monthname
+DEP_FUNC
ms_trunc
ms_round
DEP_FUNC
diff --git a/sql/test/SQLancer/Tests/sqlancer09.test
b/sql/test/SQLancer/Tests/sqlancer09.test
--- a/sql/test/SQLancer/Tests/sqlancer09.test
+++ b/sql/test/SQLancer/Tests/sqlancer09.test
@@ -723,7 +723,7 @@ create or replace view v0(vc0, vc1, vc2)
statement ok
create or replace view v1(vc0, vc1) as (select
round(0.80863825841427316998277774473535828292369842529296875,
0.6571010204254646), '䝀i8jPo' where not (false))
-statement error 42000!SELECT: cannot use non GROUP BY column 'v0.vc0' in query
results without an aggregate function
+statement error 42000!SELECT: non-integer constant in GROUP BY
select all v0.vc2, greatest(min(all least(-266013300, 864326131)),
-1183805674), greatest(-544857133, + (v0.vc2)) from v0, v1
inner join (values (+ (88)), (greatest(0.8732546822607857,
greatest(1933292715, -525885982))), (case when (-1466474216) in
(-1504372996, 417052418, 94) then least(28288, 1447812316) when cast('' as
boolean) then "second"(time '14:18:59') else
diff --git a/sql/test/cte/Tests/test_correlated_recursive_cte.test
b/sql/test/cte/Tests/test_correlated_recursive_cte.test
--- a/sql/test/cte/Tests/test_correlated_recursive_cte.test
+++ b/sql/test/cte/Tests/test_correlated_recursive_cte.test
@@ -196,7 +196,7 @@ 1000000
NULL
# limit in subquery
-skipif knownfail
+#skipif knownfail
query I
SELECT t2.*
FROM (VALUES (10)) t(_corr), LATERAL (
diff --git a/sql/test/emptydb/Tests/check.SQL.py
b/sql/test/emptydb/Tests/check.SQL.py
--- a/sql/test/emptydb/Tests/check.SQL.py
+++ b/sql/test/emptydb/Tests/check.SQL.py
@@ -68,8 +68,8 @@ sys_pkeys = [
('environment', 'name'),
('db_user_info', 'name'),
('statistics', 'column_id'),
- ('"storage"()', 'schema, table, column'),
- ('storagemodelinput', 'schema, table, column'),
+ ('"storage"()', 'schema, "table", "column"'),
+ ('storagemodelinput', 'schema, "table", "column"'),
('rejects', 'rowid'),
@@ -204,32 +204,32 @@ sys_fkeys = [
('statistics', 'type', 'sqlname', 'types'),
('storage()', 'schema', 'name', 'schemas'),
('storage()', 'table', 'name', '(SELECT name FROM sys._tables UNION ALL
SELECT name FROM tmp._tables) as t'),
- ('storage()', 'schema, table', 'sname, tname', '(SELECT sch.name as sname,
tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON sch.id =
tbl.schema_id) as t'),
- ('storage()', 'column', 'name', '(SELECT name FROM sys._columns UNION ALL
SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys UNION ALL
SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION ALL SELECT
name FROM tmp.idxs) as c'),
+ ('storage()', 'schema, "table"', 'sname, tname', '(SELECT sch.name as
sname, tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON
sch.id = tbl.schema_id) as t'),
+ ('storage()', '"column"', 'name', '(SELECT name FROM sys._columns UNION
ALL SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys UNION ALL
SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION ALL SELECT
name FROM tmp.idxs) as c'),
('storage()', 'type', 'sqlname', 'types'),
('storage', 'schema', 'name', 'schemas'),
- ('storage', 'table', 'name', '(SELECT name FROM sys._tables UNION ALL
SELECT name FROM tmp._tables) as t'),
- ('storage', 'schema, table', 'sname, tname', '(SELECT sch.name as sname,
tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON sch.id =
tbl.schema_id) as t'),
+ ('storage', '"table"', 'name', '(SELECT name FROM sys._tables UNION ALL
SELECT name FROM tmp._tables) as t'),
+ ('storage', 'schema, "table"', 'sname, tname', '(SELECT sch.name as sname,
tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON sch.id =
tbl.schema_id) as t'),
('storage', 'column', 'name', '(SELECT name FROM sys._columns UNION ALL
SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys UNION ALL
SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION ALL SELECT
name FROM tmp.idxs) as c'),
('storage', 'type', 'sqlname', 'types'),
('storagemodel', 'schema', 'name', 'schemas'),
- ('storagemodel', 'table', 'name', '(SELECT name FROM sys._tables UNION ALL
SELECT name FROM tmp._tables) as t'),
- ('storagemodel', 'schema, table', 'sname, tname', '(SELECT sch.name as
sname, tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON
sch.id = tbl.schema_id) as t'),
- ('storagemodel', 'column', 'name', '(SELECT name FROM sys._columns UNION
ALL SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys UNION ALL
SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION ALL SELECT
name FROM tmp.idxs) as c'),
+ ('storagemodel', '"table"', 'name', '(SELECT name FROM sys._tables UNION
ALL SELECT name FROM tmp._tables) as t'),
+ ('storagemodel', 'schema, "table"', 'sname, tname', '(SELECT sch.name as
sname, tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON
sch.id = tbl.schema_id) as t'),
+ ('storagemodel', '"column"', 'name', '(SELECT name FROM sys._columns UNION
ALL SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys UNION ALL
SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION ALL SELECT
name FROM tmp.idxs) as c'),
('storagemodel', 'type', 'sqlname', 'types'),
('storagemodelinput', 'schema', 'name', 'schemas'),
- ('storagemodelinput', 'table', 'name', '(SELECT name FROM sys._tables
UNION ALL SELECT name FROM tmp._tables) as t'),
- ('storagemodelinput', 'schema, table', 'sname, tname', '(SELECT sch.name
as sname, tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON
sch.id = tbl.schema_id) as t'),
- ('storagemodelinput', 'column', 'name', '(SELECT name FROM sys._columns
UNION ALL SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys
UNION ALL SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION
ALL SELECT name FROM tmp.idxs) as c'),
+ ('storagemodelinput', '"table"', 'name', '(SELECT name FROM sys._tables
UNION ALL SELECT name FROM tmp._tables) as t'),
+ ('storagemodelinput', 'schema, "table"', 'sname, tname', '(SELECT sch.name
as sname, tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON
sch.id = tbl.schema_id) as t'),
+ ('storagemodelinput', '"column"', 'name', '(SELECT name FROM sys._columns
UNION ALL SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys
UNION ALL SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION
ALL SELECT name FROM tmp.idxs) as c'),
('storagemodelinput', 'type', 'sqlname', 'types'),
('tablestoragemodel', 'schema', 'name', 'schemas'),
- ('tablestoragemodel', 'table', 'name', '(SELECT name FROM sys._tables
UNION ALL SELECT name FROM tmp._tables) as t'),
- ('tablestoragemodel', 'schema, table', 'sname, tname', '(SELECT sch.name
as sname, tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON
sch.id = tbl.schema_id) as t'),
+ ('tablestoragemodel', '"table"', 'name', '(SELECT name FROM sys._tables
UNION ALL SELECT name FROM tmp._tables) as t'),
+ ('tablestoragemodel', 'schema, "table"', 'sname, tname', '(SELECT sch.name
as sname, tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON
sch.id = tbl.schema_id) as t'),
('schemastorage', 'schema', 'name', 'schemas'),
('tablestorage', 'schema', 'name', 'schemas'),
- ('tablestorage', 'table', 'name', '(SELECT name FROM sys._tables UNION ALL
SELECT name FROM tmp._tables) as t'),
- ('tablestorage', 'schema, table', 'sname, tname', '(SELECT sch.name as
sname, tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON
sch.id = tbl.schema_id) as t'),
+ ('tablestorage', '"table"', 'name', '(SELECT name FROM sys._tables UNION
ALL SELECT name FROM tmp._tables) as t'),
+ ('tablestorage', 'schema, "table"', 'sname, tname', '(SELECT sch.name as
sname, tbl.name as tname FROM sys.schemas AS sch JOIN sys.tables AS tbl ON
sch.id = tbl.schema_id) as t'),
('table_partitions', 'table_id', 'id', '_tables'),
('table_partitions WHERE column_id IS NOT NULL AND ', 'column_id', 'id',
'_columns'),
('range_partitions', 'table_id', 'id', '_tables'),
@@ -349,8 +349,8 @@ sys_notnull = [
('statistics', 'revsorted'),
('"storage"()', 'schema'),
- ('"storage"()', 'table'),
- ('"storage"()', 'column'),
+ ('"storage"()', '"table"'),
+ ('"storage"()', '"column"'),
('"storage"()', 'type'),
('"storage"()', 'mode'),
('"storage"()', 'location'),
@@ -363,8 +363,8 @@ sys_notnull = [
('"storage"()', 'imprints'),
('"storage"()', 'orderidx'),
('storagemodelinput', 'schema'),
- ('storagemodelinput', 'table'),
- ('storagemodelinput', 'column'),
+ ('storagemodelinput', '"table"'),
+ ('storagemodelinput', '"column"'),
('storagemodelinput', 'type'),
('storagemodelinput', 'typewidth'),
('storagemodelinput', 'count'),
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
