Changeset: 685ceeb6de1b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/685ceeb6de1b
Modified Files:
sql/backends/monet5/sql_upgrades.c
Branch: Sep2022
Log Message:
Layout.
diffs (29 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -5129,7 +5129,24 @@ sql_update_sep2022(Client c, mvc *sql)
output = NULL;
/* 16_tracelog */
- pos = snprintf(buf, bufsize, "select f.id from sys.schemas s,
sys.functions f, 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 s.name = 'sys' and f.name = 'tracelog' and
ft.function_type_keyword = 'FUNCTION';\n");
+ pos = snprintf(buf, bufsize,
+ "select f.id "
+ "from sys.schemas s, "
+ "sys.functions f, "
+ "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 s.name = 'sys' "
+ "and f.name = 'tracelog' "
+ "and ft.function_type_keyword =
'FUNCTION';\n");
assert(pos < bufsize);
if ((err = SQLstatementIntern(c, buf, "update", true, false, &output)))
goto bailout;
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]