Changeset: 54e2f2eb446f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=54e2f2eb446f
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/scripts/25_debug.sql
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: default
Log Message:
Grant sleep function/procedure to public. There's no danger in doing that
diffs (64 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
@@ -2500,8 +2500,10 @@ sql_update_default(Client c, mvc *sql, c
" external name mdb.\"getDebugFlags\";\n"
"create procedure sys.\"sleep\"(msecs int)\n"
" external name \"alarm\".\"sleep\";\n"
+ "grant execute on procedure sys.\"sleep\"(int) to
public;\n"
"create function sys.\"sleep\"(msecs int) returns
integer\n"
- " external name \"alarm\".\"sleep\";\n");
+ " external name \"alarm\".\"sleep\";\n"
+ "grant execute on function sys.\"sleep\"(int) to
public;\n");
pos += snprintf(buf + pos, bufsize - pos,
"update sys.functions set system = true where schema_id
= (select id from sys.schemas where name = 'sys')"
" and name in ('debug', 'debugflags', 'sleep');\n");
diff --git a/sql/scripts/25_debug.sql b/sql/scripts/25_debug.sql
--- a/sql/scripts/25_debug.sql
+++ b/sql/scripts/25_debug.sql
@@ -85,7 +85,9 @@ create function sys.deltas ("schema" str
-- Sleep procedure
create procedure sys."sleep"(msecs int)
external name "alarm"."sleep";
+grant execute on procedure sys."sleep"(int) to public;
-- Sleep function
create function sys."sleep"(msecs int) returns integer
external name "alarm"."sleep";
+grant execute on function sys."sleep"(int) to public;
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
@@ -5067,6 +5067,8 @@ drop function pcre_replace(string, strin
[ "seq_char", "public", "EXECUTE", "monetdb", 0 ]
[ "seq_length", "public", "EXECUTE", "monetdb", 0
]
[ "setmasklen", "public", "EXECUTE", "monetdb", 0
]
+[ "sleep", "public", "EXECUTE", "monetdb", 0 ]
+[ "sleep", "public", "EXECUTE", "monetdb", 0 ]
[ "st_area", "public", "EXECUTE", "monetdb", 0 ]
[ "st_asbinary", "public", "EXECUTE", "monetdb", 0
]
[ "st_asewkt", "public", "EXECUTE", "monetdb", 0 ]
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
@@ -5050,6 +5050,8 @@ drop function pcre_replace(string, strin
[ "seq_char", "public", "EXECUTE", "monetdb", 0 ]
[ "seq_length", "public", "EXECUTE", "monetdb", 0
]
[ "setmasklen", "public", "EXECUTE", "monetdb", 0
]
+[ "sleep", "public", "EXECUTE", "monetdb", 0 ]
+[ "sleep", "public", "EXECUTE", "monetdb", 0 ]
[ "st_area", "public", "EXECUTE", "monetdb", 0 ]
[ "st_asbinary", "public", "EXECUTE", "monetdb", 0
]
[ "st_asewkt", "public", "EXECUTE", "monetdb", 0 ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -5293,6 +5293,8 @@ drop function pcre_replace(string, strin
[ "seq_char", "public", "EXECUTE", "monetdb", 0 ]
[ "seq_length", "public", "EXECUTE", "monetdb", 0
]
[ "setmasklen", "public", "EXECUTE", "monetdb", 0
]
+[ "sleep", "public", "EXECUTE", "monetdb", 0 ]
+[ "sleep", "public", "EXECUTE", "monetdb", 0 ]
[ "st_area", "public", "EXECUTE", "monetdb", 0 ]
[ "st_asbinary", "public", "EXECUTE", "monetdb", 0
]
[ "st_asewkt", "public", "EXECUTE", "monetdb", 0 ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
