Changeset: 3eba515f3e5d for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3eba515f3e5d Modified Files: sql/ChangeLog.Apr2012 sql/backends/monet5/sql_scenario.c Branch: Apr2012 Log Message:
Partial (incomplete) fix for a bug in the upgrade from Aug2011 to Dec2011. Procedures weren't marked as procedure in the sys.functions table. This is now fixed, but the fix is "too late" in the sense that the SQL engine has already internalized the functions. diffs (22 lines): diff --git a/sql/ChangeLog.Apr2012 b/sql/ChangeLog.Apr2012 --- a/sql/ChangeLog.Apr2012 +++ b/sql/ChangeLog.Apr2012 @@ -1,3 +1,7 @@ # ChangeLog file for sql # This file is updated with Maddlog +* Tue May 15 2012 Sjoerd Mullender <[email protected]> +- Databases that were upgraded from the Aug2011 release have an error + in the catalog for SQL procedures. This is now fixed. + diff --git a/sql/backends/monet5/sql_scenario.c b/sql/backends/monet5/sql_scenario.c --- a/sql/backends/monet5/sql_scenario.c +++ b/sql/backends/monet5/sql_scenario.c @@ -444,6 +444,7 @@ sql_update_apr2012_sp1(Client c) size_t bufsize = 2048, pos = 0; /* changes in createdb/25_debug.sql */ + pos += snprintf(buf+pos, bufsize-pos, "update sys.functions set type = %d, side_effect = false where type = %d and id not in (select func_id from sys.args where number = 0 and name = 'result');\n", F_PROC, F_FUNC); pos += snprintf(buf+pos, bufsize-pos, "drop function sys.storage;\n"); pos += snprintf(buf+pos, bufsize-pos, "create function sys.storage() returns table (\"schema\" string, \"table\" string, \"column\" string, location string, \"count\" bigint, capacity bigint, width int, size bigint, hashsize bigint, sorted boolean) external name sql.storage;\n"); pos += snprintf(buf+pos, bufsize-pos, "create function sys.optimizers() returns table (name string, def string, status string) external name sql.optimizers;\n"); _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
