Changeset: 6353fba827b8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6353fba827b8 Removed Files: sql/scripts/09_like.sql.c sql/scripts/10_math.sql.c sql/scripts/11_times.sql.c sql/scripts/12_url.sql.c sql/scripts/13_date.sql.c sql/scripts/14_inet.sql.c sql/scripts/15_querylog.sql.c sql/scripts/16_tracelog.sql.c sql/scripts/17_temporal.sql.c sql/scripts/18_index.sql.c sql/scripts/20_vacuum.sql.c sql/scripts/21_dependency_views.sql.c sql/scripts/22_clients.sql.c sql/scripts/23_skyserver.sql.c sql/scripts/25_debug.sql.c sql/scripts/26_sysmon.sql.c sql/scripts/27_rejects.sql.c sql/scripts/39_analytics.sql.c sql/scripts/39_analytics_hge.sql.c sql/scripts/40_json.sql.c sql/scripts/40_json_hge.sql.c sql/scripts/41_md5sum.sql.c sql/scripts/45_uuid.sql.c sql/scripts/46_profiler.sql.c sql/scripts/51_sys_schema_extension.sql.c sql/scripts/60_wlcr.sql.c sql/scripts/75_storagemodel.sql.c sql/scripts/80_statistics.sql.c sql/scripts/99_system.sql.c Branch: translate-scripts Log Message:
Remove unused c files. diffs (truncated from 1102 to 300 lines): diff --git a/sql/scripts/09_like.sql.c b/sql/scripts/09_like.sql.c deleted file mode 100644 --- a/sql/scripts/09_like.sql.c +++ /dev/null @@ -1,33 +0,0 @@ -/* -* This Source Code Form is subject to the terms of the Mozilla Public -* License, v. 2.0. If a copy of the MPL was not distributed with this -* file, You can obtain one at http://mozilla.org/MPL/2.0/. -* -* Copyright 1997 - July 2008 CWI, August 2008 - 2019 MonetDB B.V. -*/ - -// This file was generated automatically through bootstrap.py. -// Do not edit this file directly. - -#include "monetdb_config.h" - -#include "09_like.sql.h" -#include "gdk.h" -#include "mal_client.h" -#include "sql_catalog.h" - -#include <assert.h> - -extern str SQLstatementIntern(Client c, str *expr, str nme, bit execute, bit output, res_table **result); - -str -sql_install_09_like(Client c, char *buf, size_t bufsize) -{ - size_t pos = 0; - - pos += snprintf(buf, bufsize, " create filter function \"like\"(val string, pat string, esc string) external name algebra.\"like\"; create filter function \"ilike\"(val string, pat string, esc string) external name algebra.\"ilike\"; create filter function \"like\"(val string, pat string) external name algebra.\"like\"; create filter function \"ilike\"(val string, pat string) external name algebra.\"ilike\"; grant execute on filter function \"like\" (string, string, string) to public; grant execute on filter function \"ilike\" (string, string, string) to public; grant execute on filter function \"like\" (string, string) to public; grant execute on filter function \"ilike\" (string, string) to public;"); - if (pos >= bufsize) - throw(SQL, "createdb.09_like", SQLSTATE(42000) "SQL script to install is too large"); - printf("# loading sql script: 09_like.sql\n"); - return SQLstatementIntern(c, &buf, "createdb.09_like", 1, 0, NULL); -} diff --git a/sql/scripts/10_math.sql.c b/sql/scripts/10_math.sql.c deleted file mode 100644 --- a/sql/scripts/10_math.sql.c +++ /dev/null @@ -1,33 +0,0 @@ -/* -* This Source Code Form is subject to the terms of the Mozilla Public -* License, v. 2.0. If a copy of the MPL was not distributed with this -* file, You can obtain one at http://mozilla.org/MPL/2.0/. -* -* Copyright 1997 - July 2008 CWI, August 2008 - 2019 MonetDB B.V. -*/ - -// This file was generated automatically through bootstrap.py. -// Do not edit this file directly. - -#include "monetdb_config.h" - -#include "10_math.sql.h" -#include "gdk.h" -#include "mal_client.h" -#include "sql_catalog.h" - -#include <assert.h> - -extern str SQLstatementIntern(Client c, str *expr, str nme, bit execute, bit output, res_table **result); - -str -sql_install_10_math(Client c, char *buf, size_t bufsize) -{ - size_t pos = 0; - - pos += snprintf(buf, bufsize, " CREATE FUNCTION degrees(r double) RETURNS double RETURN r*180/pi(); CREATE FUNCTION radians(d double) RETURNS double RETURN d*pi()/180; grant execute on function degrees to public; grant execute on function radians to public;"); - if (pos >= bufsize) - throw(SQL, "createdb.10_math", SQLSTATE(42000) "SQL script to install is too large"); - printf("# loading sql script: 10_math.sql\n"); - return SQLstatementIntern(c, &buf, "createdb.10_math", 1, 0, NULL); -} diff --git a/sql/scripts/11_times.sql.c b/sql/scripts/11_times.sql.c deleted file mode 100644 --- a/sql/scripts/11_times.sql.c +++ /dev/null @@ -1,33 +0,0 @@ -/* -* This Source Code Form is subject to the terms of the Mozilla Public -* License, v. 2.0. If a copy of the MPL was not distributed with this -* file, You can obtain one at http://mozilla.org/MPL/2.0/. -* -* Copyright 1997 - July 2008 CWI, August 2008 - 2019 MonetDB B.V. -*/ - -// This file was generated automatically through bootstrap.py. -// Do not edit this file directly. - -#include "monetdb_config.h" - -#include "11_times.sql.h" -#include "gdk.h" -#include "mal_client.h" -#include "sql_catalog.h" - -#include <assert.h> - -extern str SQLstatementIntern(Client c, str *expr, str nme, bit execute, bit output, res_table **result); - -str -sql_install_11_times(Client c, char *buf, size_t bufsize) -{ - size_t pos = 0; - - pos += snprintf(buf, bufsize, " create procedure times() external name sql.times; grant execute on procedure times to public;"); - if (pos >= bufsize) - throw(SQL, "createdb.11_times", SQLSTATE(42000) "SQL script to install is too large"); - printf("# loading sql script: 11_times.sql\n"); - return SQLstatementIntern(c, &buf, "createdb.11_times", 1, 0, NULL); -} diff --git a/sql/scripts/12_url.sql.c b/sql/scripts/12_url.sql.c deleted file mode 100644 --- a/sql/scripts/12_url.sql.c +++ /dev/null @@ -1,33 +0,0 @@ -/* -* This Source Code Form is subject to the terms of the Mozilla Public -* License, v. 2.0. If a copy of the MPL was not distributed with this -* file, You can obtain one at http://mozilla.org/MPL/2.0/. -* -* Copyright 1997 - July 2008 CWI, August 2008 - 2019 MonetDB B.V. -*/ - -// This file was generated automatically through bootstrap.py. -// Do not edit this file directly. - -#include "monetdb_config.h" - -#include "12_url.sql.h" -#include "gdk.h" -#include "mal_client.h" -#include "sql_catalog.h" - -#include <assert.h> - -extern str SQLstatementIntern(Client c, str *expr, str nme, bit execute, bit output, res_table **result); - -str -sql_install_12_url(Client c, char *buf, size_t bufsize) -{ - size_t pos = 0; - - pos += snprintf(buf, bufsize, " CREATE TYPE url EXTERNAL NAME url; CREATE function getAnchor( theUrl url ) RETURNS STRING EXTERNAL NAME url.\"getAnchor\"; GRANT EXECUTE ON FUNCTION getAnchor(url) TO PUBLIC; CREATE function getBasename(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getBasename\"; GRANT EXECUTE ON FUNCTION getBasename(url) TO PUBLIC; CREATE function getContent(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getContent\"; GRANT EXECUTE ON FUNCTION getContent(url) TO PUBLIC; CREATE function getContext(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getContext\"; GRANT EXECUTE ON FUNCTION getContext(url) TO PUBLIC; CREATE function getDomain(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getDomain\"; GRANT EXECUTE ON FUNCTION getDomain(url) TO PUBLIC; CREATE function getExtension(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getExtension\"; GRANT EXECUTE ON FUNCTION getExtension(url) TO PUBLIC; CREATE function getFile(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getFile \"; GRANT EXECUTE ON FUNCTION getFile(url) TO PUBLIC; CREATE function getHost(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getHost\"; GRANT EXECUTE ON FUNCTION getHost(url) TO PUBLIC; CREATE function getPort(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getPort\"; GRANT EXECUTE ON FUNCTION getPort(url) TO PUBLIC; CREATE function getProtocol(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getProtocol\"; GRANT EXECUTE ON FUNCTION getProtocol(url) TO PUBLIC; CREATE function getQuery(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getQuery\"; GRANT EXECUTE ON FUNCTION getQuery(url) TO PUBLIC; CREATE function getUser(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getUser\"; GRANT EXECUTE ON FUNCTION getUser(url) TO PUBLIC; CREATE function getRobotURL(theUrl url) RETURNS STRING EXTERNAL NAME url.\"getRobotURL\"; GRANT EXECUTE ON FUNCTION getRobotURL(url) TO PUBLIC; CREATE function isaURL(theUrl url) RETURNS BOOL EXTERNAL NAME url.\"isaURL\"; GRANT EXECUTE ON FUNCTION isaURL(url) TO PUBLI C; CREATE function newurl(protocol STRING, hostname STRING, \"port\" INT, file STRING) RETURNS url EXTERNAL NAME url.\"new\"; GRANT EXECUTE ON FUNCTION newurl(STRING, STRING, INT, STRING) TO PUBLIC; CREATE function newurl(protocol STRING, hostname STRING, file STRING) RETURNS url EXTERNAL NAME url.\"new\"; GRANT EXECUTE ON FUNCTION newurl(STRING, STRING, STRING) TO PUBLIC;"); - if (pos >= bufsize) - throw(SQL, "createdb.12_url", SQLSTATE(42000) "SQL script to install is too large"); - printf("# loading sql script: 12_url.sql\n"); - return SQLstatementIntern(c, &buf, "createdb.12_url", 1, 0, NULL); -} diff --git a/sql/scripts/13_date.sql.c b/sql/scripts/13_date.sql.c deleted file mode 100644 --- a/sql/scripts/13_date.sql.c +++ /dev/null @@ -1,33 +0,0 @@ -/* -* This Source Code Form is subject to the terms of the Mozilla Public -* License, v. 2.0. If a copy of the MPL was not distributed with this -* file, You can obtain one at http://mozilla.org/MPL/2.0/. -* -* Copyright 1997 - July 2008 CWI, August 2008 - 2019 MonetDB B.V. -*/ - -// This file was generated automatically through bootstrap.py. -// Do not edit this file directly. - -#include "monetdb_config.h" - -#include "13_date.sql.h" -#include "gdk.h" -#include "mal_client.h" -#include "sql_catalog.h" - -#include <assert.h> - -extern str SQLstatementIntern(Client c, str *expr, str nme, bit execute, bit output, res_table **result); - -str -sql_install_13_date(Client c, char *buf, size_t bufsize) -{ - size_t pos = 0; - - pos += snprintf(buf, bufsize, " create function str_to_date(s string, format string) returns date external name mtime.\"str_to_date\"; create function date_to_str(d date, format string) returns string external name mtime.\"date_to_str\"; create function str_to_time(s string, format string) returns time external name mtime.\"str_to_time\"; create function time_to_str(d time, format string) returns string external name mtime.\"time_to_str\"; create function str_to_timestamp(s string, format string) returns timestamp external name mtime.\"str_to_timestamp\"; create function timestamp_to_str(d timestamp, format string) returns string external name mtime.\"timestamp_to_str\"; grant execute on function str_to_date to public; grant execute on function date_to_str to public; grant execute on function str_to_time to public; grant execute on function time_to_str to public; grant execute on function str_to_timestamp to public; grant execute on function timestamp_to_str to public;"); - if (pos >= bufsize) - throw(SQL, "createdb.13_date", SQLSTATE(42000) "SQL script to install is too large"); - printf("# loading sql script: 13_date.sql\n"); - return SQLstatementIntern(c, &buf, "createdb.13_date", 1, 0, NULL); -} diff --git a/sql/scripts/14_inet.sql.c b/sql/scripts/14_inet.sql.c deleted file mode 100644 --- a/sql/scripts/14_inet.sql.c +++ /dev/null @@ -1,33 +0,0 @@ -/* -* This Source Code Form is subject to the terms of the Mozilla Public -* License, v. 2.0. If a copy of the MPL was not distributed with this -* file, You can obtain one at http://mozilla.org/MPL/2.0/. -* -* Copyright 1997 - July 2008 CWI, August 2008 - 2019 MonetDB B.V. -*/ - -// This file was generated automatically through bootstrap.py. -// Do not edit this file directly. - -#include "monetdb_config.h" - -#include "14_inet.sql.h" -#include "gdk.h" -#include "mal_client.h" -#include "sql_catalog.h" - -#include <assert.h> - -extern str SQLstatementIntern(Client c, str *expr, str nme, bit execute, bit output, res_table **result); - -str -sql_install_14_inet(Client c, char *buf, size_t bufsize) -{ - size_t pos = 0; - - pos += snprintf(buf, bufsize, " CREATE TYPE inet EXTERNAL NAME inet; CREATE FUNCTION \"broadcast\" (p inet) RETURNS inet EXTERNAL NAME inet.\"broadcast\"; GRANT EXECUTE ON FUNCTION \"broadcast\"(inet) TO PUBLIC; CREATE FUNCTION \"host\" (p inet) RETURNS clob EXTERNAL NAME inet.\"host\"; GRANT EXECUTE ON FUNCTION \"host\"(inet) TO PUBLIC; CREATE FUNCTION \"masklen\" (p inet) RETURNS int EXTERNAL NAME inet.\"masklen\"; GRANT EXECUTE ON FUNCTION \"masklen\"(inet) TO PUBLIC; CREATE FUNCTION \"setmasklen\" (p inet, mask int) RETURNS inet EXTERNAL NAME inet.\"setmasklen\"; GRANT EXECUTE ON FUNCTION \"setmasklen\"(inet, int) TO PUBLIC; CREATE FUNCTION \"netmask\" (p inet) RETURNS inet EXTERNAL NAME inet.\"netmask\"; GRANT EXECUTE ON FUNCTION \"netmask\"(inet) TO PUBLIC; CREATE FUNCTION \"hostmask\" (p inet) RETURNS inet EXTERNAL NAME inet.\"hostmask\"; GRANT EXECUTE ON FUNCTION \"hostmask\"(inet) TO PUBLIC; CREATE FUNCTION \"network\" (p inet) RETURNS inet EXTERNAL NAME inet.\"network\"; GRANT EXECUTE ON FUNCTION \"network\"(inet) TO PUBLIC; CREATE FUNCTION \"text\" (p inet) RETURNS clob EXTERNAL NAME inet.\"text\"; GRANT EXECUTE ON FUNCTION \"text\"(inet) TO PUBLIC; CREATE FUNCTION \"abbrev\" (p inet) RETURNS clob EXTERNAL NAME inet.\"abbrev\"; GRANT EXECUTE ON FUNCTION \"abbrev\"(inet) TO PUBLIC; CREATE FUNCTION \"left_shift\"(i1 inet, i2 inet) RETURNS boolean EXTERNAL NAME inet.\"<<\"; GRANT EXECUTE ON FUNCTION \"left_shift\"(inet, inet) TO PUBLIC; CREATE FUNCTION \"right_shift\"(i1 inet, i2 inet) RETURNS boolean EXTERNAL NAME inet.\">>\"; GRANT EXECUTE ON FUNCTION \"right_shift\"(inet, inet) TO PUBLIC; CREATE FUNCTION \"left_shift_assign\"(i1 inet, i2 inet) RETURNS boolean EXTERNAL NAME inet.\"<<=\"; GRANT EXECUTE ON FUNCTION \"left_shift_assign\"(inet, inet) TO PUBLIC; CREATE FUNCTION \"right_shift_assign\"(i1 inet, i2 inet) RETURNS boolean EXTERNAL NAME inet.\">>=\"; GRANT EXECUTE ON FUNCTION \"right_shift_assign\"(inet, inet) TO PUBLIC;"); - if (pos >= bufsize) - throw(SQL, "createdb.14_inet", SQLSTATE(42000) "SQL script to install is too large"); - printf("# loading sql script: 14_inet.sql\n"); - return SQLstatementIntern(c, &buf, "createdb.14_inet", 1, 0, NULL); -} diff --git a/sql/scripts/15_querylog.sql.c b/sql/scripts/15_querylog.sql.c deleted file mode 100644 --- a/sql/scripts/15_querylog.sql.c +++ /dev/null @@ -1,33 +0,0 @@ -/* -* This Source Code Form is subject to the terms of the Mozilla Public -* License, v. 2.0. If a copy of the MPL was not distributed with this -* file, You can obtain one at http://mozilla.org/MPL/2.0/. -* -* Copyright 1997 - July 2008 CWI, August 2008 - 2019 MonetDB B.V. -*/ - -// This file was generated automatically through bootstrap.py. -// Do not edit this file directly. - -#include "monetdb_config.h" - -#include "15_querylog.sql.h" -#include "gdk.h" -#include "mal_client.h" -#include "sql_catalog.h" - -#include <assert.h> - -extern str SQLstatementIntern(Client c, str *expr, str nme, bit execute, bit output, res_table **result); - -str -sql_install_15_querylog(Client c, char *buf, size_t bufsize) -{ - size_t pos = 0; - - pos += snprintf(buf, bufsize, " create function sys.querylog_catalog() returns table( id oid, owner string, defined timestamp, query string, pipe string, \"plan\" string, mal int, optimize bigint ) external name sql.querylog_catalog; create function sys.querylog_calls() returns table( id oid, \"start\" timestamp, \"stop\" timestamp, arguments string, tuples bigint, run bigint, ship bigint, cpu int, io int ) external name sql.querylog_calls; create view sys.querylog_catalog as select * from sys.querylog_catalog(); create view sys.querylog_calls as select * from sys.querylog_calls(); create view sys.querylog_history as select qd.*, ql.\"start\",ql.\"stop\", ql.arguments, ql.tuples, ql.run, ql.ship, ql.cpu, ql.io from sys.querylog_catalog() qd, sys.querylog_calls() ql where qd.id = ql.id and qd.owner = user; create procedure sys.querylog_empty() external name sql.querylog_empty; create procedure sys.querylog_enable() external name sql.querylog_enable; create procedure sys. querylog_enable(threshold smallint) external name sql.querylog_enable_threshold; create procedure sys.querylog_disable() external name sql.querylog_disable;"); - if (pos >= bufsize) - throw(SQL, "createdb.15_querylog", SQLSTATE(42000) "SQL script to install is too large"); - printf("# loading sql script: 15_querylog.sql\n"); - return SQLstatementIntern(c, &buf, "createdb.15_querylog", 1, 0, NULL); -} diff --git a/sql/scripts/16_tracelog.sql.c b/sql/scripts/16_tracelog.sql.c deleted file mode 100644 --- a/sql/scripts/16_tracelog.sql.c +++ /dev/null @@ -1,33 +0,0 @@ -/* -* This Source Code Form is subject to the terms of the Mozilla Public -* License, v. 2.0. If a copy of the MPL was not distributed with this -* file, You can obtain one at http://mozilla.org/MPL/2.0/. -* -* Copyright 1997 - July 2008 CWI, August 2008 - 2019 MonetDB B.V. -*/ - -// This file was generated automatically through bootstrap.py. -// Do not edit this file directly. - -#include "monetdb_config.h" - -#include "16_tracelog.sql.h" -#include "gdk.h" -#include "mal_client.h" -#include "sql_catalog.h" - -#include <assert.h> - -extern str SQLstatementIntern(Client c, str *expr, str nme, bit execute, bit output, res_table **result); - -str -sql_install_16_tracelog(Client c, char *buf, size_t bufsize) -{ - size_t pos = 0; - - pos += snprintf(buf, bufsize, " create function sys.tracelog() returns table ( event integer, clk varchar(20), pc varchar(50), thread int, ticks bigint, rrsMB bigint, vmMB bigint, reads bigint, writes bigint, minflt bigint, majflt bigint, nvcsw bigint, stmt string ) external name sql.dump_trace; create view sys.tracelog as select * from sys.tracelog();"); - if (pos >= bufsize) _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
