Changeset: 63c29b93625c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/63c29b93625c
Modified Files:
clients/Tests/MAL-signatures.test
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: userprofile
Log Message:
Approve output.
diffs (truncated from 905 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
@@ -24459,11 +24459,6 @@ pattern batsql.ntile(X_0:bat[:any], X_1:
SQLntile;
return the groups divided as equally as possible
batsql
-password
-pattern batsql.password(X_0:bat[:str]):bat[:str]
-db_password_wrap;
-Return password hash of user
-batsql
percent_rank
pattern batsql.percent_rank(X_0:bat[:any_1], X_1:any_2, X_2:any_3):bat[:dbl]
SQLpercent_rank;
@@ -32294,26 +32289,11 @@ pattern capi.subeval_aggr(X_0:ptr, X_1:b
CUDFevalAggr;
grouped aggregates through CUDF
clients
-addUser
-unsafe pattern clients.addUser(X_0:str, X_1:str):oid
-CLTaddUser;
-Allow user with password access to the given scenarios
-clients
backendsum
command clients.backendsum(X_0:str):str
CLTbackendsum;
Return hex string representation of the currently used hash of the given string
clients
-changePassword
-unsafe pattern clients.changePassword(X_0:str, X_1:str):void
-CLTchangePassword;
-Change the password for the current user
-clients
-changeUsername
-unsafe pattern clients.changeUsername(X_0:str, X_1:str):void
-CLTchangeUsername;
-Change the username of the user into the new string
-clients
checkPermission
pattern clients.checkPermission(X_0:str, X_1:str):void
CLTcheckPermission;
@@ -32354,11 +32334,6 @@ pattern clients.getUsername():str
CLTgetUsername;
Return the username of the currently logged in user
clients
-getUsers
-pattern clients.getUsers() (X_0:bat[:oid], X_1:bat[:str])
-CLTgetUsers;
-return a BAT with user id and one with name available in the system
-clients
getprofile
pattern clients.getprofile() (X_0:str, X_1:int, X_2:int, X_3:int, X_4:int)
CLTgetProfile;
@@ -32379,11 +32354,6 @@ unsafe pattern clients.quit(X_0:int):voi
CLTquit;
Terminate the session for a single client using a soft error.@It is the
privilege of the console user.
clients
-removeUser
-unsafe pattern clients.removeUser(X_0:str):void
-CLTremoveUser;
-Remove the given user from the system
-clients
ripemd160sum
command clients.ripemd160sum(X_0:str):str
CLTripemd160sum;
@@ -32394,11 +32364,6 @@ unsafe pattern clients.setListing(X_0:in
CLTsetListing;
Turn on/off echo of MAL instructions:@1 - echo input,@2 - show mal
instruction,@4 - show details of type resolutoin, @8 - show binding information.
clients
-setPassword
-unsafe pattern clients.setPassword(X_0:str, X_1:str):void
-CLTsetPassword;
-Set the password for the given user
-clients
setQryTimeoutMicro
unsafe pattern clients.setQryTimeoutMicro(X_0:lng):void
CLTqueryTimeoutMicro;
@@ -36844,11 +36809,6 @@ command sql.date_trunc(X_0:str, X_1:time
date_trunc;
Truncate a timestamp to (millennium,
century,decade,year,quarter,month,week,day,hour,minute,second,
milliseconds,microseconds)
sql
-db_users
-pattern sql.db_users():bat[:str]
-db_users_wrap;
-return table of users with sql scenario
-sql
delete
unsafe pattern sql.delete(X_0:int, X_1:str, X_2:str, X_3:any):int
mvc_delete_wrap;
@@ -37161,7 +37121,7 @@ getPipeCatalog;
sql
password
pattern sql.password(X_0:str):str
-db_password_wrap;
+SQLuser_password;
Return password hash of user
sql
percent_rank
@@ -37755,7 +37715,7 @@ SQLalter_table;
Catalog operation alter_table
sqlcatalog
alter_user
-pattern sqlcatalog.alter_user(X_0:str, X_1:str, X_2:int, X_3:str, X_4:str,
X_5:str):void
+pattern sqlcatalog.alter_user(X_0:str, X_1:str, X_2:int, X_3:str, X_4:str,
X_5:str, X_6:str):void
SQLalter_user;
Catalog operation alter_user
sqlcatalog
@@ -37800,7 +37760,7 @@ SQLcreate_type;
Catalog operation create_type
sqlcatalog
create_user
-pattern sqlcatalog.create_user(X_0:str, X_1:str, X_2:int, X_3:str, X_4:str,
X_5:str):void
+pattern sqlcatalog.create_user(X_0:str, X_1:str, X_2:int, X_3:str, X_4:str,
X_5:str, X_6:lng, X_7:int, X_8:str, X_9:str):void
SQLcreate_user;
Catalog operation create_user
sqlcatalog
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
@@ -480,7 +480,7 @@ select 'null in value_partitions.value',
[ "sys._tables", "sys", "dump_comments", "create view
sys.dump_comments as select 'COMMENT ON ' || c.tpe || ' ' || c.fqn || ' IS ' ||
sys.sq(c.rem) || ';' stmt from sys.describe_comments c;", "VIEW", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "dump_create_roles", "create view
sys.dump_create_roles as select 'CREATE ROLE ' || sys.dq(name) || ';' stmt,
name user_name from sys.auths where name not in (select name from
sys.db_user_info) and grantor <> 0;", "VIEW", true, "COMMIT",
"WRITABLE", NULL ]
[ "sys._tables", "sys", "dump_create_schemas", "create view
sys.dump_create_schemas as select 'CREATE SCHEMA ' || sys.dq(s.name) ||
ifthenelse(a.name <> 'sysadmin', ' AUTHORIZATION ' || sys.dq(a.name), ' ') ||
';' stmt, s.name schema_name from sys.schemas s, sys.auths a where
s.authorization = a.id and s.system = false;", "VIEW", true, "COMMIT",
"WRITABLE", NULL ]
-[ "sys._tables", "sys", "dump_create_users", "create view
sys.dump_create_users as select 'CREATE USER ' || sys.dq(ui.name) || ' WITH
ENCRYPTED PASSWORD ' || sys.sq(sys.password_hash(ui.name)) || ' NAME ' ||
sys.sq(ui.fullname) || ' SCHEMA sys' || ifthenelse(ui.schema_path = '\"sys\"',
'', ' SCHEMA PATH ' || sys.sq(ui.schema_path)) || ';' stmt, ui.name user_name
from sys.db_user_info ui, sys.schemas s where ui.default_schema = s.id and
ui.name <> 'monetdb' and ui.name <> '.snapshot';", "VIEW", true, "COMMIT",
"WRITABLE", NULL ]
+[ "sys._tables", "sys", "dump_create_users", "create view
sys.dump_create_users as select 'CREATE USER ' || sys.dq(ui.name) || ' WITH
ENCRYPTED PASSWORD ' || sys.sq(sys.password_hash(ui.name)) || ' NAME ' ||
sys.sq(ui.fullname) || ' SCHEMA ' || sys.sq(s.name) || ' SCHEMA PATH ' ||
sys.sq(ui.schema_path) || ';' stmt, ui.name user_name from sys.db_user_info ui,
sys.schemas s where ui.default_schema = s.id and ui.name <> 'monetdb' and
ui.name <> '.snapshot';", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "dump_foreign_keys", "create view
sys.dump_foreign_keys as select 'ALTER TABLE ' || sys.fqn(fk_s, fk_t) || ' ADD
CONSTRAINT ' || sys.dq(fk) || ' ' || 'FOREIGN KEY(' ||
group_concat(sys.dq(fk_c), ',') ||') ' || 'REFERENCES ' || sys.fqn(pk_s, pk_t)
|| '(' || group_concat(sys.dq(pk_c), ',') || ') ' || 'ON DELETE ' || on_delete
|| ' ON UPDATE ' || on_update || ';' stmt, fk_s foreign_schema_name, fk_t
foreign_table_name, pk_s primary_schema_name, pk_t primary_table_name, fk
key_name from sys.describe_foreign_keys group by fk_s, fk_t, pk_s, pk_t, fk,
on_delete, on_update;", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "dump_function_grants", "create view
sys.dump_function_grants as with func_args_all(func_id, number, max_number,
func_arg) as (select a.func_id, a.number, max(a.number) over (partition by
a.func_id order by a.number desc), group_concat(sys.describe_type(a.type,
a.type_digits, a.type_scale), ', ') over (partition by a.func_id order by
a.number) from sys.args a where a.inout = 1), func_args(func_id, func_arg) as
(select func_id, func_arg from func_args_all where number = max_number) select
'GRANT ' || pc.privilege_code_name || ' ON ' || ft.function_type_keyword || ' '
|| sys.fqn(s.name, f.name) || '(' || coalesce(fa.func_arg, '') || ') TO ' ||
ifthenelse(a.name = 'public', 'PUBLIC', sys.dq(a.name)) || case when
p.grantable = 1 then ' WITH GRANT OPTION' else '' end || ';' stmt, s.name
schema_name, f.name function_name, a.name grantee from sys.schemas s,
sys.functions f left outer join func_args fa on f.id = fa.func_id, sys.auths a,
sys.privileges p, sys.auths g,
sys.function_types ft, sys.privilege_codes pc where s.id = f.schema_id and
f.id = p.obj_id and p.auth_id = a.id and p.grantor = g.id and p.privileges =
pc.privilege_code_id and f.type = ft.function_type_id and not f.system order by
s.name, f.name, a.name, g.name, p.grantable;", "VIEW", true, "COMMIT",
"WRITABLE", NULL ]
[ "sys._tables", "sys", "dump_functions", "create view
sys.dump_functions as select f.o o, sys.schema_guard(f.sch, f.fun, f.def) stmt,
f.sch schema_name, f.fun function_name from sys.describe_functions f;",
"VIEW", true, "COMMIT", "WRITABLE", NULL ]
@@ -527,7 +527,7 @@ select 'null in value_partitions.value',
[ "sys._tables", "sys", "queue", "create view sys.queue as
select * from sys.queue();", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "range_partitions", NULL, "TABLE",
true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "rejects", "create view sys.rejects as
select * from sys.rejects();", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
-[ "sys._tables", "sys", "roles", "create view sys.roles as
select id, name, grantor from sys.auths a where a.name not in (select u.name
from sys.db_users() u);", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
+[ "sys._tables", "sys", "roles", "create view sys.roles as
select id, name, grantor from sys.auths a where a.name not in (select u.name
from sys.users u);", "VIEW", true, "COMMIT", "WRITABLE", NULL
]
[ "sys._tables", "sys", "schemas", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "schemastorage", "create view
sys.\"schemastorage\" as select \"schema\", count(*) as \"storages\",
sum(columnsize) as columnsize, sum(heapsize) as heapsize, sum(hashes) as
hashsize, sum(\"imprints\") as imprintsize, sum(orderidx) as orderidxsize from
sys.\"storage\" group by \"schema\" order by \"schema\";", "VIEW", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "sequences", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
@@ -546,7 +546,7 @@ select 'null in value_partitions.value',
[ "sys._tables", "sys", "triggers", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "types", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "user_role", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
-[ "sys._tables", "sys", "users", "create view sys.users as
select u.\"name\" as \"name\", ui.\"fullname\", ui.\"default_schema\",
ui.\"schema_path\" from sys.db_users() as u left join \"sys\".\"db_user_info\"
as ui on u.\"name\" = ui.\"name\";", "VIEW", true, "COMMIT",
"WRITABLE", NULL ]
+[ "sys._tables", "sys", "users", "create view sys.users as
select u.\"name\", u.\"fullname\", u.\"default_schema\", u.\"schema_path\",
u.\"max_memory\", u.\"max_workers\", u.\"optimizer\", u.\"default_role\" from
\"sys\".\"db_user_info\" as u;", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "value_partitions", NULL, "TABLE",
true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "var_values", "create view sys.var_values
(var_name, value) as select 'current_role', current_role union all select
'current_schema', current_schema union all select 'current_timezone',
current_timezone union all select 'current_user', current_user union all select
'debug', debug union all select 'last_id', last_id union all select
'optimizer', optimizer union all select 'pi', pi() union all select 'rowcnt',
rowcnt;", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "tmp", "_columns", NULL, "TABLE", true,
"PRESERVE", "WRITABLE", NULL ]
@@ -625,6 +625,11 @@ select 'null in value_partitions.value',
[ "sys._columns", "db_user_info", "fullname", "varchar", 2048,
0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "db_user_info", "default_schema", "int", 9,
0, NULL, true, 2, NULL, NULL ]
[ "sys._columns", "db_user_info", "schema_path", "clob", 0, 0,
NULL, true, 3, NULL, NULL ]
+[ "sys._columns", "db_user_info", "max_memory", "bigint", 19,
0, NULL, true, 4, NULL, NULL ]
+[ "sys._columns", "db_user_info", "max_workers", "int", 9, 0,
NULL, true, 5, NULL, NULL ]
+[ "sys._columns", "db_user_info", "optimizer", "varchar", 1024,
0, NULL, true, 6, NULL, NULL ]
+[ "sys._columns", "db_user_info", "default_role", "int", 9, 0,
NULL, true, 7, NULL, NULL ]
+[ "sys._columns", "db_user_info", "password", "varchar", 256,
0, NULL, true, 8, NULL, NULL ]
[ "sys._columns", "dependencies", "id", "int", 32, 0, NULL,
true, 0, NULL, NULL ]
[ "sys._columns", "dependencies", "depend_id", "int", 32, 0,
NULL, true, 1, NULL, NULL ]
[ "sys._columns", "dependencies", "depend_type", "smallint", 16,
0, NULL, true, 2, NULL, NULL ]
@@ -756,7 +761,7 @@ select 'null in value_partitions.value',
[ "sys._columns", "dependency_owners_on_schemas", "depend_type",
"smallint", 16, 0, NULL, true, 3, NULL, NULL ]
[ "sys._columns", "dependency_schemas_on_users", "schema_id", "int",
32, 0, NULL, true, 0, NULL, NULL ]
[ "sys._columns", "dependency_schemas_on_users", "schema_name",
"varchar", 1024, 0, NULL, true, 1, NULL, NULL ]
-[ "sys._columns", "dependency_schemas_on_users", "user_name",
"varchar", 2048, 0, NULL, true, 2, NULL, NULL ]
+[ "sys._columns", "dependency_schemas_on_users", "user_name",
"varchar", 1024, 0, NULL, true, 2, NULL, NULL ]
[ "sys._columns", "dependency_schemas_on_users", "depend_type",
"smallint", 16, 0, NULL, true, 3, NULL, NULL ]
[ "sys._columns", "dependency_tables_on_foreignkeys",
"table_schema_id", "int", 32, 0, NULL, true, 0, NULL,
NULL ]
[ "sys._columns", "dependency_tables_on_foreignkeys", "table_id",
"int", 32, 0, NULL, true, 1, NULL, NULL ]
@@ -1312,6 +1317,10 @@ select 'null in value_partitions.value',
[ "sys._columns", "users", "fullname", "varchar", 2048,
0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "users", "default_schema", "int", 9,
0, NULL, true, 2, NULL, NULL ]
[ "sys._columns", "users", "schema_path", "clob", 0, 0,
NULL, true, 3, NULL, NULL ]
+[ "sys._columns", "users", "max_memory", "bigint", 19,
0, NULL, true, 4, NULL, NULL ]
+[ "sys._columns", "users", "max_workers", "int", 9, 0,
NULL, true, 5, NULL, NULL ]
+[ "sys._columns", "users", "optimizer", "varchar", 1024,
0, NULL, true, 6, NULL, NULL ]
+[ "sys._columns", "users", "default_role", "int", 9, 0,
NULL, true, 7, NULL, NULL ]
[ "sys._columns", "value_partitions", "table_id", "int", 32,
0, NULL, true, 0, NULL, NULL ]
[ "sys._columns", "value_partitions", "partition_id", "int", 32,
0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "value_partitions", "value", "varchar",
2048, 0, NULL, true, 2, NULL, NULL ]
@@ -1545,7 +1554,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "dayofmonth", "SYSTEM", "day",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "int", 32, 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", "dayofweek", "SYSTEM", "dayofweek",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "int", 32, 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", "dayofyear", "SYSTEM", "dayofyear",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "int", 32, 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", "db_users", "SYSTEM", "CREATE
FUNCTION db_users () RETURNS TABLE(name varchar(2048)) EXTERNAL NAME
sql.db_users;", "sql", "MAL", "Function returning a table", false,
false, false, true, NULL, "name", "varchar", 2048, 0, "out",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, 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", "db_users", "SYSTEM", "CREATE
FUNCTION db_users () RETURNS TABLE(name varchar(2048)) return select name from
users;", "sql", "SQL", "Function returning a table", false, false, false,
true, NULL, "name", "varchar", 2048, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "debug", "SYSTEM", "create
function sys.debug(debug int) returns integer external name mdb.\"setDebug\";",
"mdb", "MAL", "Scalar function", false, false, false, true, NULL,
"result", "int", 32, 0, "out", "debug", "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, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "debug", "SYSTEM", "create
function sys.debug(flag string) returns integer external name
mdb.\"setDebug\";", "mdb", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "int", 32, 0, "out",
"flag", "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 ]
[ "sys.functions", "sys", "debugflags", "SYSTEM", "create
function sys.debugflags() returns table(flag string, val bool) external name
mdb.\"getDebugFlags\";", "mdb", "MAL", "Function returning a table",
false, false, false, true, NULL, "flag", "clob", 0, 0, "out",
"val", "boolean", 1, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -2821,7 +2830,6 @@ select 'null in value_partitions.value',
[ "function used by view", "sys", "querylog_catalog", "sys",
"querylog_history", "VIEW" ]
[ "function used by view", "sys", "queue", "sys", "queue",
"VIEW" ]
[ "function used by view", "sys", "rejects", "sys", "rejects",
"VIEW" ]
-[ "function used by view", "sys", "db_users", "sys", "roles",
"VIEW" ]
[ "function used by view", "sys", "sessions", "sys", "sessions",
"VIEW" ]
[ "function used by view", "sys", "statistics", "sys", "statistics",
"VIEW" ]
[ "function used by view", "sys", "storage", "sys", "storage",
"VIEW" ]
@@ -2834,7 +2842,6 @@ select 'null in value_partitions.value',
[ "function used by view", "sys", "heapsize", "sys",
"tablestoragemodel", "VIEW" ]
[ "function used by view", "sys", "imprintsize", "sys",
"tablestoragemodel", "VIEW" ]
[ "function used by view", "sys", "tracelog", "sys", "tracelog",
"VIEW" ]
-[ "function used by view", "sys", "db_users", "sys", "users",
"VIEW" ]
% .%1, sys.s1, sys.t1, sys.s2, sys.t2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% char, varchar, varchar, varchar, varchar,
varchar # type
@@ -3045,6 +3052,7 @@ select 'null in value_partitions.value',
[ "table used by view", "tmp", "keys", "sys", "ids", "VIEW" ]
[ "table used by view", "tmp", "triggers", "sys", "ids", "VIEW"
]
[ "table used by view", "sys", "auths", "sys", "roles",
"VIEW" ]
+[ "table used by view", "sys", "users", "sys", "roles",
"VIEW" ]
[ "table used by view", "sys", "storage", "sys",
"schemastorage", "VIEW" ]
[ "table used by view", "sys", "schemas", "sys", "statistics",
"VIEW" ]
[ "table used by view", "sys", "tables", "sys", "statistics",
"VIEW" ]
@@ -3531,6 +3539,7 @@ select 'null in value_partitions.value',
[ "column used by view", "sys", "db_user_info", "name", "sys",
"dump_create_users", "VIEW" ]
[ "column used by view", "sys", "db_user_info", "schema_path", "sys",
"dump_create_users", "VIEW" ]
[ "column used by view", "sys", "schemas", "id", "sys",
"dump_create_users", "VIEW" ]
+[ "column used by view", "sys", "schemas", "name", "sys",
"dump_create_users", "VIEW" ]
[ "column used by view", "sys", "describe_foreign_keys", "fk",
"sys", "dump_foreign_keys", "VIEW" ]
[ "column used by view", "sys", "describe_foreign_keys", "fk_c",
"sys", "dump_foreign_keys", "VIEW" ]
[ "column used by view", "sys", "describe_foreign_keys", "fk_s",
"sys", "dump_foreign_keys", "VIEW" ]
@@ -3754,6 +3763,7 @@ select 'null in value_partitions.value',
[ "column used by view", "sys", "auths", "grantor", "sys",
"roles", "VIEW" ]
[ "column used by view", "sys", "auths", "id", "sys",
"roles", "VIEW" ]
[ "column used by view", "sys", "auths", "name", "sys",
"roles", "VIEW" ]
+[ "column used by view", "sys", "users", "name", "sys",
"roles", "VIEW" ]
[ "column used by view", "sys", "storage", "columnsize", "sys",
"schemastorage", "VIEW" ]
[ "column used by view", "sys", "storage", "hashes", "sys",
"schemastorage", "VIEW" ]
[ "column used by view", "sys", "storage", "heapsize", "sys",
"schemastorage", "VIEW" ]
@@ -3814,9 +3824,13 @@ select 'null in value_partitions.value',
[ "column used by view", "sys", "storagemodelinput", "sorted",
"sys", "tablestoragemodel", "VIEW" ]
[ "column used by view", "sys", "storagemodelinput", "table",
"sys", "tablestoragemodel", "VIEW" ]
[ "column used by view", "sys", "storagemodelinput", "type", "sys",
"tablestoragemodel", "VIEW" ]
+[ "column used by view", "sys", "db_user_info", "default_role", "sys",
"users", "VIEW" ]
[ "column used by view", "sys", "db_user_info", "default_schema",
"sys", "users", "VIEW" ]
[ "column used by view", "sys", "db_user_info", "fullname", "sys",
"users", "VIEW" ]
+[ "column used by view", "sys", "db_user_info", "max_memory", "sys",
"users", "VIEW" ]
+[ "column used by view", "sys", "db_user_info", "max_workers", "sys",
"users", "VIEW" ]
[ "column used by view", "sys", "db_user_info", "name", "sys",
"users", "VIEW" ]
+[ "column used by view", "sys", "db_user_info", "optimizer", "sys",
"users", "VIEW" ]
[ "column used by view", "sys", "db_user_info", "schema_path", "sys",
"users", "VIEW" ]
% .%1, sys.s1, sys.t1, sys.c1, sys.s2, sys.t2, sys.k2, .dt # table_name
% %1, name, name, name, name, name, name, dependency_type_name #
name
@@ -3993,7 +4007,7 @@ select 'null in value_partitions.value',
[ "sys.objects", "table_type_id", "0", NULL ]
[ "sys.objects", "table_type_name", "0", NULL ]
[ "sys.objects", "table_type_name", "0", NULL ]
-% .%1, sys.s, .u # table_name
+% .%1, sys.s, sys.u # table_name
% %1, name, name # name
% char, varchar, varchar # type
% 22, 3, 9 # length
@@ -4002,7 +4016,7 @@ select 'null in value_partitions.value',
% .%1, sys.t, sys.a, .pc, .g, .p # table_name
% %1, name, name, privilege_code_name, name, grantable # name
% char, varchar, varchar, varchar, varchar,
int # type
-% 14, 34, 6, 6, 7, 1 # length
+% 14, 34, 7, 6, 7, 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
]
@@ -4010,6 +4024,7 @@ select 'null in value_partitions.value',
[ "grant on table", "columns", "public", "SELECT", NULL,
0 ]
[ "grant on table", "comments", "public", "SELECT", NULL,
0 ]
[ "grant on table", "compinfo", "public", "SELECT",
"monetdb", 0 ]
+[ "grant on table", "db_user_info", "monetdb", "SELECT", NULL,
0 ]
[ "grant on table", "dependencies", "public", "SELECT", NULL,
0 ]
[ "grant on table", "dependencies_vw", "public", "SELECT",
"monetdb", 0 ]
[ "grant on table", "dependency_args_on_types", "public",
"SELECT", "monetdb", 0 ]
@@ -4087,6 +4102,7 @@ select 'null in value_partitions.value',
[ "grant on table", "triggers", "public", "SELECT", NULL,
0 ]
[ "grant on table", "types", "public", "SELECT", NULL,
0 ]
[ "grant on table", "user_role", "public", "SELECT", NULL,
0 ]
+[ "grant on table", "users", "public", "SELECT", NULL,
0 ]
[ "grant on table", "value_partitions", "public", "SELECT",
NULL, 0 ]
[ "grant on table", "var_values", "public", "SELECT",
"monetdb", 0 ]
% .%1, .t, .c, sys.a, .pc, .g, .p # table_name
@@ -4987,7 +5003,7 @@ select 'null in value_partitions.value',
% %2, %1, id # name
% char, bigint, int # type
% 19, 1, 1 # length
-% .%2, .%1, .users # table_name
+% .%2, sys.%1, sys.users # table_name
% %2, %1, name # name
% char, bigint, varchar # type
% 19, 1, 0 # length
@@ -5367,22 +5383,22 @@ select 'null in value_partitions.value',
% %5, grantor, id, name, grantor # name
% char, int, int, varchar, int # type
% 34, 1, 1, 0, 1 # length
-% .%5, .users, .users, .users, .users, .users # table_name
-% %5, name, name, fullname, default_schema, schema_path # name
-% char, varchar, varchar, varchar, int, clob #
type
-% 31, 0, 0, 0, 1, 0 # length
-% .%5, .users, .users, .users, .users, .users # table_name
-% %5, default_schema, name, fullname, default_schema, schema_path #
name
-% char, int, varchar, varchar, int, clob # type
-% 41, 1, 0, 0, 1, 0 # length
-% .%5, sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info, sys.db_user_info # table_name
-% %5, name, name, fullname, default_schema, schema_path # name
-% char, varchar, varchar, varchar, int, clob #
type
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
