Changeset: e024f4686250 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e024f4686250
Modified Files:
clients/Tests/MAL-signatures.test
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.int128
Branch: ustr
Log Message:
Approve output.
diffs (truncated from 4284 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.test
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -2819,11 +2819,6 @@ unsafe pattern alarm.sleep(X_0:any_1):an
ALARMsleep
Sleep a few milliseconds and return the slept value
alarm
-sleep
-unsafe pattern alarm.sleep(X_0:any_1):void
-ALARMsleep
-Sleep a few milliseconds
-alarm
time
unsafe command alarm.time():int
ALARMtime
@@ -22100,16 +22095,6 @@ CMDconvertsignal_str
(empty)
batcalc
str
-command batcalc.str(X_0:bat[:inet4], X_1:bat[:oid]):bat[:str]
-INETinet42str_bulk
-Coerce an inet4 to a string type
-batcalc
-str
-command batcalc.str(X_0:bat[:inet6], X_1:bat[:oid]):bat[:str]
-INETinet62str_bulk
-Coerce an inet6 to a string type
-batcalc
-str
pattern batcalc.str(X_0:int, X_1:int, X_2:int, X_3:int, X_4:bat[:any_1],
X_5:bat[:oid], X_6:int):bat[:str]
SQLbatstr_cast
cast to string and check for overflow
@@ -22119,11 +22104,6 @@ pattern batcalc.str(X_0:int, X_1:int, X_
SQLbatstr_cast
cast to string and check for overflow, no candidate list
batcalc
-str
-command batcalc.str(X_0:bat[:uuid], X_1:bat[:oid]):bat[:str]
-UUIDuuid2str_bulk
-Coerce a uuid to a string type
-batcalc
timestamp
pattern batcalc.timestamp(X_0:bat[:date], X_1:bat[:oid]):bat[:timestamp]
MTIMEtimestamp_fromdate_bulk
@@ -33565,25 +33545,10 @@ CMDvarCONVERT
Cast VALUE to str
calc
str
-command calc.str(X_0:inet4):str
-INETinet42str
-Coerce an inet4 to a string type
-calc
-str
-command calc.str(X_0:inet6):str
-INETinet62str
-Coerce an inet6 to a string type
-calc
-str
pattern calc.str(X_0:int, X_1:int, X_2:int, X_3:int, X_4:any_1, X_5:int):str
SQLstr_cast
cast to string and check for overflow
calc
-str
-command calc.str(X_0:uuid):str
-UUIDuuid2str
-Coerce a uuid to a string type
-calc
timestamp
command calc.timestamp(X_0:date):timestamp
MTIMEtimestamp_fromdate
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
@@ -434,7 +434,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s, ., ., .s, . # table_name
% %1, name, authorization, owner, system, comment # name
% varchar, varchar, varchar, varchar, boolean,
varchar # type
-% 11, 18, 8, 7, 5, 28 # length
+% -1, -1, -1, -1, 5, -1 # length
[ "sys.schemas", "information_schema", "monetdb", "monetdb",
true, "ISO/IEC 9075-11 SQL/Schemata" ]
[ "sys.schemas", "json", "monetdb", "monetdb", true, NULL
]
[ "sys.schemas", "logging", "monetdb", "monetdb", true,
NULL ]
@@ -444,7 +444,7 @@ select 'null in fkeys.delete_action', de
% .%25, .s, .t, ., ., .t, ., ., . #
table_name
% %25, name, name, query, type, system, commit_action, access, comment
# name
% varchar, varchar, varchar, varchar, varchar,
boolean, varchar, varchar, varchar # type
-% 11, 18, 34, 6812, 5, 5, 8, 8, 0 # length
+% -1, -1, -1, -1, -1, 5, -1, -1, -1 # 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, s.\"name\" as constraint_schema, k.\"name\" as
constraint_name, cast(sys.check_constraint(s.\"name\", k.\"name\") as
varchar(2048)) as check_clause, t.\"schema_id\" as schema_id, t.\"id\" as
table_id, t.\"name\" as table_name, k.\"id\" as key_id from (select sk.\"id\",
sk.\"table_id\", sk.\"name\" from sys.\"keys\" sk where sk.\"type\" = 4 union
all select tk.\"id\", tk.\"table_id\", tk.\"name\" from tmp.\"keys\" tk where
tk.\"type\" = 4) k inner join (select st.\"id\", st.\"schema_id\", st.\"name\"
from sys.\"_tables\" st union all select tt.\"id\", tt.\"schema_id\",
tt.\"name\" from tmp.\"_tables\" tt) t on k.\"table_id\" = t.\"id\" inner join
sys.\"schemas\" s on t.\"schema_id\" = s.\"id\" order by s.\"name\",
t.\"name\", k.\"name\";", "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 ]
@@ -592,7 +592,7 @@ select 'null in fkeys.delete_action', de
% .%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
% 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
+% -1, -1, -1, -1, -1, -1, -1, -1, 5, -1,
-1, -1 # 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 ]
[ "sys._columns", "information_schema", "character_sets",
"character_set_name", "varchar", 16, 0, NULL, true, 2,
NULL, NULL ]
@@ -1698,23 +1698,23 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .c, .p # table_name
% %1, name, name, expression # name
% varchar, varchar, varchar, varchar # type
-% 0, 0, 0, 0 # length
+% -1, -1, -1, -1 # length
% .%1, .t, .p, .r, .r, .r # table_name
% %1, name, expression, minimum, maximum, with_nulls #
name
% varchar, varchar, varchar, varchar, varchar,
boolean # type
-% 0, 0, 0, 0, 0, 5 # length
+% -1, -1, -1, -1, -1, 5 # length
% .%1, .t, .p, .v # table_name
% %1, name, expression, value # name
% varchar, varchar, varchar, varchar # type
-% 0, 0, 0, 0 # length
+% -1, -1, -1, -1 # length
% .%6, .x, .x, .x # table_name
% %6, sname, name, modfunc # name
% varchar, varchar, varchar, varchar # type
-% 0, 0, 0, 0 # length
+% -1, -1, -1, -1 # 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
% 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, 7, 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, 14,
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, 8, 7,
1, 1, 3, 11, 7, 2, 1, 3, 6, 7,
4, 1, 3, 9, 7, 4, 1, 3, 6, 7,
4, 1, 3 # length
+% -1, -1, -1, -1, -1, -1, -1, -1, 5, 5,
5, 5, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1 # 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 ]
@@ -2879,7 +2879,7 @@ select 'null in fkeys.delete_action', de
% .%1, ., . # table_name
% %1, name, grantor # name
% varchar, varchar, varchar # type
-% 9, 9, 7 # length
+% -1, -1, -1 # length
[ "sys.auths", ".snapshot", "monetdb" ]
[ "sys.auths", "monetdb", NULL ]
[ "sys.auths", "public", NULL ]
@@ -2887,13 +2887,13 @@ select 'null in fkeys.delete_action', de
% .%1, .u, .u, .s, .u, .u, .u, .u, . # table_name
% %1, name, fullname, name, schema_path, max_memory,
max_workers, optimizer, default_role # name
% varchar, varchar, varchar, varchar, varchar,
bigint, int, varchar, varchar # type
-% 16, 9, 13, 3, 5, 1, 1, 12, 9 # length
+% -1, -1, -1, -1, -1, -1, -1, -1, -1 # length
[ "sys.db_user_info", ".snapshot", "Snapshot User", "sys",
"\"sys\"", 0, 0, "default_pipe", ".snapshot" ]
[ "sys.db_user_info", "monetdb", "MonetDB Admin", "sys",
"\"sys\"", 0, 0, "default_pipe", "monetdb" ]
% .%1, .s1, .f1, .s2, .f2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 25, 3, 17, 3, 37, 9 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "function used by function", "sys", "date_to_str", "sys", "dayname",
"FUNCTION" ]
[ "function used by function", "sys", "describe_type", "sys",
"describe_columns", "FUNCTION" ]
[ "function used by function", "sys", "sql_datatype", "sys",
"describe_type", "FUNCTION" ]
@@ -2920,7 +2920,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t, .s2, .f, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 22, 3, 26, 3, 37, 9 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "table used by function", "sys", "db_user_info", "sys", "db_users",
"FUNCTION" ]
[ "table used by function", "sys", "_columns", "sys",
"describe_columns", "FUNCTION" ]
[ "table used by function", "sys", "_tables", "sys",
"describe_columns", "FUNCTION" ]
@@ -2979,7 +2979,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t, .c, .s2, .f, .dt # table_name
% %1, name, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar # type
-% 23, 3, 26, 21, 3, 37, 9 # length
+% -1, -1, -1, -1, -1, -1, -1 # length
[ "column used by function", "sys", "db_user_info", "name", "sys",
"db_users", "FUNCTION" ]
[ "column used by function", "sys", "_columns", "default", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "_columns", "id", "sys",
"describe_columns", "FUNCTION" ]
@@ -3118,7 +3118,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .f1, .s2, .t2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 21, 7, 37, 18, 26, 4 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "function used by view", "sys", "check_constraint",
"information_schema", "check_constraints", "VIEW" ]
[ "function used by view", "sys", "sql_datatype", "information_schema",
"columns", "VIEW" ]
[ "function used by view", "sys", "sql_datatype", "information_schema",
"parameters", "VIEW" ]
@@ -3207,7 +3207,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t1, .s2, .t2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 18, 3, 27, 18, 34, 4 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "table used by view", "sys", "_tables", "information_schema",
"check_constraints", "VIEW" ]
[ "table used by view", "sys", "keys", "information_schema",
"check_constraints", "VIEW" ]
[ "table used by view", "sys", "schemas", "information_schema",
"check_constraints", "VIEW" ]
@@ -3474,7 +3474,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t1, .c1, .s2, .t2, .dt # table_name
% %1, name, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar # type
-% 19, 3, 27, 21, 18, 34, 4 # length
+% -1, -1, -1, -1, -1, -1, -1 # length
[ "column used by view", "sys", "_tables", "id",
"information_schema", "check_constraints", "VIEW" ]
[ "column used by view", "sys", "_tables", "name",
"information_schema", "check_constraints", "VIEW" ]
[ "column used by view", "sys", "_tables", "schema_id",
"information_schema", "check_constraints", "VIEW" ]
@@ -4397,7 +4397,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t1, .c1, .s2, .t2, .k2, .dt # table_name
% %1, name, name, name, name, name, name, dependency_type_name #
name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar, varchar # type
-% 18, 3, 18, 20, 3, 18, 44, 3 # length
+% -1, -1, -1, -1, -1, -1, -1, -1 # length
[ "column used by key", "sys", "comments", "id", "sys",
"comments", "comments_id_pkey", "KEY" ]
[ "column used by key", "sys", "dependency_types",
"dependency_type_id", "sys", "dependency_types",
"dependency_types_dependency_type_id_pkey", "KEY" ]
[ "column used by key", "sys", "dependency_types",
"dependency_type_name", "sys", "dependency_types",
"dependency_types_dependency_type_name_unique", "KEY" ]
@@ -4419,7 +4419,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t1, .c1, .s2, .t2, .i2, .dt # table_name
% %1, name, name, name, name, name, name, dependency_type_name #
name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar, varchar # type
-% 20, 3, 18, 20, 3, 18, 44, 5 # length
+% -1, -1, -1, -1, -1, -1, -1, -1 # length
[ "column used by index", "sys", "comments", "id", "sys",
"comments", "comments_id_pkey", "INDEX" ]
[ "column used by index", "sys", "dependency_types",
"dependency_type_id", "sys", "dependency_types",
"dependency_types_dependency_type_id_pkey", "INDEX" ]
[ "column used by index", "sys", "dependency_types",
"dependency_type_name", "sys", "dependency_types",
"dependency_types_dependency_type_name_unique", "INDEX" ]
@@ -4441,7 +4441,7 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .t, .s, .f, .dt # table_name
% %1, systemname, sqlname, name, name, dependency_type_name #
name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 21, 5, 5, 4, 18, 4 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "type used by function", "json", "json", "json", "filter", "TYPE"
]
[ "type used by function", "json", "json", "json", "filter", "TYPE"
]
[ "type used by function", "json", "json", "json", "filter", "TYPE"
]
@@ -4506,7 +4506,7 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .i, .it, . # table_name
% %1, name, name, index_type_name, comment # name
% varchar, varchar, varchar, varchar, varchar # type
-% 8, 18, 44, 4, 0 # length
+% -1, -1, -1, -1, -1 # length
[ "sys.idxs", "comments", "comments_id_pkey", "Hash", NULL ]
[ "sys.idxs", "dependency_types",
"dependency_types_dependency_type_id_pkey", "Hash", NULL ]
[ "sys.idxs", "dependency_types",
"dependency_types_dependency_type_name_unique", "Hash", NULL ]
@@ -4528,7 +4528,7 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .k, .kt, .k2, .k # table_name
% %1, name, name, key_type_name, name, action # name
% varchar, varchar, varchar, varchar, varchar,
int # type
-% 8, 18, 44, 11, 0, 2 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "sys.keys", "comments", "comments_id_pkey", "Primary Key", NULL,
-1 ]
[ "sys.keys", "dependency_types",
"dependency_types_dependency_type_id_pkey", "Primary Key", NULL, -1
]
[ "sys.keys", "dependency_types",
"dependency_types_dependency_type_name_unique", "Unique Key", NULL, -1
]
@@ -4550,7 +4550,7 @@ select 'null in fkeys.delete_action', de
% .%2, .o, ., . # table_name
% %2, name, nr, sub # name
% varchar, varchar, varchar, varchar # type
-% 11, 20, 1, 0 # length
+% -1, -1, -1, -1 # length
[ "sys.objects", "action_id", "0", NULL ]
[ "sys.objects", "action_id", "0", NULL ]
[ "sys.objects", "dependency_type_id", "0", NULL ]
@@ -4590,13 +4590,13 @@ select 'null in fkeys.delete_action', de
% .%1, .s, .u # table_name
% %1, name, name # name
% varchar, varchar, varchar # type
-% 22, 3, 9 # length
+% -1, -1, -1 # length
[ "default schema of user", "sys", ".snapshot" ]
[ "default schema of user", "sys", "monetdb" ]
% .%1, .t, .a, .pc, .g, .p # table_name
% %1, name, name, privilege_code_name, name, grantable # name
% varchar, varchar, varchar, varchar, varchar,
int # type
-% 14, 34, 7, 6, 7, 1 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "grant on table", "_columns", "public", "SELECT", NULL,
0 ]
[ "grant on table", "_tables", "public", "SELECT", NULL,
0 ]
[ "grant on table", "args", "public", "SELECT", NULL, 0
]
@@ -4703,11 +4703,11 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .c, .a, .pc, .g, .p # table_name
% %1, name, name, name, privilege_code_name, name, grantable # name
% varchar, varchar, varchar, varchar, varchar,
varchar, int # type
-% 0, 0, 0, 0, 0, 0, 1 # length
+% -1, -1, -1, -1, -1, -1, -1 # length
% .%1, .s, .f, .a, .pc, .g, .p # table_name
% %1, name, name, name, privilege_code_name, name, grantable # name
% varchar, varchar, varchar, varchar, varchar,
varchar, int # type
-% 17, 7, 24, 9, 7, 7, 1 # length
+% -1, -1, -1, -1, -1, -1, -1 # length
[ "grant on function", "json", "filter", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "json", "filter", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "json", "filter", "public", "EXECUTE",
"monetdb", 0 ]
@@ -5156,26 +5156,26 @@ select 'null in fkeys.delete_action', de
% .%1, .s, .q, .q, .q, .q, .q, .q, .q, . #
table_name
% %1, name, name, start, minvalue, maxvalue, increment,
cacheinc, cycle, comment # name
% varchar, varchar, varchar, bigint, bigint, bigint, bigint,
bigint, boolean, varchar # type
-% 0, 0, 0, 1, 1, 1, 1, 1, 5, 0 #
length
+% -1, -1, -1, -1, -1, -1, -1, -1, 5, -1 #
length
% .%12 # table_name
% %12 # name
% bigint # type
-% 1 # length
+% -1 # length
[ 0 ]
% .%1 # table_name
% %1 # name
% bigint # type
-% 1 # length
+% -1 # length
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
