Changeset: 8636a40bdeb4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8636a40bdeb4 Added Files: sql/test/information-schema/Tests/All sql/test/information-schema/Tests/SingleServer sql/test/information-schema/Tests/character_sets.test sql/test/information-schema/Tests/columns.test sql/test/information-schema/Tests/schemata.test sql/test/information-schema/Tests/tables.test sql/test/information-schema/Tests/views.test Branch: default Log Message:
Add first tests for new INFORMATION_SCHEMA views diffs (truncated from 395 to 300 lines): diff --git a/sql/test/information-schema/Tests/All b/sql/test/information-schema/Tests/All new file mode 100644 --- /dev/null +++ b/sql/test/information-schema/Tests/All @@ -0,0 +1,6 @@ +character_sets +schemata +tables +views +columns + diff --git a/sql/test/information-schema/Tests/SingleServer b/sql/test/information-schema/Tests/SingleServer new file mode 100644 diff --git a/sql/test/information-schema/Tests/character_sets.test b/sql/test/information-schema/Tests/character_sets.test new file mode 100644 --- /dev/null +++ b/sql/test/information-schema/Tests/character_sets.test @@ -0,0 +1,27 @@ +query TTTTTTTT rowsort +SELECT + CHARACTER_SET_CATALOG, + CHARACTER_SET_SCHEMA, + CHARACTER_SET_NAME, + CHARACTER_REPERTOIRE, + FORM_OF_USE, + DEFAULT_COLLATE_CATALOG, + DEFAULT_COLLATE_SCHEMA, + DEFAULT_COLLATE_NAME +FROM INFORMATION_SCHEMA.CHARACTER_SETS +---- +NULL +NULL +UTF-8 +ISO/IEC 10646:2021 +UTF-8 +NULL +NULL +NULL + +query ITTT rowsort +SELECT COUNT(*) AS duplicates, CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA, CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS + GROUP BY CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA, CHARACTER_SET_NAME + HAVING COUNT(*) > 1 +---- + diff --git a/sql/test/information-schema/Tests/columns.test b/sql/test/information-schema/Tests/columns.test new file mode 100644 --- /dev/null +++ b/sql/test/information-schema/Tests/columns.test @@ -0,0 +1,173 @@ +query TTTTITTTIIIIIITITTTTTTTTTTTTTTTITTTTIIIITTTTTTTTII rowsort +SELECT + TABLE_CATALOG, + TABLE_SCHEMA, + TABLE_NAME, + COLUMN_NAME, + ORDINAL_POSITION, + COLUMN_DEFAULT, + IS_NULLABLE, + DATA_TYPE, + CHARACTER_MAXIMUM_LENGTH, + CHARACTER_OCTET_LENGTH, + NUMERIC_PRECISION, + NUMERIC_PRECISION_RADIX, + NUMERIC_SCALE, + DATETIME_PRECISION, + INTERVAL_TYPE, + INTERVAL_PRECISION, + CHARACTER_SET_CATALOG, + CHARACTER_SET_SCHEMA, + CHARACTER_SET_NAME, + COLLATION_CATALOG, + COLLATION_SCHEMA, + COLLATION_NAME, + DOMAIN_CATALOG, + DOMAIN_SCHEMA, + DOMAIN_NAME, + UDT_CATALOG, + UDT_SCHEMA, + UDT_NAME, + SCOPE_CATALOG, + SCOPE_SCHEMA, + SCOPE_NAME, + MAXIMUM_CARDINALITY, + DTD_IDENTIFIER, + IS_SELF_REFERENCING, + IS_IDENTITY, + IDENTITY_GENERATION, + IDENTITY_START, + IDENTITY_INCREMENT, + IDENTITY_MAXIMUM, + IDENTITY_MINIMUM, + IDENTITY_CYCLE, + IS_GENERATED, + GENERATION_EXPRESSION, + IS_SYSTEM_TIME_PERIOD_START, + IS_SYSTEM_TIME_PERIOD_END, + SYSTEM_TIME_PERIOD_TIMESTAMP_GENERATION, + IS_UPDATABLE, + DECLARED_DATA_TYPE, + DECLARED_NUMERIC_PRECISION, + DECLARED_NUMERIC_SCALE +FROM INFORMATION_SCHEMA.COLUMNS +WHERE TABLE_SCHEMA = 'information_schema' AND TABLE_NAME = 'columns' AND COLUMN_NAME = 'column_name' +---- +NULL +information_schema +columns +column_name +4 +NULL +YES +varchar +1024 +3072 +NULL +NULL +NULL +NULL +NULL +NULL +NULL +NULL +UTF-8 +NULL +NULL +NULL +NULL +NULL +NULL +NULL +NULL +NULL +NULL +NULL +NULL +NULL +NULL +NO +NO +NULL +NULL +NULL +NULL +NULL +NULL +NO +NULL +NO +NO +NO +NO +NULL +NULL +NULL + +query TTTTITTTIIIIIITITTTTTTTTTTTTTTTITTTTIIIITTTTTTTTIIIIIIT rowsort +SELECT + TABLE_CATALOG, + TABLE_SCHEMA, + TABLE_NAME, + COLUMN_NAME, + ORDINAL_POSITION, + COLUMN_DEFAULT, + IS_NULLABLE, + DATA_TYPE, + CHARACTER_MAXIMUM_LENGTH, + CHARACTER_OCTET_LENGTH, + NUMERIC_PRECISION, + NUMERIC_PRECISION_RADIX, + NUMERIC_SCALE, + DATETIME_PRECISION, + INTERVAL_TYPE, + INTERVAL_PRECISION, + CHARACTER_SET_CATALOG, + CHARACTER_SET_SCHEMA, + CHARACTER_SET_NAME, + COLLATION_CATALOG, + COLLATION_SCHEMA, + COLLATION_NAME, + DOMAIN_CATALOG, + DOMAIN_SCHEMA, + DOMAIN_NAME, + UDT_CATALOG, + UDT_SCHEMA, + UDT_NAME, + SCOPE_CATALOG, + SCOPE_SCHEMA, + SCOPE_NAME, + MAXIMUM_CARDINALITY, + DTD_IDENTIFIER, + IS_SELF_REFERENCING, + IS_IDENTITY, + IDENTITY_GENERATION, + IDENTITY_START, + IDENTITY_INCREMENT, + IDENTITY_MAXIMUM, + IDENTITY_MINIMUM, + IDENTITY_CYCLE, + IS_GENERATED, + GENERATION_EXPRESSION, + IS_SYSTEM_TIME_PERIOD_START, + IS_SYSTEM_TIME_PERIOD_END, + SYSTEM_TIME_PERIOD_TIMESTAMP_GENERATION, + IS_UPDATABLE, + DECLARED_DATA_TYPE, + DECLARED_NUMERIC_PRECISION, + DECLARED_NUMERIC_SCALE, + schema_id, + table_id, + column_id, + is_system, + comments +FROM INFORMATION_SCHEMA.COLUMNS +WHERE TABLE_SCHEMA = '' OR TABLE_NAME = '' OR COLUMN_NAME = '' +---- + +query ITTTT rowsort +SELECT COUNT(*) AS duplicates, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS + GROUP BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME + HAVING COUNT(*) > 1 +---- + diff --git a/sql/test/information-schema/Tests/schemata.test b/sql/test/information-schema/Tests/schemata.test new file mode 100644 --- /dev/null +++ b/sql/test/information-schema/Tests/schemata.test @@ -0,0 +1,42 @@ +query TTTTTTT rowsort +SELECT + CATALOG_NAME, + SCHEMA_NAME, + SCHEMA_OWNER, + DEFAULT_CHARACTER_SET_CATALOG, + DEFAULT_CHARACTER_SET_SCHEMA, + DEFAULT_CHARACTER_SET_NAME, + SQL_PATH +FROM INFORMATION_SCHEMA.SCHEMATA +WHERE SCHEMA_NAME = 'information_schema' +---- +NULL +information_schema +monetdb +NULL +NULL +UTF-8 +NULL + +query TTTTTTTIIT rowsort +SELECT + CATALOG_NAME, + SCHEMA_NAME, + SCHEMA_OWNER, + DEFAULT_CHARACTER_SET_CATALOG, + DEFAULT_CHARACTER_SET_SCHEMA, + DEFAULT_CHARACTER_SET_NAME, + SQL_PATH, + schema_id, + is_system, + comments +FROM INFORMATION_SCHEMA.SCHEMATA +WHERE SCHEMA_NAME = '' +---- + +query ITT rowsort +SELECT COUNT(*) AS duplicates, CATALOG_NAME, SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA + GROUP BY CATALOG_NAME, SCHEMA_NAME + HAVING COUNT(*) > 1 +---- + diff --git a/sql/test/information-schema/Tests/tables.test b/sql/test/information-schema/Tests/tables.test new file mode 100644 --- /dev/null +++ b/sql/test/information-schema/Tests/tables.test @@ -0,0 +1,62 @@ +query TTTTTTTTTTTT rowsort +SELECT + TABLE_CATALOG, + TABLE_SCHEMA, + TABLE_NAME, + TABLE_TYPE, + SELF_REFERENCING_COLUMN_NAME, + REFERENCE_GENERATION, + USER_DEFINED_TYPE_CATALOG, + USER_DEFINED_TYPE_SCHEMA, + USER_DEFINED_TYPE_NAME, + IS_INSERTABLE_INTO, + IS_TYPED, + COMMIT_ACTION +FROM INFORMATION_SCHEMA.TABLES +WHERE TABLE_SCHEMA = 'information_schema' AND TABLE_NAME = 'tables' +---- +NULL +information_schema +tables +SYSTEM VIEW +NULL +NULL +NULL +NULL _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
