Changeset: 8e2d926b65bf for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8e2d926b65bf Branch: ascii-flag Log Message:
Merge with default branch. diffs (truncated from 3634 to 300 lines): diff --git a/monetdb5/modules/mal/clients.c b/monetdb5/modules/mal/clients.c --- a/monetdb5/modules/mal/clients.c +++ b/monetdb5/modules/mal/clients.c @@ -479,9 +479,11 @@ CLTqueryTimeout(Client cntxt, MalBlkPtr lng timeout_micro = ATOMIC_GET(&GDKdebug) & FORCEMITOMASK && qto == 1 ? 1000 : (lng) qto * 1000000; mal_clients[idx].querytimeout = timeout_micro; - QryCtx *qry_ctx = MT_thread_get_qry_ctx(); - if (qry_ctx) { - qry_ctx->endtime = qry_ctx->starttime && timeout_micro ? qry_ctx->starttime + timeout_micro : 0; + if (timeout_micro != 1000) { + QryCtx *qry_ctx = MT_thread_get_qry_ctx(); + if (qry_ctx) { + qry_ctx->endtime = qry_ctx->starttime && timeout_micro ? qry_ctx->starttime + timeout_micro : 0; + } } } MT_lock_unset(&mal_contextLock); diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit b/sql/test/emptydb/Tests/check.stable.out.32bit --- a/sql/test/emptydb/Tests/check.stable.out.32bit +++ b/sql/test/emptydb/Tests/check.stable.out.32bit @@ -39,7 +39,7 @@ select 'sys.objects', o.name, case when -- schemas select 'default schema of user', s.name, u.name from sys.schemas s, sys.users u where s.id = u.default_schema order by s.name, u.name; -- tables -select 'grant on table', t.name, a.name, pc.privilege_code_name, g.name, p.grantable from sys._tables t, sys.privileges p left outer join sys.auths g on p.grantor = g.id left outer join sys.privilege_codes pc on p.privileges = pc.privilege_code_id, sys.auths a where t.id = p.obj_id and p.auth_id = a.id order by t.name, a.name; +select 'grant on table', t.name, a.name, pc.privilege_code_name, g.name, p.grantable from sys._tables t, sys.privileges p left outer join sys.auths g on p.grantor = g.id left outer join sys.privilege_codes pc on p.privileges = pc.privilege_code_id, sys.auths a where t.id = p.obj_id and p.auth_id = a.id order by t.name, a.name, g.name nulls first; -- columns select 'grant on column', t.name, c.name, a.name, pc.privilege_code_name, g.name, p.grantable from sys._tables t, sys._columns c, sys.privileges p left outer join sys.auths g on p.grantor = g.id left outer join sys.privilege_codes pc on p.privileges = pc.privilege_code_id, sys.auths a where c.id = p.obj_id and c.table_id = t.id and p.auth_id = a.id order by t.name, c.name, a.name; -- functions @@ -433,7 +433,7 @@ select 'null in fkeys.delete_action_id', select 'null in fkeys.delete_action', delete_action, * from sys.fkeys where delete_action is null; % .%1, .s, ., ., .s, . # table_name % %1, name, authorization, owner, system, comment # name -% char, varchar, varchar, varchar, boolean, varchar # type +% varchar, varchar, varchar, varchar, boolean, varchar # type % 11, 18, 8, 7, 5, 28 # length [ "sys.schemas", "information_schema", "monetdb", "monetdb", true, "ISO/IEC 9075-11 SQL/Schemata" ] [ "sys.schemas", "json", "monetdb", "monetdb", true, NULL ] @@ -443,8 +443,8 @@ 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, char, varchar, boolean, char, char, varchar # type -% 11, 18, 34, 6812, 5, 5, 8, 10, 0 # length +% varchar, varchar, varchar, varchar, varchar, boolean, varchar, varchar, varchar # type +% 11, 18, 34, 6812, 5, 5, 8, 8, 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 ] [ "sys._tables", "information_schema", "columns", "create view information_schema.columns as select cast(null as varchar(1)) as table_catalog, s.\"name\" as table_schema, t.\"name\" as table_name, c.\"name\" as column_name, cast(1 + c.\"number\" as int) as ordinal_position, c.\"default\" as column_default, cast(sys.ifthenelse(c.\"null\", 'YES', 'NO') as varchar(3)) as is_nullable, cast(sys.\"sql_datatype\"(c.\"type\", c.\"type_digits\", c.\"type_scale\", true, true) as varchar(1024)) as data_type, cast(sys.ifthenelse(c.\"type\" in ('varchar','clob','char','json','url','xml') and c.\"type_digits\" > 0, c.\"type_digits\", null) as int) as character_maximum_length, cast(sys.ifthenelse(c.\"type\" in ('varchar','clob','char','json','url','xml') and c.\"type_digits\" > 0, 4 * cast(c.\"type_digits\" as bigint), null) as bigint) as character_octet_length, cast(sys.ifthenelse(c.\"type\" in ('int','smallint','tinyint','bigint','hugeint','float','real','double','decimal','numeric','oid'), c.\" type_digits\", null) as int) as numeric_precision, cast(sys.ifthenelse(c.\"type\" in ('int','smallint','tinyint','bigint','hugeint','float','real','double','oid'), 2, sys.ifthenelse(c.\"type\" in ('decimal','numeric'), 10, null)) as int) as numeric_precision_radix, cast(sys.ifthenelse(c.\"type\" in ('int','smallint','tinyint','bigint','hugeint','float','real','double','decimal','numeric','oid'), c.\"type_scale\", null) as int) as numeric_scale, cast(sys.ifthenelse(c.\"type\" in ('date','timestamp','timestamptz','time','timetz'), sys.ifthenelse(c.\"type_scale\" > 0, c.\"type_scale\" -1, 0), null) as int) as datetime_precision, cast(sys.ifthenelse(c.\"type\" in ('day_interval','month_interval','sec_interval'), sys.\"sql_datatype\"(c.\"type\", c.\"type_digits\", c.\"type_scale\", true, true), null) as varchar(40)) as interval_type, cast(case c.\"type\" when 'day_interval' then 0 when 'month_interval' then 0 when 'sec_interval' then (sys.ifthenelse(c.\"type_digits\" in (7, 10, 12, 13), sys.ifthenelse(c.\"type_scale\" > 0, c.\"type_scale\", 3), 0)) else null end as int) as interval_precision, cast(null as varchar(1)) as character_set_catalog, cast(null as varchar(1)) as character_set_schema, cast(sys.ifthenelse(c.\"type\" in ('varchar','clob','char','json','url','xml'), 'UTF-8', null) as varchar(16)) as character_set_name, cast(null as varchar(1)) as collation_catalog, cast(null as varchar(1)) as collation_schema, cast(null as varchar(1)) as collation_name, cast(null as varchar(1)) as domain_catalog, cast(null as varchar(1)) as domain_schema, cast(null as varchar(1)) as domain_name, cast(null as varchar(1)) as udt_catalog, cast(null as varchar(1)) as udt_schema, cast(null as varchar(1)) as udt_name, cast(null as varchar(1)) as scope_catalog, cast(null as varchar(1)) as scope_schema, cast(null as varchar(1)) as scope_name, cast(null as int) as maximum_cardinality, cast(null as varchar(1)) as dtd_identifier, cast('NO' as varchar(3)) as is_self_referencing, cast(sys.i fthenelse(seq.\"name\" is null or c.\"null\", 'NO', 'YES') as varchar(3)) as is_identity, seq.\"name\" as identity_generation, seq.\"start\" as identity_start, seq.\"increment\" as identity_increment, seq.\"maxvalue\" as identity_maximum, seq.\"minvalue\" as identity_minimum, cast(sys.ifthenelse(seq.\"name\" is null, null, sys.ifthenelse(seq.\"cycle\", 'YES', 'NO')) as varchar(3)) as identity_cycle, cast(sys.ifthenelse(seq.\"name\" is null, 'NO', 'YES') as varchar(3)) as is_generated, cast(sys.ifthenelse(seq.\"name\" is null, null, c.\"default\") as varchar(1024)) as generation_expression, cast('NO' as varchar(3)) as is_system_time_period_start, cast('NO' as varchar(3)) as is_system_time_period_end, cast('NO' as varchar(3)) as system_time_period_timestamp_generation, cast(sys.ifthenelse(t.\"type\" in (0,3,7,20,30), 'YES', 'NO') as varchar(3)) as is_updatable, cast(null as varchar(1)) as declared_data_type, cast(null as int) as declared_numeric_precision, cast(null as int) as declare d_numeric_scale, t.\"schema_id\" as schema_id, c.\"table_id\" as table_id, c.\"id\" as column_id, seq.\"id\" as sequence_id, t.\"system\" as is_system, cm.\"remark\" as comments from sys.\"columns\" c inner join sys.\"tables\" t on c.\"table_id\" = t.\"id\" inner join sys.\"schemas\" s on t.\"schema_id\" = s.\"id\" left outer join sys.\"comments\" cm on c.\"id\" = cm.\"id\" left outer join sys.\"sequences\" seq on ((seq.\"name\"||'\"') = substring(c.\"default\", 3 + sys.\"locate\"('\".\"seq_',c.\"default\",14))) order by s.\"name\", t.\"name\", c.\"number\";", "VIEW", true, "COMMIT", "WRITABLE", NULL ] @@ -589,7 +589,7 @@ select 'null in fkeys.delete_action', de [ "sys._tables", "tmp", "triggers", NULL, "TABLE", true, "PRESERVE", "WRITABLE", NULL ] % .%1, .s, .t, .c, .c, .c, .c, .c, .c, .c, .c, . # table_name % %1, name, name, name, type, type_digits, type_scale, default, null, number, storage, comment # name -% char, varchar, varchar, varchar, varchar, int, int, varchar, boolean, int, varchar, varchar # type +% varchar, varchar, varchar, varchar, varchar, int, int, varchar, boolean, int, varchar, varchar # type % 12, 18, 34, 39, 9, 7, 1, 5, 5, 2, 0, 0 # length [ "sys._columns", "information_schema", "character_sets", "character_set_catalog", "varchar", 1, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "information_schema", "character_sets", "character_set_schema", "varchar", 1, 0, NULL, true, 1, NULL, NULL ] @@ -741,7 +741,7 @@ select 'null in fkeys.delete_action', de [ "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", "character_set_name", "varchar", 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 ] @@ -763,8 +763,8 @@ select 'null in fkeys.delete_action', de [ "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 ] [ "sys._columns", "information_schema", "routines", "external_language", "varchar", 20, 0, NULL, true, 39, NULL, NULL ] -[ "sys._columns", "information_schema", "routines", "parameter_style", "char", 7, 0, NULL, true, 40, NULL, NULL ] -[ "sys._columns", "information_schema", "routines", "is_deterministic", "char", 3, 0, NULL, true, 41, NULL, NULL ] +[ "sys._columns", "information_schema", "routines", "parameter_style", "varchar", 7, 0, NULL, true, 40, NULL, NULL ] +[ "sys._columns", "information_schema", "routines", "is_deterministic", "varchar", 3, 0, NULL, true, 41, NULL, NULL ] [ "sys._columns", "information_schema", "routines", "sql_data_access", "varchar", 10, 0, NULL, true, 42, NULL, NULL ] [ "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 ] @@ -954,10 +954,10 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "dependencies", "depend_id", "int", 31, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dependencies", "depend_type", "smallint", 15, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dependencies_vw", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] -[ "sys._columns", "sys", "dependencies_vw", "obj_type", "char", 44, 0, NULL, true, 1, NULL, NULL ] +[ "sys._columns", "sys", "dependencies_vw", "obj_type", "varchar", 44, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "dependencies_vw", "name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "dependencies_vw", "used_by_id", "int", 31, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "dependencies_vw", "used_by_obj_type", "char", 44, 0, NULL, true, 4, NULL, NULL ] +[ "sys._columns", "sys", "dependencies_vw", "used_by_obj_type", "varchar", 44, 0, NULL, true, 4, NULL, NULL ] [ "sys._columns", "sys", "dependencies_vw", "used_by_name", "varchar", 1024, 0, NULL, true, 5, NULL, NULL ] [ "sys._columns", "sys", "dependencies_vw", "depend_type", "smallint", 15, 0, NULL, true, 6, NULL, NULL ] [ "sys._columns", "sys", "dependencies_vw", "dependency_type_name", "varchar", 15, 0, NULL, true, 7, NULL, NULL ] @@ -1156,14 +1156,14 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "describe_column_defaults", "col", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "describe_column_defaults", "def", "varchar", 2048, 0, NULL, true, 3, NULL, NULL ] [ "sys._columns", "sys", "describe_comments", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] -[ "sys._columns", "sys", "describe_comments", "tpe", "char", 30, 0, NULL, true, 1, NULL, NULL ] +[ "sys._columns", "sys", "describe_comments", "tpe", "varchar", 30, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "describe_comments", "fqn", "varchar", 0, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "describe_comments", "rem", "varchar", 65000, 0, NULL, true, 3, NULL, NULL ] [ "sys._columns", "sys", "describe_constraints", "sch", "varchar", 1024, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "describe_constraints", "tbl", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "describe_constraints", "col", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "describe_constraints", "con", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "describe_constraints", "tpe", "char", 11, 0, NULL, true, 4, NULL, NULL ] +[ "sys._columns", "sys", "describe_constraints", "tpe", "varchar", 11, 0, NULL, true, 4, NULL, NULL ] [ "sys._columns", "sys", "describe_foreign_keys", "fk_s", "varchar", 1024, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "describe_foreign_keys", "fk_t", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "describe_foreign_keys", "fk_c", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] @@ -1172,8 +1172,8 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "describe_foreign_keys", "pk_s", "varchar", 1024, 0, NULL, true, 5, NULL, NULL ] [ "sys._columns", "sys", "describe_foreign_keys", "pk_t", "varchar", 1024, 0, NULL, true, 6, NULL, NULL ] [ "sys._columns", "sys", "describe_foreign_keys", "pk_c", "varchar", 1024, 0, NULL, true, 7, NULL, NULL ] -[ "sys._columns", "sys", "describe_foreign_keys", "on_update", "char", 11, 0, NULL, true, 8, NULL, NULL ] -[ "sys._columns", "sys", "describe_foreign_keys", "on_delete", "char", 11, 0, NULL, true, 9, NULL, NULL ] +[ "sys._columns", "sys", "describe_foreign_keys", "on_update", "varchar", 11, 0, NULL, true, 8, NULL, NULL ] +[ "sys._columns", "sys", "describe_foreign_keys", "on_delete", "varchar", 11, 0, NULL, true, 9, NULL, NULL ] [ "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 ] @@ -1182,18 +1182,18 @@ select 'null in fkeys.delete_action', de [ "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 ] [ "sys._columns", "sys", "describe_indices", "col", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "describe_indices", "tpe", "char", 14, 0, NULL, true, 4, NULL, NULL ] +[ "sys._columns", "sys", "describe_indices", "tpe", "varchar", 14, 0, NULL, true, 4, NULL, NULL ] [ "sys._columns", "sys", "describe_partition_tables", "m_sch", "varchar", 1024, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "describe_partition_tables", "m_tbl", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "describe_partition_tables", "p_sch", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "describe_partition_tables", "p_tbl", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "describe_partition_tables", "tpe", "char", 9, 0, NULL, true, 4, NULL, NULL ] +[ "sys._columns", "sys", "describe_partition_tables", "tpe", "varchar", 9, 0, NULL, true, 4, NULL, NULL ] [ "sys._columns", "sys", "describe_partition_tables", "pvalues", "varchar", 0, 0, NULL, true, 5, NULL, NULL ] [ "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", "varchar", 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", "o_tpe", "varchar", 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 ] [ "sys._columns", "sys", "describe_privileges", "g_nme", "varchar", 1024, 0, NULL, true, 4, NULL, NULL ] @@ -1334,16 +1334,16 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "geometry_columns", "f_table_schema", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "geometry_columns", "f_table_name", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "geometry_columns", "f_geometry_column", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "geometry_columns", "coord_dimension", "int", 32, 0, NULL, true, 4, NULL, NULL ] -[ "sys._columns", "sys", "geometry_columns", "srid", "int", 32, 0, NULL, true, 5, NULL, NULL ] -[ "sys._columns", "sys", "geometry_columns", "geometry_type", "clob", 0, 0, NULL, true, 6, NULL, NULL ] -[ "sys._columns", "sys", "ids", "id", "int", 32, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "geometry_columns", "coord_dimension", "int", 31, 0, NULL, true, 4, NULL, NULL ] +[ "sys._columns", "sys", "geometry_columns", "srid", "int", 31, 0, NULL, true, 5, NULL, NULL ] +[ "sys._columns", "sys", "geometry_columns", "geometry_type", "varchar", 0, 0, NULL, true, 6, NULL, NULL ] +[ "sys._columns", "sys", "ids", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "ids", "name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "ids", "schema_id", "int", 31, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "ids", "table_id", "int", 31, 0, NULL, true, 3, NULL, NULL ] [ "sys._columns", "sys", "ids", "table_name", "varchar", 1024, 0, NULL, true, 4, NULL, NULL ] -[ "sys._columns", "sys", "ids", "obj_type", "char", 44, 0, NULL, true, 5, NULL, NULL ] -[ "sys._columns", "sys", "ids", "sys_table", "char", 13, 0, NULL, true, 6, NULL, NULL ] +[ "sys._columns", "sys", "ids", "obj_type", "varchar", 44, 0, NULL, true, 5, NULL, NULL ] +[ "sys._columns", "sys", "ids", "sys_table", "varchar", 13, 0, NULL, true, 6, NULL, NULL ] [ "sys._columns", "sys", "ids", "system", "boolean", 1, 0, NULL, true, 7, NULL, NULL ] [ "sys._columns", "sys", "idxs", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "idxs", "table_id", "int", 31, 0, NULL, true, 1, NULL, NULL ] @@ -1497,17 +1497,17 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "sessions", "username", "varchar", 0, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "sessions", "login", "timestamp", 7, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "sessions", "idle", "timestamp", 7, 0, NULL, true, 3, NULL, NULL ] -[ "sys._columns", "sys", "sessions", "optimizer", "clob", 0, 0, NULL, true, 4, NULL, NULL ] -[ "sys._columns", "sys", "sessions", "sessiontimeout", "int", 32, 0, NULL, true, 5, NULL, NULL ] -[ "sys._columns", "sys", "sessions", "querytimeout", "int", 32, 0, NULL, true, 6, NULL, NULL ] -[ "sys._columns", "sys", "sessions", "workerlimit", "int", 32, 0, NULL, true, 7, NULL, NULL ] -[ "sys._columns", "sys", "sessions", "memorylimit", "int", 32, 0, NULL, true, 8, NULL, NULL ] -[ "sys._columns", "sys", "spatial_ref_sys", "srid", "int", 32, 0, NULL, false, 0, NULL, NULL ] +[ "sys._columns", "sys", "sessions", "optimizer", "varchar", 0, 0, NULL, true, 4, NULL, NULL ] +[ "sys._columns", "sys", "sessions", "sessiontimeout", "int", 31, 0, NULL, true, 5, NULL, NULL ] +[ "sys._columns", "sys", "sessions", "querytimeout", "int", 31, 0, NULL, true, 6, NULL, NULL ] +[ "sys._columns", "sys", "sessions", "workerlimit", "int", 31, 0, NULL, true, 7, NULL, NULL ] +[ "sys._columns", "sys", "sessions", "memorylimit", "int", 31, 0, NULL, true, 8, NULL, NULL ] +[ "sys._columns", "sys", "spatial_ref_sys", "srid", "int", 31, 0, NULL, false, 0, NULL, NULL ] [ "sys._columns", "sys", "spatial_ref_sys", "auth_name", "varchar", 256, 0, NULL, true, 1, NULL, NULL ] -[ "sys._columns", "sys", "spatial_ref_sys", "auth_srid", "int", 32, 0, NULL, true, 2, NULL, NULL ] +[ "sys._columns", "sys", "spatial_ref_sys", "auth_srid", "int", 31, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "spatial_ref_sys", "srtext", "varchar", 2048, 0, NULL, true, 3, NULL, NULL ] [ "sys._columns", "sys", "spatial_ref_sys", "proj4text", "varchar", 2048, 0, NULL, true, 4, NULL, NULL ] -[ "sys._columns", "sys", "statistics", "column_id", "int", 32, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "statistics", "column_id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "statistics", "schema", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "statistics", "table", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] [ "sys._columns", "sys", "statistics", "column", "varchar", 1024, 0, NULL, true, 3, NULL, NULL ] @@ -1621,7 +1621,7 @@ select 'null in fkeys.delete_action', de [ "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", "varchar", 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 ] @@ -1630,7 +1630,7 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "value_partitions", "table_id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "value_partitions", "partition_id", "int", 31, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "value_partitions", "value", "varchar", 2048, 0, NULL, true, 2, NULL, NULL ] -[ "sys._columns", "sys", "var_values", "var_name", "char", 16, 0, NULL, true, 0, NULL, NULL ] +[ "sys._columns", "sys", "var_values", "var_name", "varchar", 16, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "var_values", "value", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "tmp", "_columns", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "tmp", "_columns", "name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] @@ -1676,28 +1676,28 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "tmp", "triggers", "statement", "varchar", 2048, 0, NULL, true, 9, NULL, NULL ] % .%1, .t, .c, .p # table_name % %1, name, name, expression # name -% char, varchar, varchar, varchar # type -% 20, 0, 0, 0 # length +% varchar, varchar, varchar, varchar # type +% 0, 0, 0, 0 # length % .%1, .t, .p, .r, .r, .r # table_name % %1, name, expression, minimum, maximum, with_nulls # name -% char, varchar, varchar, varchar, varchar, boolean # type -% 20, 0, 0, 0, 0, 5 # length +% varchar, varchar, varchar, varchar, varchar, boolean # type +% 0, 0, 0, 0, 0, 5 # length % .%1, .t, .p, .v # table_name % %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 -% 27, 0, 0, 0 # length +% varchar, varchar, varchar, varchar # type +% 0, 0, 0, 0 # length +% .%7, .x, .x, .x # table_name +% %7, sname, name, modfunc # name +% varchar, varchar, varchar, varchar # type +% 0, 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 -% 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", 64, 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", 32, 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 tinyint) 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", "tinyint", 8, 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, pathexpr string) 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", "pathexpr", "clob", 0, 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 ] +% varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, boolean, boolean, boolean, boolean, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar, varchar, varchar, int, int, varchar # 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, 7, 2, 1, 3, 9, 7, 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 ] +[ "sys.functions", "json", "filter", "SYSTEM", "create function json.filter(js json, name tinyint) 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", "tinyint", 7, 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, pathexpr string) 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", "pathexpr", "varchar", 0, 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", "integer", "SYSTEM", "create function json.\"integer\"(js json) returns bigint external name json.\"integer\";", "json", "MAL", "Scalar function", false, false, false, true, NULL, "result", "bigint", 63, 0, "out", "js", "json", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "json", "isarray", "SYSTEM", "create function json.isarray(js json) returns bool external name json.isarray;", "json", "MAL", "Scalar function", false, false, false, true, NULL, "result", "boolean", 1, 0, "out", "js", "json", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "json", "isobject", "SYSTEM", "create function json.isobject(js json) returns bool external name json.isobject;", "json", "MAL", "Scalar function", false, false, false, true, NULL, "result", "boolean", 1, 0, "out", "js", "json", 0, 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, NULL, NULL, NULL, NULL, NULL ] @@ -1756,8 +1756,6 @@ select 'null in fkeys.delete_action', de [ "sys.functions", "sys", "and", "SYSTEM", "and", "calc", "Internal C", "Scalar function", false, false, false, true, NULL, "res_0", "boolean", 1, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "boolean", 1, 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", "sys", "any_value", "SYSTEM", "min", "aggr", "Internal C", "Aggregate function", false, false, false, false, NULL, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "any_value", "SYSTEM", "min", "sql", "Internal C", "Analytic function", false, false, false, true, NULL, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "ascii", "SYSTEM", "ascii", "str", "Internal C", "Scalar function", false, false, false, true, NULL, "res_0", "int", 31, 0, "out", "arg_1", "char", 0, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "ascii", "SYSTEM", "ascii", "str", "Internal C", "Scalar function", false, false, false, true, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "ascii", "SYSTEM", "ascii", "str", "Internal C", "Scalar function", false, false, false, true, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "asciify", "SYSTEM", "create function asciify(x string) returns string external name str.asciify;", "str", "MAL", "Scalar function", false, false, false, true, NULL, "result", "varchar", 0, 0, "out", "x", "varchar", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "asin", "SYSTEM", "asin", "mmath", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "double", 53, 0, "out", "arg_1", "double", 53, 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, NULL, NULL, NULL, NULL, NULL ] @@ -1813,11 +1811,7 @@ select 'null in fkeys.delete_action', de [ "sys.functions", "sys", "bit_xor", "SYSTEM", "xor", "calc", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "smallint", 15, 0, "out", "arg_1", "smallint", 15, 0, "in", "arg_2", "smallint", 15, 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", "sys", "bit_xor", "SYSTEM", "xor", "calc", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "tinyint", 7, 0, "out", "arg_1", "tinyint", 7, 0, "in", "arg_2", "tinyint", 7, 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", "sys", "broadcast", "SYSTEM", "create function \"broadcast\" (p inet) returns inet external name inet.\"broadcast\";", "inet", "MAL", "Scalar function", false, false, false, true, NULL, "result", "inet", 0, 0, "out", "p", "inet", 0, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "btrim", "SYSTEM", "trim", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "char", 0, 0, "out", "arg_1", "char", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "btrim", "SYSTEM", "trim", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "varchar", 0, 0, "out", "arg_1", "varchar", 0, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "btrim", "SYSTEM", "trim", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "varchar", 0, 0, "out", "arg_1", "varchar", 0, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "btrim", "SYSTEM", "trim2", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "char", 0, 0, "out", "arg_1", "char", 0, 0, "in", "arg_2", "char", 0, 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", "sys", "btrim", "SYSTEM", "trim2", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "varchar", 0, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 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", "sys", "btrim", "SYSTEM", "trim2", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "varchar", 0, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 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", "sys", "cbrt", "SYSTEM", "cbrt", "mmath", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "double", 53, 0, "out", "arg_1", "double", 53, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "cbrt", "SYSTEM", "cbrt", "mmath", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "real", 24, 0, "out", "arg_1", "real", 24, 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, NULL, NULL, NULL, NULL, NULL ] @@ -1827,31 +1821,19 @@ select 'null in fkeys.delete_action', de [ "sys.functions", "sys", "ceiling", "SYSTEM", "ceil", "mmath", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "real", 24, 0, "out", "arg_1", "real", 24, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "century", "SYSTEM", "century", "mtime", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "date", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "century", "SYSTEM", "century", "mtime", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "timestamp", 7, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "century", "SYSTEM", "century", "mtime", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "timestamptz", 7, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "char_length", "SYSTEM", "length", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "char", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "char_length", "SYSTEM", "length", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "char_length", "SYSTEM", "length", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "character_length", "SYSTEM", "length", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "char", 0, 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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "character_length", "SYSTEM", "length", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "character_length", "SYSTEM", "length", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "charindex", "SYSTEM", "locate", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "char", 0, 0, "in", "arg_2", "char", 0, 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", "sys", "charindex", "SYSTEM", "locate", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 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", "sys", "charindex", "SYSTEM", "locate", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 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", "sys", "charindex", "SYSTEM", "locate3", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "char", 0, 0, "in", "arg_2", "char", 0, 0, "in", "arg_3", "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 ] -[ "sys.functions", "sys", "charindex", "SYSTEM", "locate3", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "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 ] [ "sys.functions", "sys", "charindex", "SYSTEM", "locate3", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 31, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "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 ] [ "sys.functions", "sys", "clearrejects", "SYSTEM", "create procedure sys.clearrejects() external name sql.copy_rejects_clear;", "sql", "MAL", "Procedure", true, false, false, true, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "code", "SYSTEM", "unicode", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "char", 0, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "code", "SYSTEM", "unicode", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "varchar", 0, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "code", "SYSTEM", "unicode", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "varchar", 0, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "columnsize", "SYSTEM", "create function sys.columnsize(tpe varchar(1024), count bigint) returns bigint begin if tpe in ('tinyint', 'boolean') then return count; end if; if tpe = 'smallint' then return 2 * count; end if; if tpe in ('int', 'real', 'date', 'time', 'timetz', 'sec_interval', 'day_interval', 'month_interval') then return 4 * count; end if; if tpe in ('bigint', 'double', 'timestamp', 'timestamptz', 'inet', 'oid') then return 8 * count; end if; if tpe in ('hugeint', 'decimal', 'uuid', 'mbr') then return 16 * count; end if; if tpe in ('varchar', 'char', 'clob', 'json', 'url') then return 4 * count; end if; if tpe in ('blob', 'geometry', 'geometrya') then return 8 * count; end if; return 8 * count; end;", "sql", "SQL", "Scalar function", false, false, false, true, NULL, "result", "bigint", 63, 0, "out", "tpe", "varchar", 1024, 0, "in", "count", "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", "sys", "concat", "SYSTEM", "+", "calc", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "char", 0, 0, "out", "arg_1", "char", 0, 0, "in", "arg_2", "char", 0, 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", "sys", "concat", "SYSTEM", "+", "calc", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "varchar", 0, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 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", "sys", "contains", "SYSTEM", "create filter function sys.contains(x string, y string) external name str.contains;", "str", "MAL", "Filter function", false, false, false, true, NULL, "x", "clob", 0, 0, "in", "y", "clob", 0, 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, NULL, NULL, NULL, NULL, NULL ] _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org