Changeset: 434ec06ac75b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/434ec06ac75b
Modified Files:
sql/test/emptydb/Tests/check.stable.out
Branch: cleanup_types
Log Message:
Approve non-hugeint output.
diffs (truncated from 3671 to 300 lines):
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -443,7 +443,7 @@ select 'null in fkeys.delete_action', de
[ "sys.schemas", "tmp", "sysadmin", "monetdb", true, NULL
]
% .%25, .s, .t, ., ., .t, ., ., . #
table_name
% %25, name, name, query, type, system, commit_action, access, comment
# name
-% char, varchar, varchar, clob, varchar,
boolean, char, char, varchar # type
+% char, varchar, varchar, char, varchar,
boolean, char, char, varchar # type
% 11, 18, 34, 6812, 5, 5, 8, 10, 0 # length
[ "sys._tables", "information_schema", "character_sets", "create
view information_schema.character_sets as select cast(null as varchar(1)) as
character_set_catalog, cast(null as varchar(1)) as character_set_schema,
cast('UTF-8' as varchar(16)) as character_set_name, cast('ISO/IEC 10646:2021'
as varchar(20)) as character_repertoire, cast('UTF-8' as varchar(16)) as
form_of_use, cast(null as varchar(1)) as default_collate_catalog, cast(null as
varchar(1)) as default_collate_schema, cast(null as varchar(1)) as
default_collate_name;", "VIEW", true, "COMMIT", "WRITABLE", NULL
]
[ "sys._tables", "information_schema", "check_constraints", "create
view information_schema.check_constraints as select cast(null as varchar(1)) as
constraint_catalog, cast(null as varchar(1024)) as constraint_schema, cast(null
as varchar(1024)) as constraint_name, cast(null as varchar(1024)) as
check_clause where 1=0;", "VIEW", true, "COMMIT", "WRITABLE", NULL
]
@@ -607,18 +607,18 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "information_schema", "columns", "table_schema",
"varchar", 1024, 0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "table_name",
"varchar", 1024, 0, NULL, true, 2, NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "column_name",
"varchar", 1024, 0, NULL, true, 3, NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"ordinal_position", "int", 32, 0, NULL, true, 4, NULL,
NULL ]
+[ "sys._columns", "information_schema", "columns",
"ordinal_position", "int", 6, 0, NULL, true, 4, NULL,
NULL ]
[ "sys._columns", "information_schema", "columns",
"column_default", "varchar", 2048, 0, NULL, true, 5,
NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "is_nullable",
"varchar", 3, 0, NULL, true, 6, NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "data_type",
"varchar", 1024, 0, NULL, true, 7, NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"character_maximum_length", "int", 32, 0, NULL, true, 8,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"character_octet_length", "bigint", 64, 0, NULL, true,
9, NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"numeric_precision", "int", 32, 0, NULL, true, 10, NULL,
NULL ]
-[ "sys._columns", "information_schema", "columns",
"numeric_precision_radix", "int", 32, 0, NULL, true, 11,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"numeric_scale", "int", 32, 0, NULL, true, 12, NULL,
NULL ]
-[ "sys._columns", "information_schema", "columns",
"datetime_precision", "int", 32, 0, NULL, true, 13, NULL,
NULL ]
+[ "sys._columns", "information_schema", "columns",
"character_maximum_length", "int", 31, 0, NULL, true, 8,
NULL, NULL ]
+[ "sys._columns", "information_schema", "columns",
"character_octet_length", "bigint", 63, 0, NULL, true,
9, NULL, NULL ]
+[ "sys._columns", "information_schema", "columns",
"numeric_precision", "int", 31, 0, NULL, true, 10, NULL,
NULL ]
+[ "sys._columns", "information_schema", "columns",
"numeric_precision_radix", "int", 31, 0, NULL, true, 11,
NULL, NULL ]
+[ "sys._columns", "information_schema", "columns",
"numeric_scale", "int", 31, 0, NULL, true, 12, NULL,
NULL ]
+[ "sys._columns", "information_schema", "columns",
"datetime_precision", "int", 31, 0, NULL, true, 13, NULL,
NULL ]
[ "sys._columns", "information_schema", "columns",
"interval_type", "varchar", 40, 0, NULL, true, 14,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"interval_precision", "int", 32, 0, NULL, true, 15, NULL,
NULL ]
+[ "sys._columns", "information_schema", "columns",
"interval_precision", "int", 31, 0, NULL, true, 15, NULL,
NULL ]
[ "sys._columns", "information_schema", "columns",
"character_set_catalog", "varchar", 1, 0, NULL, true,
16, NULL, NULL ]
[ "sys._columns", "information_schema", "columns",
"character_set_schema", "varchar", 1, 0, NULL, true, 17,
NULL, NULL ]
[ "sys._columns", "information_schema", "columns",
"character_set_name", "varchar", 16, 0, NULL, true, 18,
NULL, NULL ]
@@ -634,15 +634,15 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "information_schema", "columns",
"scope_catalog", "varchar", 1, 0, NULL, true, 28,
NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "scope_schema",
"varchar", 1, 0, NULL, true, 29, NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "scope_name",
"varchar", 1, 0, NULL, true, 30, NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"maximum_cardinality", "int", 32, 0, NULL, true, 31, NULL,
NULL ]
+[ "sys._columns", "information_schema", "columns",
"maximum_cardinality", "int", 31, 0, NULL, true, 31, NULL,
NULL ]
[ "sys._columns", "information_schema", "columns",
"dtd_identifier", "varchar", 1, 0, NULL, true, 32,
NULL, NULL ]
[ "sys._columns", "information_schema", "columns",
"is_self_referencing", "varchar", 3, 0, NULL, true, 33,
NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "is_identity",
"varchar", 3, 0, NULL, true, 34, NULL, NULL ]
[ "sys._columns", "information_schema", "columns",
"identity_generation", "varchar", 256, 0, NULL, true, 35,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"identity_start", "bigint", 64, 0, NULL, true, 36,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"identity_increment", "bigint", 64, 0, NULL, true, 37,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"identity_maximum", "bigint", 64, 0, NULL, true, 38,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"identity_minimum", "bigint", 64, 0, NULL, true, 39,
NULL, NULL ]
+[ "sys._columns", "information_schema", "columns",
"identity_start", "bigint", 63, 0, NULL, true, 36,
NULL, NULL ]
+[ "sys._columns", "information_schema", "columns",
"identity_increment", "bigint", 63, 0, NULL, true, 37,
NULL, NULL ]
+[ "sys._columns", "information_schema", "columns",
"identity_maximum", "bigint", 63, 0, NULL, true, 38,
NULL, NULL ]
+[ "sys._columns", "information_schema", "columns",
"identity_minimum", "bigint", 63, 0, NULL, true, 39,
NULL, NULL ]
[ "sys._columns", "information_schema", "columns",
"identity_cycle", "varchar", 3, 0, NULL, true, 40,
NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "is_generated",
"varchar", 3, 0, NULL, true, 41, NULL, NULL ]
[ "sys._columns", "information_schema", "columns",
"generation_expression", "varchar", 1024, 0, NULL, true,
42, NULL, NULL ]
@@ -651,18 +651,18 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "information_schema", "columns",
"system_time_period_timestamp_generation", "varchar", 3, 0,
NULL, true, 45, NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "is_updatable",
"varchar", 3, 0, NULL, true, 46, NULL, NULL ]
[ "sys._columns", "information_schema", "columns",
"declared_data_type", "varchar", 1, 0, NULL, true, 47,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"declared_numeric_precision", "int", 32, 0, NULL, true, 48,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns",
"declared_numeric_scale", "int", 32, 0, NULL, true, 49,
NULL, NULL ]
-[ "sys._columns", "information_schema", "columns", "schema_id",
"int", 32, 0, NULL, true, 50, NULL, NULL ]
-[ "sys._columns", "information_schema", "columns", "table_id",
"int", 32, 0, NULL, true, 51, NULL, NULL ]
-[ "sys._columns", "information_schema", "columns", "column_id",
"int", 32, 0, NULL, true, 52, NULL, NULL ]
-[ "sys._columns", "information_schema", "columns", "sequence_id",
"int", 32, 0, NULL, true, 53, NULL, NULL ]
+[ "sys._columns", "information_schema", "columns",
"declared_numeric_precision", "int", 31, 0, NULL, true, 48,
NULL, NULL ]
+[ "sys._columns", "information_schema", "columns",
"declared_numeric_scale", "int", 31, 0, NULL, true, 49,
NULL, NULL ]
+[ "sys._columns", "information_schema", "columns", "schema_id",
"int", 13, 0, NULL, true, 50, NULL, NULL ]
+[ "sys._columns", "information_schema", "columns", "table_id",
"int", 13, 0, NULL, true, 51, NULL, NULL ]
+[ "sys._columns", "information_schema", "columns", "column_id",
"int", 13, 0, NULL, true, 52, NULL, NULL ]
+[ "sys._columns", "information_schema", "columns", "sequence_id",
"int", 31, 0, NULL, true, 53, NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "is_system",
"boolean", 1, 0, NULL, true, 54, NULL, NULL ]
[ "sys._columns", "information_schema", "columns", "comments",
"varchar", 65000, 0, NULL, true, 55, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"specific_catalog", "varchar", 1, 0, NULL, true, 0,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"specific_schema", "varchar", 1024, 0, NULL, true, 1,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"specific_name", "varchar", 270, 0, NULL, true, 2,
NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"ordinal_position", "int", 32, 0, NULL, true, 3, NULL,
NULL ]
+[ "sys._columns", "information_schema", "parameters",
"ordinal_position", "int", 31, 0, NULL, true, 3, NULL,
NULL ]
[ "sys._columns", "information_schema", "parameters",
"parameter_mode", "varchar", 5, 0, NULL, true, 4,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters", "is_result",
"varchar", 3, 0, NULL, true, 5, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters", "as_locator",
"varchar", 1, 0, NULL, true, 6, NULL, NULL ]
@@ -674,37 +674,37 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "information_schema", "parameters",
"to_sql_specific_schema", "varchar", 1, 0, NULL, true,
12, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"to_sql_specific_name", "varchar", 1, 0, NULL, true, 13,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters", "data_type",
"varchar", 1024, 0, NULL, true, 14, NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"character_maximum_length", "int", 32, 0, NULL, true, 15,
NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"character_octet_length", "bigint", 64, 0, NULL, true,
16, NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters",
"character_maximum_length", "int", 31, 0, NULL, true, 15,
NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters",
"character_octet_length", "bigint", 63, 0, NULL, true,
16, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"character_set_catalog", "varchar", 1, 0, NULL, true,
17, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"character_set_schema", "varchar", 1, 0, NULL, true, 18,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"character_set_name", "varchar", 16, 0, NULL, true, 19,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"collation_catalog", "varchar", 1, 0, NULL, true, 20,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"collation_schema", "varchar", 1, 0, NULL, true, 21,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"collation_name", "varchar", 1, 0, NULL, true, 22,
NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"numeric_precision", "int", 32, 0, NULL, true, 23, NULL,
NULL ]
-[ "sys._columns", "information_schema", "parameters",
"numeric_precision_radix", "int", 32, 0, NULL, true, 24,
NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"numeric_scale", "int", 32, 0, NULL, true, 25, NULL,
NULL ]
-[ "sys._columns", "information_schema", "parameters",
"datetime_precision", "int", 32, 0, NULL, true, 26, NULL,
NULL ]
+[ "sys._columns", "information_schema", "parameters",
"numeric_precision", "int", 31, 0, NULL, true, 23, NULL,
NULL ]
+[ "sys._columns", "information_schema", "parameters",
"numeric_precision_radix", "int", 31, 0, NULL, true, 24,
NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters",
"numeric_scale", "int", 31, 0, NULL, true, 25, NULL,
NULL ]
+[ "sys._columns", "information_schema", "parameters",
"datetime_precision", "int", 31, 0, NULL, true, 26, NULL,
NULL ]
[ "sys._columns", "information_schema", "parameters",
"interval_type", "varchar", 40, 0, NULL, true, 27,
NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"interval_precision", "int", 32, 0, NULL, true, 28, NULL,
NULL ]
+[ "sys._columns", "information_schema", "parameters",
"interval_precision", "int", 31, 0, NULL, true, 28, NULL,
NULL ]
[ "sys._columns", "information_schema", "parameters", "udt_catalog",
"varchar", 1, 0, NULL, true, 29, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters", "udt_schema",
"varchar", 1, 0, NULL, true, 30, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters", "udt_name",
"varchar", 1, 0, NULL, true, 31, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"scope_catalog", "varchar", 1, 0, NULL, true, 32,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters", "scope_schema",
"varchar", 1, 0, NULL, true, 33, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters", "scope_name",
"varchar", 1, 0, NULL, true, 34, NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"maximum_cardinality", "int", 32, 0, NULL, true, 35, NULL,
NULL ]
+[ "sys._columns", "information_schema", "parameters",
"maximum_cardinality", "int", 31, 0, NULL, true, 35, NULL,
NULL ]
[ "sys._columns", "information_schema", "parameters",
"dtd_identifier", "varchar", 1, 0, NULL, true, 36,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"declared_data_type", "varchar", 1, 0, NULL, true, 37,
NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"declared_numeric_precision", "int", 32, 0, NULL, true, 38,
NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"declared_numeric_scale", "int", 32, 0, NULL, true, 39,
NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters",
"declared_numeric_precision", "int", 31, 0, NULL, true, 38,
NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters",
"declared_numeric_scale", "int", 31, 0, NULL, true, 39,
NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"parameter_default", "varchar", 1, 0, NULL, true, 40,
NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters", "schema_id",
"int", 32, 0, NULL, true, 41, NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters", "function_id",
"int", 32, 0, NULL, true, 42, NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters", "arg_id",
"int", 32, 0, NULL, true, 43, NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters", "schema_id",
"int", 13, 0, NULL, true, 41, NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters", "function_id",
"int", 13, 0, NULL, true, 42, NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters", "arg_id",
"int", 13, 0, NULL, true, 43, NULL, NULL ]
[ "sys._columns", "information_schema", "parameters",
"function_name", "varchar", 256, 0, NULL, true, 44,
NULL, NULL ]
-[ "sys._columns", "information_schema", "parameters",
"function_type", "int", 32, 0, NULL, true, 45, NULL,
NULL ]
+[ "sys._columns", "information_schema", "parameters",
"function_type", "int", 3, 0, NULL, true, 45, NULL,
NULL ]
[ "sys._columns", "information_schema", "parameters", "is_system",
"boolean", 1, 0, NULL, true, 46, NULL, NULL ]
[ "sys._columns", "information_schema", "referential_constraints",
"constraint_catalog", "varchar", 1, 0, NULL, true, 0,
NULL, NULL ]
[ "sys._columns", "information_schema", "referential_constraints",
"constraint_schema", "varchar", 1024, 0, NULL, true, 1,
NULL, NULL ]
@@ -715,14 +715,14 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "information_schema", "referential_constraints",
"match_option", "varchar", 7, 0, NULL, true, 6, NULL,
NULL ]
[ "sys._columns", "information_schema", "referential_constraints",
"update_rule", "varchar", 15, 0, NULL, true, 7, NULL,
NULL ]
[ "sys._columns", "information_schema", "referential_constraints",
"delete_rule", "varchar", 15, 0, NULL, true, 8, NULL,
NULL ]
-[ "sys._columns", "information_schema", "referential_constraints",
"fk_schema_id", "int", 32, 0, NULL, true, 9, NULL, NULL
]
-[ "sys._columns", "information_schema", "referential_constraints",
"fk_table_id", "int", 32, 0, NULL, true, 10, NULL, NULL
]
+[ "sys._columns", "information_schema", "referential_constraints",
"fk_schema_id", "int", 13, 0, NULL, true, 9, NULL, NULL
]
+[ "sys._columns", "information_schema", "referential_constraints",
"fk_table_id", "int", 13, 0, NULL, true, 10, NULL, NULL
]
[ "sys._columns", "information_schema", "referential_constraints",
"fk_table_name", "varchar", 1024, 0, NULL, true, 11,
NULL, NULL ]
-[ "sys._columns", "information_schema", "referential_constraints",
"fk_key_id", "int", 32, 0, NULL, true, 12, NULL, NULL
]
-[ "sys._columns", "information_schema", "referential_constraints",
"uc_schema_id", "int", 32, 0, NULL, true, 13, NULL, NULL
]
-[ "sys._columns", "information_schema", "referential_constraints",
"uc_table_id", "int", 32, 0, NULL, true, 14, NULL, NULL
]
+[ "sys._columns", "information_schema", "referential_constraints",
"fk_key_id", "int", 13, 0, NULL, true, 12, NULL, NULL
]
+[ "sys._columns", "information_schema", "referential_constraints",
"uc_schema_id", "int", 13, 0, NULL, true, 13, NULL, NULL
]
+[ "sys._columns", "information_schema", "referential_constraints",
"uc_table_id", "int", 13, 0, NULL, true, 14, NULL, NULL
]
[ "sys._columns", "information_schema", "referential_constraints",
"uc_table_name", "varchar", 1024, 0, NULL, true, 15,
NULL, NULL ]
-[ "sys._columns", "information_schema", "referential_constraints",
"uc_key_id", "int", 32, 0, NULL, true, 16, NULL, NULL
]
+[ "sys._columns", "information_schema", "referential_constraints",
"uc_key_id", "int", 13, 0, NULL, true, 16, NULL, NULL
]
[ "sys._columns", "information_schema", "routines",
"specific_catalog", "varchar", 1, 0, NULL, true, 0,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"specific_schema", "varchar", 1024, 0, NULL, true, 1,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"specific_name", "varchar", 270, 0, NULL, true, 2,
NULL, NULL ]
@@ -737,28 +737,28 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "information_schema", "routines", "udt_schema",
"varchar", 1, 0, NULL, true, 11, NULL, NULL ]
[ "sys._columns", "information_schema", "routines", "udt_name",
"varchar", 1, 0, NULL, true, 12, NULL, NULL ]
[ "sys._columns", "information_schema", "routines", "data_type",
"varchar", 1024, 0, NULL, true, 13, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"character_maximum_length", "int", 32, 0, NULL, true, 14,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"character_octet_length", "bigint", 64, 0, NULL, true,
15, NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"character_maximum_length", "int", 31, 0, NULL, true, 14,
NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"character_octet_length", "bigint", 63, 0, NULL, true,
15, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"character_set_catalog", "varchar", 1, 0, NULL, true,
16, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"character_set_schema", "varchar", 1, 0, NULL, true, 17,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"character_set_name", "char", 5, 0, NULL, true, 18, NULL,
NULL ]
[ "sys._columns", "information_schema", "routines",
"collation_catalog", "varchar", 1, 0, NULL, true, 19,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"collation_schema", "varchar", 1, 0, NULL, true, 20,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"collation_name", "varchar", 1, 0, NULL, true, 21,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"numeric_precision", "int", 32, 0, NULL, true, 22, NULL,
NULL ]
-[ "sys._columns", "information_schema", "routines",
"numeric_precision_radix", "int", 32, 0, NULL, true, 23,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"numeric_scale", "int", 32, 0, NULL, true, 24, NULL,
NULL ]
-[ "sys._columns", "information_schema", "routines",
"datetime_precision", "int", 32, 0, NULL, true, 25, NULL,
NULL ]
+[ "sys._columns", "information_schema", "routines",
"numeric_precision", "int", 31, 0, NULL, true, 22, NULL,
NULL ]
+[ "sys._columns", "information_schema", "routines",
"numeric_precision_radix", "int", 31, 0, NULL, true, 23,
NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"numeric_scale", "int", 31, 0, NULL, true, 24, NULL,
NULL ]
+[ "sys._columns", "information_schema", "routines",
"datetime_precision", "int", 31, 0, NULL, true, 25, NULL,
NULL ]
[ "sys._columns", "information_schema", "routines",
"interval_type", "varchar", 40, 0, NULL, true, 26,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"interval_precision", "int", 32, 0, NULL, true, 27, NULL,
NULL ]
+[ "sys._columns", "information_schema", "routines",
"interval_precision", "int", 31, 0, NULL, true, 27, NULL,
NULL ]
[ "sys._columns", "information_schema", "routines",
"type_udt_catalog", "varchar", 1, 0, NULL, true, 28,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"type_udt_schema", "varchar", 1, 0, NULL, true, 29,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"type_udt_name", "varchar", 1, 0, NULL, true, 30,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"scope_catalog", "varchar", 1, 0, NULL, true, 31,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines", "scope_schema",
"varchar", 1, 0, NULL, true, 32, NULL, NULL ]
[ "sys._columns", "information_schema", "routines", "scope_name",
"varchar", 1, 0, NULL, true, 33, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"maximum_cardinality", "int", 32, 0, NULL, true, 34, NULL,
NULL ]
-[ "sys._columns", "information_schema", "routines",
"dtd_identifier", "int", 32, 0, NULL, true, 35, NULL,
NULL ]
+[ "sys._columns", "information_schema", "routines",
"maximum_cardinality", "int", 31, 0, NULL, true, 34, NULL,
NULL ]
+[ "sys._columns", "information_schema", "routines",
"dtd_identifier", "int", 31, 0, NULL, true, 35, NULL,
NULL ]
[ "sys._columns", "information_schema", "routines", "routine_body",
"varchar", 8196, 0, NULL, true, 36, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"routine_definition", "varchar", 8196, 0, NULL, true, 37,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"external_name", "varchar", 1024, 0, NULL, true, 38,
NULL, NULL ]
@@ -769,7 +769,7 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "information_schema", "routines", "is_null_call",
"varchar", 3, 0, NULL, true, 43, NULL, NULL ]
[ "sys._columns", "information_schema", "routines", "sql_path",
"varchar", 1, 0, NULL, true, 44, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"schema_level_routine", "varchar", 1, 0, NULL, true, 45,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"max_dynamic_result_sets", "int", 32, 0, NULL, true, 46,
NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"max_dynamic_result_sets", "int", 31, 0, NULL, true, 46,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"is_user_defined_cast", "varchar", 1, 0, NULL, true, 47,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"is_implicitly_invocable", "varchar", 1, 0, NULL, true,
48, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"security_type", "varchar", 1, 0, NULL, true, 49,
NULL, NULL ]
@@ -783,38 +783,38 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "information_schema", "routines",
"is_udt_dependent", "varchar", 1, 0, NULL, true, 57,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_from_data_type", "varchar", 1, 0, NULL, true,
58, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_as_locator", "varchar", 1, 0, NULL, true,
59, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_char_max_length", "int", 32, 0, NULL, true, 60,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_char_octet_length", "int", 32, 0, NULL, true,
61, NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_char_max_length", "int", 31, 0, NULL, true, 60,
NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_char_octet_length", "int", 31, 0, NULL, true,
61, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_char_set_catalog", "varchar", 1, 0, NULL, true,
62, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_char_set_schema", "varchar", 1, 0, NULL, true,
63, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_character_set_name", "varchar", 1, 0, NULL,
true, 64, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_collation_catalog", "varchar", 1, 0, NULL,
true, 65, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_collation_schema", "varchar", 1, 0, NULL, true,
66, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_collation_name", "varchar", 1, 0, NULL, true,
67, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_numeric_precision", "int", 32, 0, NULL, true,
68, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_numeric_radix", "int", 32, 0, NULL, true, 69,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_numeric_scale", "int", 32, 0, NULL, true, 70,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_datetime_precision", "int", 32, 0, NULL, true,
71, NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_numeric_precision", "int", 31, 0, NULL, true,
68, NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_numeric_radix", "int", 31, 0, NULL, true, 69,
NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_numeric_scale", "int", 31, 0, NULL, true, 70,
NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_datetime_precision", "int", 31, 0, NULL, true,
71, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_interval_type", "varchar", 1, 0, NULL, true,
72, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_interval_precision", "int", 32, 0, NULL, true,
73, NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_interval_precision", "int", 31, 0, NULL, true,
73, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_type_udt_catalog", "varchar", 1, 0, NULL, true,
74, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_type_udt_schema", "varchar", 1, 0, NULL, true,
75, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_type_udt_name", "varchar", 1, 0, NULL, true,
76, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_scope_catalog", "varchar", 1, 0, NULL, true,
77, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_scope_schema", "varchar", 1, 0, NULL, true,
78, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_scope_name", "varchar", 1, 0, NULL, true,
79, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_max_cardinality", "int", 32, 0, NULL, true, 80,
NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_max_cardinality", "int", 31, 0, NULL, true, 80,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_dtd_identifier", "varchar", 1, 0, NULL, true,
81, NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"declared_data_type", "varchar", 1, 0, NULL, true, 82,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"declared_numeric_precision", "int", 32, 0, NULL, true, 83,
NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"declared_numeric_scale", "int", 32, 0, NULL, true, 84,
NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"declared_numeric_precision", "int", 31, 0, NULL, true, 83,
NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"declared_numeric_scale", "int", 31, 0, NULL, true, 84,
NULL, NULL ]
[ "sys._columns", "information_schema", "routines",
"result_cast_from_declared_data_type", "varchar", 1, 0, NULL,
true, 85, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_declared_numeric_precision", "int", 32, 0, NULL,
true, 86, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"result_cast_declared_numeric_scale", "int", 32, 0, NULL, true,
87, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines", "schema_id",
"int", 32, 0, NULL, true, 88, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines", "function_id",
"int", 32, 0, NULL, true, 89, NULL, NULL ]
-[ "sys._columns", "information_schema", "routines",
"function_type", "int", 32, 0, NULL, true, 90, NULL,
NULL ]
-[ "sys._columns", "information_schema", "routines",
"function_language", "int", 32, 0, NULL, true, 91, NULL,
NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_declared_numeric_precision", "int", 31, 0, NULL,
true, 86, NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"result_cast_declared_numeric_scale", "int", 31, 0, NULL, true,
87, NULL, NULL ]
+[ "sys._columns", "information_schema", "routines", "schema_id",
"int", 13, 0, NULL, true, 88, NULL, NULL ]
+[ "sys._columns", "information_schema", "routines", "function_id",
"int", 13, 0, NULL, true, 89, NULL, NULL ]
+[ "sys._columns", "information_schema", "routines",
"function_type", "int", 3, 0, NULL, true, 90, NULL,
NULL ]
+[ "sys._columns", "information_schema", "routines",
"function_language", "int", 2, 0, NULL, true, 91, NULL,
NULL ]
[ "sys._columns", "information_schema", "routines", "is_system",
"boolean", 1, 0, NULL, true, 92, NULL, NULL ]
[ "sys._columns", "information_schema", "routines", "comments",
"varchar", 65000, 0, NULL, true, 93, NULL, NULL ]
[ "sys._columns", "information_schema", "schemata", "catalog_name",
"varchar", 1, 0, NULL, true, 0, NULL, NULL ]
@@ -824,28 +824,28 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "information_schema", "schemata",
"default_character_set_schema", "varchar", 1, 0, NULL, true,
4, NULL, NULL ]
[ "sys._columns", "information_schema", "schemata",
"default_character_set_name", "varchar", 16, 0, NULL, true,
5, NULL, NULL ]
[ "sys._columns", "information_schema", "schemata", "sql_path",
"varchar", 1, 0, NULL, true, 6, NULL, NULL ]
-[ "sys._columns", "information_schema", "schemata", "schema_id",
"int", 32, 0, NULL, true, 7, NULL, NULL ]
+[ "sys._columns", "information_schema", "schemata", "schema_id",
"int", 13, 0, NULL, true, 7, NULL, NULL ]
[ "sys._columns", "information_schema", "schemata", "is_system",
"boolean", 1, 0, NULL, true, 8, NULL, NULL ]
[ "sys._columns", "information_schema", "schemata", "comments",
"varchar", 65000, 0, NULL, true, 9, NULL, NULL ]
[ "sys._columns", "information_schema", "sequences",
"sequence_catalog", "varchar", 1, 0, NULL, true, 0,
NULL, NULL ]
[ "sys._columns", "information_schema", "sequences",
"sequence_schema", "varchar", 1024, 0, NULL, true, 1,
NULL, NULL ]
[ "sys._columns", "information_schema", "sequences",
"sequence_name", "varchar", 256, 0, NULL, true, 2,
NULL, NULL ]
[ "sys._columns", "information_schema", "sequences", "data_type",
"varchar", 16, 0, NULL, true, 3, NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences",
"numeric_precision", "smallint", 16, 0, NULL, true, 4,
NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences",
"numeric_precision_radix", "smallint", 16, 0, NULL, true,
5, NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences",
"numeric_scale", "smallint", 16, 0, NULL, true, 6,
NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences", "start_value",
"bigint", 64, 0, NULL, true, 7, NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences",
"minimum_value", "bigint", 64, 0, NULL, true, 8,
NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences",
"maximum_value", "bigint", 64, 0, NULL, true, 9,
NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences", "increment",
"bigint", 64, 0, NULL, true, 10, NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences",
"numeric_precision", "smallint", 15, 0, NULL, true, 4,
NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences",
"numeric_precision_radix", "smallint", 15, 0, NULL, true,
5, NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences",
"numeric_scale", "smallint", 15, 0, NULL, true, 6,
NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences", "start_value",
"bigint", 63, 0, NULL, true, 7, NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences",
"minimum_value", "bigint", 63, 0, NULL, true, 8,
NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences",
"maximum_value", "bigint", 63, 0, NULL, true, 9,
NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences", "increment",
"bigint", 63, 0, NULL, true, 10, NULL, NULL ]
[ "sys._columns", "information_schema", "sequences", "cycle_option",
"varchar", 3, 0, NULL, true, 11, NULL, NULL ]
[ "sys._columns", "information_schema", "sequences",
"declared_data_type", "varchar", 16, 0, NULL, true, 12,
NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences",
"declared_numeric_precision", "smallint", 16, 0, NULL, true,
13, NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences",
"declared_numeric_scale", "smallint", 16, 0, NULL, true,
14, NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences", "schema_id",
"int", 32, 0, NULL, true, 15, NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences", "sequence_id",
"int", 32, 0, NULL, true, 16, NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences",
"current_value", "bigint", 64, 0, NULL, true, 17,
NULL, NULL ]
-[ "sys._columns", "information_schema", "sequences", "cacheinc",
"bigint", 64, 0, NULL, true, 18, NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences",
"declared_numeric_precision", "smallint", 15, 0, NULL, true,
13, NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences",
"declared_numeric_scale", "smallint", 15, 0, NULL, true,
14, NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences", "schema_id",
"int", 31, 0, NULL, true, 15, NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences", "sequence_id",
"int", 31, 0, NULL, true, 16, NULL, NULL ]
+[ "sys._columns", "information_schema", "sequences",
"current_value", "bigint", 63, 0, NULL, true, 17,
NULL, NULL ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
