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 -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org

Reply via email to