Changeset: 22d83a1ccf86 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=22d83a1ccf86
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/scripts/16_tracelog.sql
Branch: profiler
Log Message:
Prepare upgrade code for the SQL catalog.
diffs (31 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
@@ -1630,8 +1630,16 @@ sql_update_dec2015(Client c)
pos += snprintf(buf + pos, bufsize - pos, "set schema \"sys\";\n");
/* insert upgrade code here */
+ pos += snprintf(buf + pos, bufsize - pos, "drop procedure
profiler_openstream(host string, port int);");
+ pos += snprintf(buf + pos, bufsize - pos, "drop procedure
profiler_stethoscope(ticks int);");
+ pos += snprintf(buf + pos, bufsize - pos, "create schema profiler;"
+ "create procedure profiler.start() external name
profiler.\"start/";"
+ "create procedure profiler.stop() external name profiler.stop;"
+ "create procedure profiler.setheartbeat(beat int) external name
profiler.setheartbeat;"
+ "create procedure profiler.setpoolsize(poolsize int) external
name profiler.setpoolsize;"
+ "create procedure profiler.setstream(host string, port int)
external name profiler.setstream;");
- if (schema) {
+ if (schema) {
pos += snprintf(buf + pos, bufsize - pos, "set schema
\"%s\";\n", schema);
free(schema);
}
diff --git a/sql/scripts/16_tracelog.sql b/sql/scripts/16_tracelog.sql
--- a/sql/scripts/16_tracelog.sql
+++ b/sql/scripts/16_tracelog.sql
@@ -24,6 +24,3 @@ create function sys.tracelog()
external name sql.dump_trace;
create view sys.tracelog as select * from sys.tracelog();
-
---create procedure profiler_openstream(host string, port int) external name
profiler."openStream";
---create procedure profiler_stethoscope(ticks int) external name
profiler.stethoscope;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list