Changeset: 49dbf02635d3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/49dbf02635d3 Modified Files: sql/test/emptydb/Tests/check.stable.out Branch: cleanup_types Log Message:
Approve non-hugeint output. diffs (truncated from 641 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 @@ -1177,7 +1177,7 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "describe_functions", "o", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "describe_functions", "sch", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "describe_functions", "fun", "varchar", 256, 0, NULL, true, 2, NULL, NULL ] -[ "sys._columns", "sys", "describe_functions", "def", "clob", 0, 0, NULL, true, 3, NULL, NULL ] +[ "sys._columns", "sys", "describe_functions", "def", "varchar", 0, 0, NULL, true, 3, NULL, NULL ] [ "sys._columns", "sys", "describe_indices", "ind", "varchar", 1024, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "describe_indices", "sch", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "describe_indices", "tbl", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] @@ -1192,7 +1192,7 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "describe_partition_tables", "minimum", "varchar", 0, 0, NULL, true, 6, NULL, NULL ] [ "sys._columns", "sys", "describe_partition_tables", "maximum", "varchar", 0, 0, NULL, true, 7, NULL, NULL ] [ "sys._columns", "sys", "describe_partition_tables", "with_nulls", "boolean", 1, 0, NULL, true, 8, NULL, NULL ] -[ "sys._columns", "sys", "describe_privileges", "o_nme", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "describe_privileges", "o_nme", "char", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "describe_privileges", "o_tpe", "char", 30, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "describe_privileges", "p_nme", "varchar", 40, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "describe_privileges", "a_nme", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] @@ -1215,7 +1215,7 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "describe_tables", "sch", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "describe_tables", "tab", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "describe_tables", "typ", "varchar", 25, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "describe_tables", "col", "clob", 0, 0, NULL, true, 4, NULL, NULL ] +[ "sys._columns", "sys", "describe_tables", "col", "varchar", 0, 0, NULL, true, 4, NULL, NULL ] [ "sys._columns", "sys", "describe_tables", "opt", "clob", 0, 0, NULL, true, 5, NULL, NULL ] [ "sys._columns", "sys", "describe_triggers", "sch", "varchar", 1024, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "describe_triggers", "tab", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] @@ -1224,32 +1224,32 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "describe_user_defined_types", "sch", "varchar", 1024, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "describe_user_defined_types", "sql_tpe", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "describe_user_defined_types", "ext_tpe", "varchar", 256, 0, NULL, true, 2, NULL, NULL ] -[ "sys._columns", "sys", "dump_add_schemas_to_users", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_add_schemas_to_users", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_add_schemas_to_users", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_add_schemas_to_users", "user_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] -[ "sys._columns", "sys", "dump_column_defaults", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_column_defaults", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_column_defaults", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_column_defaults", "table_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_column_defaults", "column_name", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "dump_column_grants", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_column_grants", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_column_grants", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_column_grants", "table_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_column_grants", "column_name", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] [ "sys._columns", "sys", "dump_column_grants", "grantee", "varchar", 1024, 0, NULL, true, 4, NULL, NULL ] -[ "sys._columns", "sys", "dump_comments", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] -[ "sys._columns", "sys", "dump_create_roles", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_comments", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_create_roles", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_create_roles", "user_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] -[ "sys._columns", "sys", "dump_create_schemas", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_create_schemas", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_create_schemas", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] -[ "sys._columns", "sys", "dump_create_users", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_create_users", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_create_users", "user_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] -[ "sys._columns", "sys", "dump_foreign_keys", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_foreign_keys", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_foreign_keys", "foreign_schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_foreign_keys", "foreign_table_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_foreign_keys", "primary_schema_name", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] [ "sys._columns", "sys", "dump_foreign_keys", "primary_table_name", "varchar", 1024, 0, NULL, true, 4, NULL, NULL ] [ "sys._columns", "sys", "dump_foreign_keys", "key_name", "varchar", 1024, 0, NULL, true, 5, NULL, NULL ] -[ "sys._columns", "sys", "dump_function_grants", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_function_grants", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_function_grants", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_function_grants", "function_name", "varchar", 256, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_function_grants", "grantee", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] @@ -1257,31 +1257,31 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "dump_functions", "stmt", "clob", 0, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_functions", "schema_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_functions", "function_name", "varchar", 256, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "dump_grant_user_privileges", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_grant_user_privileges", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_grant_user_privileges", "grantee", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_grant_user_privileges", "grantor", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] -[ "sys._columns", "sys", "dump_indices", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_indices", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_indices", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_indices", "table_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_indices", "index_name", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "dump_partition_tables", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_partition_tables", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_partition_tables", "merge_schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_partition_tables", "merge_table_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_partition_tables", "partition_schema_name", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] [ "sys._columns", "sys", "dump_partition_tables", "partition_table_name", "varchar", 1024, 0, NULL, true, 4, NULL, NULL ] -[ "sys._columns", "sys", "dump_sequences", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_sequences", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_sequences", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_sequences", "seqname", "varchar", 256, 0, NULL, true, 2, NULL, NULL ] -[ "sys._columns", "sys", "dump_start_sequences", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_start_sequences", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_start_sequences", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_start_sequences", "sequence_name", "varchar", 256, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_statements", "o", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_statements", "s", "clob", 0, 0, NULL, true, 1, NULL, NULL ] -[ "sys._columns", "sys", "dump_table_constraint_type", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_table_constraint_type", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_table_constraint_type", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_table_constraint_type", "table_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_table_constraint_type", "constraint_name", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "dump_table_grants", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_table_grants", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_table_grants", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_table_grants", "table_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_table_grants", "grantee", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] @@ -1293,7 +1293,7 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "dump_triggers", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_triggers", "table_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dump_triggers", "trigger_name", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "dump_user_defined_types", "stmt", "clob", 0, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "dump_user_defined_types", "stmt", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "dump_user_defined_types", "schema_name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dump_user_defined_types", "type_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "environment", "name", "varchar", 1024, 0, NULL, true, 0, NULL, NULL ] @@ -1311,7 +1311,7 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "fkeys", "delete_action", "varchar", 15, 0, NULL, true, 8, NULL, NULL ] [ "sys._columns", "sys", "fully_qualified_functions", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "fully_qualified_functions", "tpe", "varchar", 30, 0, NULL, true, 1, NULL, NULL ] -[ "sys._columns", "sys", "fully_qualified_functions", "nme", "clob", 0, 0, NULL, true, 2, NULL, NULL ] +[ "sys._columns", "sys", "fully_qualified_functions", "nme", "varchar", 0, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "function_languages", "language_id", "smallint", 15, 0, NULL, false, 0, NULL, NULL ] [ "sys._columns", "sys", "function_languages", "language_name", "varchar", 20, 0, NULL, false, 1, NULL, NULL ] [ "sys._columns", "sys", "function_languages", "language_keyword", "varchar", 20, 0, NULL, true, 2, NULL, NULL ] @@ -1410,7 +1410,21 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "prepared_statements_args", "column", "clob", 0, 0, NULL, true, 8, NULL, NULL ] [ "sys._columns", "sys", "privilege_codes", "privilege_code_id", "int", 31, 0, NULL, false, 0, NULL, NULL ] [ "sys._columns", "sys", "privilege_codes", "privilege_code_name", "varchar", 40, 0, NULL, false, 1, NULL, NULL ] -63 +[ "sys._columns", "sys", "privileges", "obj_id", "int", 31, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "privileges", "auth_id", "int", 31, 0, NULL, true, 1, NULL, NULL ] +[ "sys._columns", "sys", "privileges", "privileges", "int", 31, 0, NULL, true, 2, NULL, NULL ] +[ "sys._columns", "sys", "privileges", "grantor", "int", 31, 0, NULL, true, 3, NULL, NULL ] +[ "sys._columns", "sys", "privileges", "grantable", "int", 31, 0, NULL, true, 4, NULL, NULL ] +[ "sys._columns", "sys", "querylog_calls", "id", "oid", 63, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "querylog_calls", "start", "timestamp", 7, 0, NULL, true, 1, NULL, NULL ] +[ "sys._columns", "sys", "querylog_calls", "stop", "timestamp", 7, 0, NULL, true, 2, NULL, NULL ] +[ "sys._columns", "sys", "querylog_calls", "arguments", "clob", 0, 0, NULL, true, 3, NULL, NULL ] +[ "sys._columns", "sys", "querylog_calls", "tuples", "bigint", 63, 0, NULL, true, 4, NULL, NULL ] +[ "sys._columns", "sys", "querylog_calls", "run", "bigint", 63, 0, NULL, true, 5, NULL, NULL ] +[ "sys._columns", "sys", "querylog_calls", "ship", "bigint", 63, 0, NULL, true, 6, NULL, NULL ] +[ "sys._columns", "sys", "querylog_calls", "cpu", "int", 31, 0, NULL, true, 7, NULL, NULL ] +[ "sys._columns", "sys", "querylog_calls", "io", "int", 31, 0, NULL, true, 8, NULL, NULL ] +[ "sys._columns", "sys", "querylog_catalog", "id", "oid", 63, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "querylog_catalog", "owner", "clob", 0, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "querylog_catalog", "defined", "timestamp", 7, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "querylog_catalog", "query", "clob", 0, 0, NULL, true, 3, NULL, NULL ] @@ -1607,7 +1621,7 @@ 63 [ "sys._columns", "sys", "user_role", "role_id", "int", 31, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "users", "name", "varchar", 1024, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "users", "fullname", "varchar", 2048, 0, NULL, true, 1, NULL, NULL ] -[ "sys._columns", "sys", "users", "default_schema", "int", 9, 0, NULL, true, 2, NULL, NULL ] +[ "sys._columns", "sys", "users", "default_schema", "int", 31, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "users", "schema_path", "clob", 0, 0, NULL, true, 3, NULL, NULL ] [ "sys._columns", "sys", "users", "max_memory", "bigint", 63, 0, NULL, true, 4, NULL, NULL ] [ "sys._columns", "sys", "users", "max_workers", "int", 31, 0, NULL, true, 5, NULL, NULL ] @@ -1672,13 +1686,13 @@ 63 % %1, name, expression, value # name % char, varchar, varchar, varchar # type % 20, 0, 0, 0 # length -% .%10, .x, .x, .x # table_name -% %10, sname, name, modfunc # name -% char, varchar, varchar, clob # type +% .%12, .x, .x, .x # table_name +% %12, sname, name, modfunc # name +% char, varchar, varchar, char # type % 27, 0, 0, 0 # length % .%1, .s, .f, ., ., .f, .fl, ., .f, .f, .f, .f, ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., . # table_name % %1, name, name, system, query, mod, language_name, func_type, side_effect, varres, vararg, semantics, comment, name0, type0, type_digits0, type_scale0, inout0, name1, type1, type_digits1, type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2, name3, type3, type_digits3, type_scale3, inout3, name4, type4, type_digits4, type_scale4, inout4, name5, type5, type_digits5, type_scale5, inout5, name6, type6, type_digits6, type_scale6, inout6, name7, type7, type_digits7, type_scale7, inout7, name8, type8, type_digits8, type_scale8, inout8, name9, type9, type_digits9, type_scale9, inout9, name10, type10, type_digits10, type_scale10, inout10, name11, type11, type_digits11, type_scale11, inout11, name12, type12, type_digits12, type_scale12, inout12, name13, type13, type_digits13, type_scale13, inout13, name14, type14, type_digits14, type_scale14, inout14, name15, type15, type_digits15, type_scale15, inout15 # name -% char, varchar, varchar, char, clob, varchar, varchar, varchar, boolean, boolean, boolean, boolean, varchar, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char # type +% char, varchar, varchar, char, char, varchar, varchar, varchar, boolean, boolean, boolean, boolean, varchar, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char # type % 13, 8, 37, 6, 3806, 9, 10, 26, 5, 5, 5, 5, 0, 11, 14, 4, 1, 3, 16, 14, 4, 1, 3, 16, 14, 4, 1, 3, 27, 12, 4, 1, 3, 9, 9, 4, 1, 3, 14, 7, 4, 1, 3, 12, 9, 2, 1, 3, 11, 7, 2, 1, 3, 11, 7, 2, 1, 3, 10, 6, 2, 1, 3, 9, 6, 2, 1, 3, 6, 7, 1, 1, 3, 9, 7, 2, 1, 3, 6, 7, 4, 1, 3, 9, 7, 4, 1, 3, 6, 7, 4, 1, 3 # length [ "sys.functions", "json", "filter", "SYSTEM", "create function json.filter(js json, name bigint) returns json external name json.filter;", "json", "MAL", "Scalar function", false, false, false, true, NULL, "result", "json", 0, 0, "out", "js", "json", 0, 0, "in", "name", "bigint", 63, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "json", "filter", "SYSTEM", "create function json.filter(js json, name integer) returns json external name json.filter;", "json", "MAL", "Scalar function", false, false, false, true, NULL, "result", "json", 0, 0, "out", "js", "json", 0, 0, "in", "name", "int", 31, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -5133,8 +5147,8 @@ 63 % %1, name, name, start, minvalue, maxvalue, increment, cacheinc, cycle, comment # name % char, varchar, varchar, bigint, bigint, bigint, bigint, bigint, boolean, varchar # type % 13, 0, 0, 1, 1, 1, 1, 1, 5, 0 # length -% .%20 # table_name -% %20 # name +% .%17 # table_name +% %17 # name % bigint # type % 1 # length [ 0 ] @@ -5613,8 +5627,8 @@ 63 % %2, %1, id # name % char, bigint, int # type % 21, 1, 1 # length -% .%12, sys.%10, sys.tables # table_name -% %12, %10, id # name +% .%11, sys.%7, sys.tables # table_name +% %11, %7, id # name % char, bigint, int # type % 20, 1, 1 # length % .%2, sys.%1, sys._columns # table_name @@ -5705,8 +5719,8 @@ 63 % %2, %1, name # name % char, bigint, varchar # type % 26, 1, 0 # length -% .%24, .%20, .statistics # table_name -% %24, %20, column_id # name +% .%23, .%17, .statistics # table_name +% %23, %17, column_id # name % char, bigint, int # type % 24, 1, 1 # length % .%3, .%2, .%1, .%1, .%1 # table_name @@ -5753,8 +5767,8 @@ 63 % %2, %1, id # name % char, bigint, int # type % 22, 1, 1 # length -% .%176, .%170, .ids # table_name -% %176, %170, id # name +% .%175, .%167, .ids # table_name +% %175, %167, id # name % char, bigint, int # type % 17, 1, 1 # length % .%105, .%104, .var_values # table_name @@ -5797,8 +5811,8 @@ 63 % %2, %1, schema_id, name # name % char, bigint, int, varchar # type % 21, 1, 1, 0 # length -% .%12, sys.%10, sys.tables, sys.tables # table_name -% %12, %10, schema_id, name # name +% .%11, sys.%7, sys.tables, sys.tables # table_name +% %11, %7, schema_id, name # name % char, bigint, int, varchar # type % 20, 1, 1, 0 # length % .%2, sys.%1, sys._columns, sys._columns # table_name @@ -5821,8 +5835,8 @@ 63 % %21, %20, id # name % char, bigint, int # type % 161, 1, 1 # length -% .%37, .%34, .t # table_name -% %37, %34, id # name +% .%36, .%33, .t # table_name +% %36, %33, id # name % char, bigint, int # type % 159, 1, 1 # length % .%2, sys.%1, sys.f, sys.f, sys.f, sys.f, sys.f, sys.f, sys.f, sys.f, sys.f, sys.a # table_name @@ -5929,24 +5943,24 @@ 63 % %5, schema_id, id, name, schema_id, query, type, system, commit_action, access # name % char, int, int, varchar, int, varchar, smallint, boolean, smallint, smallint # type % 38, 1, 1, 0, 1, 0, 1, 5, 1, 1 # length -% .%14, sys.tables, sys.tables, sys.tables, sys.tables, sys.tables, .tables, sys.tables, sys.tables, sys.tables, .tables # table_name -% %14, schema_id, id, name, schema_id, query, type, system, commit_action, access, temporary # name +% .%13, sys.tables, sys.tables, sys.tables, sys.tables, sys.tables, .tables, sys.tables, sys.tables, sys.tables, .tables # table_name +% %13, schema_id, id, name, schema_id, query, type, system, commit_action, access, temporary # name % char, int, int, varchar, int, varchar, smallint, boolean, smallint, smallint, tinyint # type % 37, 1, 1, 0, 1, 0, 1, 5, 1, 1, 1 # length % .%5, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables # table_name % %5, type, id, name, schema_id, query, type, system, commit_action, access # name % char, smallint, int, varchar, int, varchar, smallint, boolean, smallint, smallint # type % 33, 1, 1, 0, 1, 0, 1, 5, 1, 1 # length -% .%14, .tables, sys.tables, sys.tables, sys.tables, sys.tables, .tables, sys.tables, sys.tables, sys.tables, .tables # table_name -% %14, type, id, name, schema_id, query, type, system, commit_action, access, temporary # name +% .%13, .tables, sys.tables, sys.tables, sys.tables, sys.tables, .tables, sys.tables, sys.tables, sys.tables, .tables # table_name +% %13, type, id, name, schema_id, query, type, system, commit_action, access, temporary # name % char, smallint, int, varchar, int, varchar, smallint, boolean, smallint, smallint, tinyint # type % 32, 1, 1, 0, 1, 0, 1, 5, 1, 1, 1 # length % .%5, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns # table_name % %5, table_id, id, name, type, type_digits, type_scale, table_id, default, null, number, storage # name % char, int, int, varchar, varchar, int, int, int, varchar, boolean, int, varchar # type % 38, 1, 1, 0, 0, 1, 1, 1, 0, 5, 1, 0 # length -% .%21, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns # table_name -% %21, table_id, id, name, type, type_digits, type_scale, table_id, default, null, number, storage # name +% .%20, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns, sys.columns # table_name +% %20, table_id, id, name, type, type_digits, type_scale, table_id, default, null, number, storage # name % char, int, int, varchar, varchar, int, int, int, varchar, boolean, int, varchar # type % 37, 1, 1, 0, 0, 1, 1, 1, 0, 5, 1, 0 # length % .%5, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns # table_name @@ -5985,12 +5999,12 @@ 63 % %5, schema_id, id, systemname, sqlname, digits, scale, radix, eclass, schema_id # name % char, int, int, varchar, varchar, int, int, int, int, int # type % 36, 1, 1, 0, 0, 1, 1, 1, 1, 1 # length -% .%201, sys.objects, sys.objects, sys.objects, sys.objects, sys.objects # table_name -% %201, id, id, name, nr, sub # name +% .%200, sys.objects, sys.objects, sys.objects, sys.objects, sys.objects # table_name +% %200, id, id, name, nr, sub # name % char, int, int, varchar, int, int # type % 31, 1, 1, 0, 1, 1 # length -% .%240, .ids, .ids, .ids, .ids, .ids, .ids, .ids, .ids, .ids # table_name -% %240, id, id, name, schema_id, table_id, table_name, obj_type, sys_table, system # name +% .%237, .ids, .ids, .ids, .ids, .ids, .ids, .ids, .ids, .ids # table_name +% %237, id, id, name, schema_id, table_id, table_name, obj_type, sys_table, system # name % char, int, int, varchar, int, int, varchar, char, char, boolean # type % 27, 1, 1, 0, 1, 1, 0, 44, 13, 5 # length % .%5, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys # table_name @@ -6001,8 +6015,8 @@ 63 % %5, table_id, id, table_id, type, name, rkey, action # name % char, int, int, int, int, varchar, int, int # type % 34, 1, 1, 1, 1, 0, 1, 1 # length -% .%14, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys # table_name -% %14, table_id, id, table_id, type, name, rkey, action # name +% .%13, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys # table_name _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
