Changeset: 698f7819c246 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/698f7819c246
Modified Files:
sql/storage/store.c
sql/test/BugTracker-2019/Tests/outer-join-varchar.Bug-6776.test
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/miscellaneous/Tests/view-mul-digits.test
Branch: cleanup_types
Log Message:
always set digits for views on max bits.
diffs (truncated from 3807 to 300 lines):
diff --git a/sql/storage/store.c b/sql/storage/store.c
--- a/sql/storage/store.c
+++ b/sql/storage/store.c
@@ -3591,6 +3591,29 @@ sql_trans_copy_trigger( sql_trans *tr, s
return res;
}
+static int
+type_digits(sql_subtype *type)
+{
+ int digits = type->digits;
+
+ if (digits && type->type->eclass == EC_NUM) {
+ if(type->type->localtype == TYPE_bte) {
+ digits = 7;
+ } else if(type->type->localtype == TYPE_sht) {
+ digits = 15;
+ } else if(type->type->localtype == TYPE_int) {
+ digits = 31;
+ } else if(type->type->localtype == TYPE_lng) {
+ digits = 63;
+#if HAVE_HGE
+ } else if(type->type->localtype == TYPE_hge) {
+ digits = 127;
+#endif
+ }
+ }
+ return digits;
+}
+
int
sql_trans_copy_column( sql_trans *tr, sql_table *t, sql_column *c, sql_column
**cres)
{
@@ -3636,8 +3659,9 @@ sql_trans_copy_column( sql_trans *tr, sq
if (!isDeclaredTable(t)) {
char *strnil = (char*)ATOMnilptr(TYPE_str);
+ int digits = type_digits(&col->type);
if ((res = store->table_api.table_insert(tr, syscolumn,
&col->base.id, &col->base.name, &col->type.type->base.name,
- &col->type.digits, &col->type.scale,
&t->base.id,
+ &digits, &col->type.scale, &t->base.id,
(col->def) ? &col->def : &strnil,
&col->null, &col->colnr,
(col->storage_type) ?
&col->storage_type : &strnil))) {
ATOMIC_PTR_DESTROY(&col->data);
@@ -6079,7 +6103,8 @@ sql_trans_create_column(sql_column **rco
}
if (!isDeclaredTable(t)) {
char *strnil = (char*)ATOMnilptr(TYPE_str);
- if ((res = store->table_api.table_insert(tr, syscolumn,
&col->base.id, &col->base.name, &col->type.type->base.name, &col->type.digits,
&col->type.scale,
+ int digits = type_digits(&col->type);
+ if ((res = store->table_api.table_insert(tr, syscolumn,
&col->base.id, &col->base.name, &col->type.type->base.name, &digits,
&col->type.scale,
&t->base.id, (col->def) ? &col->def : &strnil, &col->null, &col->colnr,
(col->storage_type) ? &col->storage_type : &strnil))) {
ATOMIC_PTR_DESTROY(&col->data);
return res;
diff --git a/sql/test/BugTracker-2019/Tests/outer-join-varchar.Bug-6776.test
b/sql/test/BugTracker-2019/Tests/outer-join-varchar.Bug-6776.test
--- a/sql/test/BugTracker-2019/Tests/outer-join-varchar.Bug-6776.test
+++ b/sql/test/BugTracker-2019/Tests/outer-join-varchar.Bug-6776.test
@@ -27,11 +27,11 @@ 32
dummy6
val4
int
-2
+31
dummy6
val5
int
-3
+31
statement ok
create table dummy7 as select "key", val as "val4", val as "val5" from dummy4
natural full outer join dummy5
@@ -47,11 +47,11 @@ 32
dummy7
val4
int
-3
+31
dummy7
val5
int
-3
+31
statement ok
create table dummy8 as select dummy4."key" as "key4", dummy5."key" as "key5",
dummy4.val as "val4", dummy5.val as "val5" from dummy4 full outer join dummy5
ON dummy4."key" = dummy5."key"
@@ -71,11 +71,11 @@ 32
dummy8
val4
int
-2
+31
dummy8
val5
int
-3
+31
statement ok
rollback
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", 31, 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", 31, 0, NULL, true, 50, NULL, NULL ]
+[ "sys._columns", "information_schema", "columns", "table_id",
"int", 31, 0, NULL, true, 51, NULL, NULL ]
+[ "sys._columns", "information_schema", "columns", "column_id",
"int", 31, 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", 31, 0, NULL, true, 41, NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters", "function_id",
"int", 31, 0, NULL, true, 42, NULL, NULL ]
+[ "sys._columns", "information_schema", "parameters", "arg_id",
"int", 31, 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", 31, 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", 31, 0, NULL, true, 9, NULL, NULL
]
+[ "sys._columns", "information_schema", "referential_constraints",
"fk_table_id", "int", 31, 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", 31, 0, NULL, true, 12, NULL, NULL
]
+[ "sys._columns", "information_schema", "referential_constraints",
"uc_schema_id", "int", 31, 0, NULL, true, 13, NULL, NULL
]
+[ "sys._columns", "information_schema", "referential_constraints",
"uc_table_id", "int", 31, 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", 31, 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 ]
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
