Changeset: 0cc006278cdf for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0cc006278cdf
Modified Files:
sql/test/emptydb/Tests/check.SQL.py
Branch: clean_parser
Log Message:
improved test script
diffs (20 lines):
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
@@ -203,14 +203,14 @@ sys_fkeys = [
('statistics', 'column_id', 'id', '(SELECT id FROM sys._columns UNION ALL
SELECT id FROM tmp._columns) as c'),
('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()', '"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'),
('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', '"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'),
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
