Changeset: a52e9211863d for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a52e9211863d Added Files: sql/test/Tests/systemfunctions_nogeom.sql.src sql/test/Tests/systemfunctions_nogeom.stable.err sql/test/Tests/systemfunctions_nogeom.stable.out sql/test/Tests/trace_nogeom.sql.src sql/test/Tests/trace_nogeom.stable.err sql/test/Tests/trace_nogeom.stable.out Modified Files: sql/test/Tests/All Branch: Jul2012 Log Message:
Created versions of tests in case the geom module is not available. Two tests (at least) give different output depending on whether geom is available or not. diffs (truncated from 491 to 300 lines): diff --git a/sql/test/Tests/All b/sql/test/Tests/All --- a/sql/test/Tests/All +++ b/sql/test/Tests/All @@ -1,4 +1,5 @@ -systemfunctions +HAVE_GEOM?systemfunctions +!HAVE_GEOM?systemfunctions_nogeom example example-queries example-drop @@ -93,6 +94,7 @@ copy_into antiselect median_stdev -trace +HAVE_GEOM?trace +!HAVE_GEOM?trace_nogeom HAVE_JDBCCLIENT_JAR?bogus-auto-generated-keys diff --git a/sql/test/Tests/systemfunctions_nogeom.sql.src b/sql/test/Tests/systemfunctions_nogeom.sql.src new file mode 100644 --- /dev/null +++ b/sql/test/Tests/systemfunctions_nogeom.sql.src @@ -0,0 +1,1 @@ +$RELSRCDIR/systemfunctions.sql diff --git a/sql/test/Tests/systemfunctions_nogeom.stable.err b/sql/test/Tests/systemfunctions_nogeom.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/Tests/systemfunctions_nogeom.stable.err @@ -0,0 +1,37 @@ +stderr of test 'systemfunctions_nogeom` in directory 'test` itself: + + +# 16:39:08 > +# 16:39:08 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=37784" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_." "--set" "mal_listing=0" +# 16:39:08 > + +# builtin opt gdk_dbname = demo +# builtin opt gdk_dbfarm = /ufs/sjoerd/Monet-candidate/var/monetdb5/dbfarm +# builtin opt gdk_debug = 0 +# builtin opt gdk_alloc_map = no +# builtin opt gdk_vmtrim = yes +# builtin opt monet_prompt = > +# builtin opt monet_daemon = no +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 0 +# cmdline opt gdk_dbfarm = /ufs/sjoerd/Monet-candidate/var/MonetDB +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 37784 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbname = mTests_. +# cmdline opt mal_listing = 0 + +# 16:39:08 > +# 16:39:08 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=madrid" "--port=37784" +# 16:39:08 > + + +# 16:39:08 > +# 16:39:08 > "Done." +# 16:39:08 > + diff --git a/sql/test/Tests/systemfunctions_nogeom.stable.out b/sql/test/Tests/systemfunctions_nogeom.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/Tests/systemfunctions_nogeom.stable.out @@ -0,0 +1,275 @@ +stdout of test 'systemfunctions_nogeom` in directory 'test` itself: + + +# 16:39:08 > +# 16:39:08 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=37784" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_." "--set" "mal_listing=0" +# 16:39:08 > + +# MonetDB 5 server v11.9.2 (hg id: 98699895d8d4+) +# This is an unreleased version +# Serving database 'mTests_.', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 15.629 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://madrid.ins.cwi.nl:37784/ +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. +# SQL catalog created, loading sql scripts once +# loading sql script: 09_like.sql +# loading sql script: 10_math.sql +# loading sql script: 11_times.sql +# loading sql script: 12_url.sql +# loading sql script: 13_date.sql +# loading sql script: 14_inet.sql +# loading sql script: 15_history.sql +# loading sql script: 16_tracelog.sql +# loading sql script: 17_compress.sql +# loading sql script: 18_dictionary.sql +# loading sql script: 19_cluster.sql +# loading sql script: 20_vacuum.sql +# loading sql script: 21_dependency_functions.sql +# loading sql script: 22_clients.sql +# loading sql script: 23_skyserver.sql +# loading sql script: 24_zorder.sql +# loading sql script: 25_debug.sql +# loading sql script: 39_analytics.sql +# loading sql script: 80_udf.sql +# loading sql script: 99_system.sql + +# 16:39:08 > +# 16:39:08 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=madrid" "--port=37784" +# 16:39:08 > + +#select s.name as "schema", f.name as "function", a.number as "argno", a.type as "argtype", case a.number when 0 then f.func else '' end as "definition" from sys.functions f, sys.schemas s, sys.args a where s.id = f.schema_id and f.id = a.func_id and f.id in (select * from sys.systemfunctions) order by s.name, f.name, f.id, a.number; +% sys.s, sys.f, sys.a, sys.a, sys. # table_name +% schema, function, argno, argtype, definition # name +% varchar, varchar, int, varchar, varchar # type +% 3, 35, 1, 9, 1317 # length +[ "sys", "abbrev", 0, "clob", "create function \"abbrev\" (p inet) returns clob\n\texternal name inet.\"abbrev\";" ] +[ "sys", "abbrev", 1, "inet", "" ] +[ "sys", "alpha", 0, "double", "create function alpha(pdec double, pradius double)\nreturns double external name sql.alpha;" ] +[ "sys", "alpha", 1, "double", "" ] +[ "sys", "alpha", 2, "double", "" ] +[ "sys", "bbp", 0, "table", "-- The BAT buffer pool overview\ncreate function bbp () \n\treturns table (id int, name string, htype string, \n\t\tttype string, count bigint, refcnt int, lrefcnt int, \n\t\tlocation string, heat int, dirty string, \n\t\tstatus string, kind string) \n\texternal name sql.bbp;" ] +[ "sys", "broadcast", 0, "inet", "create function \"broadcast\" (p inet) returns inet \n\texternal name inet.\"broadcast\";" ] +[ "sys", "broadcast", 1, "inet", "" ] +[ "sys", "clients", 0, "table", "-- The contents of this file are subject to the MonetDB Public License\n-- Version 1.1 (the \"License\"); you may not use this file except in\n-- compliance with the License. You may obtain a copy of the License at\n-- http://www.monetdb.org/Legal/MonetDBLicense\n--\n-- Software distributed under the License is distributed on an \"AS IS\"\n-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the\n-- License for the specific language governing rights and limitations\n-- under the License.\n--\n-- The Original Code is the MonetDB Database System.\n--\n-- The Initial Developer of the Original Code is CWI.\n-- Copyright August 2008-2012 MonetDB B.V.\n-- All Rights Reserved.\n\ncreate function clients () \n\treturns table (\"user\" string, login string, lastcommand string,\n\t\t actions int, seconds bigint) \n\texternal name sql.clients;" ] +[ "sys", "cluster1", 0, "clob", "-- The contents of this file are subject to the MonetDB Public License\n-- Version 1.1 (the \"License\"); you may not use this file except in\n-- compliance with the License. You may obtain a copy of the License at\n-- http://www.monetdb.org/Legal/MonetDBLicense\n--\n-- Software distributed under the License is distributed on an \"AS IS\"\n-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the\n-- License for the specific language governing rights and limitations\n-- under the License.\n--\n-- The Original Code is the MonetDB Database System.\n--\n-- The Initial Developer of the Original Code is CWI.\n-- Copyright August 2008-2012 MonetDB B.V.\n-- All Rights Reserved.\n\n-- Clustering a relational table should be done with care.\n-- For, the oid's are used in join-indices.\n\n-- Clustering of tables may improve IO performance\n-- The foreign key constraints should be dropped before\n-- and re-established after the cluster operation.\n\ncreate procedure cluster1(sys string, tab string)\n\texternal name sql.cluster1;" ] +[ "sys", "cluster1", 1, "clob", "" ] +[ "sys", "cluster2", 0, "clob", "create procedure cluster2(sys string, tab string)\n\texternal name sql.cluster2;" ] +[ "sys", "cluster2", 1, "clob", "" ] +[ "sys", "corr", 0, "tinyint", "create aggregate corr(e1 tinyint, e2 tinyint) returns tinyint\n\texternal name \"aggr\".\"corr\";" ] +[ "sys", "corr", 1, "tinyint", "" ] +[ "sys", "corr", 2, "tinyint", "" ] +[ "sys", "corr", 0, "smallint", "create aggregate corr(e1 smallint, e2 smallint) returns smallint\n\texternal name \"aggr\".\"corr\";" ] +[ "sys", "corr", 1, "smallint", "" ] +[ "sys", "corr", 2, "smallint", "" ] +[ "sys", "corr", 0, "int", "create aggregate corr(e1 integer, e2 integer) returns integer\n\texternal name \"aggr\".\"corr\";" ] +[ "sys", "corr", 1, "int", "" ] +[ "sys", "corr", 2, "int", "" ] +[ "sys", "corr", 0, "bigint", "create aggregate corr(e1 bigint, e2 bigint) returns bigint\n\texternal name \"aggr\".\"corr\";" ] +[ "sys", "corr", 1, "bigint", "" ] +[ "sys", "corr", 2, "bigint", "" ] +[ "sys", "corr", 0, "real", "create aggregate corr(e1 real, e2 real) returns real\n\texternal name \"aggr\".\"corr\";" ] +[ "sys", "corr", 1, "real", "" ] +[ "sys", "corr", 2, "real", "" ] +[ "sys", "corr", 0, "double", "create aggregate corr(e1 double, e2 double) returns double\n\texternal name \"aggr\".\"corr\";" ] +[ "sys", "corr", 1, "double", "" ] +[ "sys", "corr", 2, "double", "" ] +[ "sys", "date_to_str", 0, "clob", "create function date_to_str(d date, format string) returns string\n\texternal name mtime.\"date_to_str\";" ] +[ "sys", "date_to_str", 1, "date", "" ] +[ "sys", "date_to_str", 2, "clob", "" ] +[ "sys", "db_users", 0, "table", "CREATE FUNCTION db_users () RETURNS TABLE( name varchar(2048)) EXTERNAL NAME sql.db_users;" ] +[ "sys", "degrees", 0, "double", "-- The contents of this file are subject to the MonetDB Public License\n-- Version 1.1 (the \"License\"); you may not use this file except in\n-- compliance with the License. You may obtain a copy of the License at\n-- http://www.monetdb.org/Legal/MonetDBLicense\n--\n-- Software distributed under the License is distributed on an \"AS IS\"\n-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the\n-- License for the specific language governing rights and limitations\n-- under the License.\n--\n-- The Original Code is the MonetDB Database System.\n--\n-- The Initial Developer of the Original Code is CWI.\n-- Copyright August 2008-2012 MonetDB B.V.\n-- All Rights Reserved.\n\ncreate function degrees(r double) \nreturns double\n\treturn r*180/pi();" ] +[ "sys", "degrees", 1, "double", "" ] +[ "sys", "dependencies_columns_on_functions", 0, "table", "--Column c has a dependency on function f\ncreate function dependencies_columns_on_functions()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select c.name, f.name, 'DEP_FUNC' from functions as f, columns as c, dependencies as dep where c.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7);" ] +[ "sys", "dependencies_columns_on_indexes", 0, "table", "--Column c has a dependency on index i \ncreate function dependencies_columns_on_indexes()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select c.name, i.name, 'DEP_INDEX' from columns as c, objects as kc, idxs as i where kc.\"name\" = c.name and kc.id = i.id and c.table_id = i.table_id and i.name not in (select name from keys));" ] +[ "sys", "dependencies_columns_on_keys", 0, "table", "--Column c has a dependency on key k\ncreate function dependencies_columns_on_keys()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select c.name, k.name, 'DEP_KEY' from columns as c, objects as kc, keys as k where kc.\"name\" = c.name and kc.id = k.id and k.table_id = c.table_id and k.rkey = -1);" ] +[ "sys", "dependencies_columns_on_triggers", 0, "table", "--Column c has a dependency on trigger tri\ncreate function dependencies_columns_on_triggers()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select c.name, tri.name, 'DEP_TRIGGER' from columns as c, triggers as tri, dependencies as dep where dep.id = c.id and dep.depend_id =tri.id and dep.depend_type = 8);" ] +[ "sys", "dependencies_columns_on_views", 0, "table", "--Column c has a dependency on view v\ncreate function dependencies_columns_on_views()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select c.name, v.name, 'DEP_VIEW' from columns as c, tables as v, dependencies as dep where c.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type = 1);" ] +[ "sys", "dependencies_functions_on_functions", 0, "table", "--Function f1 has a dependency on function f2\ncreate function dependencies_functions_on_functions()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select f1.name, f2.name, 'DEP_FUNC' from functions as f1, functions as f2, dependencies as dep where f1.id = dep.id and f2.id = dep.depend_id and dep.depend_type = 7);" ] +[ "sys", "dependencies_functions_os_triggers", 0, "table", "--Function f1 has a dependency on trigger tri\ncreate function dependencies_functions_os_triggers()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select f.name, tri.name, 'DEP_TRIGGER' from functions as f, triggers as tri, dependencies as dep where dep.id = f.id and dep.depend_id =tri.id and dep.depend_type = 8);" ] +[ "sys", "dependencies_keys_on_foreignkeys", 0, "table", "--Key k has a dependency on foreign key fk\ncreate function dependencies_keys_on_foreignkeys()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select k.name, fk.name, 'DEP_FKEY' from keys as k, keys as fk where fk.rkey = k.id);" ] +[ "sys", "dependencies_owners_on_schemas", 0, "table", "--User (owner) has a dependency in schema s\ncreate function dependencies_owners_on_schemas()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select a.name, s.name, 'DEP_SCHEMA' from schemas as s, auths a where s.owner = a.id);" ] +[ "sys", "dependencies_schemas_on_users", 0, "table", "-- The contents of this file are subject to the MonetDB Public License\n-- Version 1.1 (the \"License\"); you may not use this file except in\n-- compliance with the License. You may obtain a copy of the License at\n-- http://www.monetdb.org/Legal/MonetDBLicense\n--\n-- Software distributed under the License is distributed on an \"AS IS\"\n-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the\n-- License for the specific language governing rights and limitations\n-- under the License.\n--\n-- The Original Code is the MonetDB Database System.\n--\n-- The Initial Developer of the Original Code is CWI.\n-- Copyright August 2008-2012 MonetDB B.V.\n-- All Rights Reserved.\n\n--Schema s has a dependency on user u\ncreate function dependencies_schemas_on_users()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select s.name, u.name, 'DEP_USER' from schemas as s, users u where u.default_schema = s.id);" ] +[ "sys", "dependencies_tables_on_foreignkeys", 0, "table", "--Table t has a dependency on foreign key k\ncreate function dependencies_tables_on_foreignkeys()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select t.name, fk.name, 'DEP_FKEY' from tables as t, keys as k, keys as fk where fk.rkey = k.id and k.table_id = t.id);" ] +[ "sys", "dependencies_tables_on_functions", 0, "table", "--Table t has a dependency on function f\ncreate function dependencies_tables_on_functions()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select t.name, f.name, 'DEP_FUNC' from functions as f, tables as t, dependencies as dep where t.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and t.type = 0);" ] +[ "sys", "dependencies_tables_on_indexes", 0, "table", "--Table t has a dependency on index i\ncreate function dependencies_tables_on_indexes()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select t.name, i.name, 'DEP_INDEX' from tables as t, idxs as i where i.table_id = t.id and i.name not in (select name from keys) and t.type = 0);" ] +[ "sys", "dependencies_tables_on_triggers", 0, "table", "--Table t has a dependency on trigger tri\n\ncreate function dependencies_tables_on_triggers()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table ((select t.name, tri.name, 'DEP_TRIGGER' from tables as t, triggers as tri where tri.table_id = t.id) union (select t.name, tri.name, 'DEP_TRIGGER' from triggers tri, tables t, dependencies dep where dep.id = t.id and dep.depend_id =tri.id and dep.depend_type = 8));" ] +[ "sys", "dependencies_tables_on_views", 0, "table", "--Table t has a dependency on view v\ncreate function dependencies_tables_on_views()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select t.name, v.name, 'DEP_VIEW' from tables as t, tables as v, dependencies as dep where t.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type = 1);" ] +[ "sys", "dependencies_views_on_functions", 0, "table", "--View v has a dependency on function f\ncreate function dependencies_views_on_functions()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select v.name, f.name, 'DEP_FUNC' from functions as f, tables as v, dependencies as dep where v.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and v.type = 1);" ] +[ "sys", "dependencies_views_on_triggers", 0, "table", "--View v has a dependency on trigger tri\ncreate function dependencies_views_on_triggers()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select v.name, tri.name, 'DEP_TRIGGER' from tables as v, triggers as tri, dependencies as dep where dep.id = v.id and dep.depend_id =tri.id and dep.depend_type = 8 and v.type = 1);" ] +[ "sys", "dropdictionary", 0, "clob", "create procedure dropdictionary (s string, t string)\n external name sql.dropdictionary;" ] +[ "sys", "dropdictionary", 1, "clob", "" ] +[ "sys", "env", 0, "table", "CREATE FUNCTION env () RETURNS TABLE( name varchar(1024), value varchar(2048)) EXTERNAL NAME sql.sql_environment;" ] +[ "sys", "environment", 0, "table", "-- The environment table\ncreate function environment()\n\treturns table (\"name\" string, value string)\n\texternal name sql.sql_environment;" ] +[ "sys", "evalalgebra", 0, "clob", "create procedure evalalgebra( ra_stmt string, opt bool)\n\texternal name sql.\"evalAlgebra\";" ] +[ "sys", "evalalgebra", 1, "boolean", "" ] +[ "sys", "fuse", 0, "smallint", "-- fuse two (1-byte) tinyint values into one (2-byte) smallint value\ncreate function fuse(one tinyint, two tinyint)\nreturns smallint external name udf.fuse;" ] +[ "sys", "fuse", 1, "tinyint", "" ] +[ "sys", "fuse", 2, "tinyint", "" ] +[ "sys", "fuse", 0, "int", "-- fuse two (2-byte) smallint values into one (4-byte) integer value\ncreate function fuse(one smallint, two smallint)\nreturns integer external name udf.fuse;" ] +[ "sys", "fuse", 1, "smallint", "" ] +[ "sys", "fuse", 2, "smallint", "" ] +[ "sys", "fuse", 0, "bigint", "-- fuse two (4-byte) integer values into one (8-byte) bigint value\ncreate function fuse(one integer, two integer)\nreturns bigint external name udf.fuse;" ] +[ "sys", "fuse", 1, "int", "" ] +[ "sys", "fuse", 2, "int", "" ] +[ "sys", "getanchor", 0, "clob", "create function getanchor( theurl url ) returns string \n\texternal name url.\"getAnchor\";" ] +[ "sys", "getanchor", 1, "url", "" ] +[ "sys", "getbasename", 0, "clob", "create function getbasename(theurl url) returns string \n\texternal name url.\"getBasename\";" ] +[ "sys", "getbasename", 1, "url", "" ] +[ "sys", "getcontent", 0, "clob", "create function getcontent(theurl url) returns string \n\texternal name url.\"getContent\";" ] +[ "sys", "getcontent", 1, "url", "" ] +[ "sys", "getcontext", 0, "clob", "create function getcontext(theurl url) returns string \n\texternal name url.\"getContext\";" ] +[ "sys", "getcontext", 1, "url", "" ] +[ "sys", "getdomain", 0, "clob", "create function getdomain(theurl url) returns string \n\texternal name url.\"getDomain\";" ] +[ "sys", "getdomain", 1, "url", "" ] +[ "sys", "getextension", 0, "clob", "create function getextension(theurl url) returns string \n\texternal name url.\"getExtension\";" ] +[ "sys", "getextension", 1, "url", "" ] +[ "sys", "getfile", 0, "clob", "create function getfile(theurl url) returns string \n\texternal name url.\"getFile\";" ] +[ "sys", "getfile", 1, "url", "" ] +[ "sys", "gethost", 0, "clob", "create function gethost(theurl url) returns string \n\texternal name url.\"getHost\";" ] +[ "sys", "gethost", 1, "url", "" ] +[ "sys", "getport", 0, "clob", "create function getport(theurl url) returns string \n\texternal name url.\"getPort\";" ] +[ "sys", "getport", 1, "url", "" ] +[ "sys", "getprotocol", 0, "clob", "create function getprotocol(theurl url) returns string \n\texternal name url.\"getProtocol\";" ] +[ "sys", "getprotocol", 1, "url", "" ] +[ "sys", "getquery", 0, "clob", "create function getquery(theurl url) returns string \n\texternal name url.\"getQuery\";" ] +[ "sys", "getquery", 1, "url", "" ] +[ "sys", "getroboturl", 0, "clob", "create function getroboturl(theurl url) returns string \n\texternal name url.\"getRobotURL\";" ] +[ "sys", "getroboturl", 1, "url", "" ] +[ "sys", "getuser", 0, "clob", "create function getuser(theurl url) returns string \n\texternal name url.\"getUser\";" ] +[ "sys", "getuser", 1, "url", "" ] +[ "sys", "gzcompress", 0, "clob", "-- The contents of this file are subject to the MonetDB Public License\n-- Version 1.1 (the \"License\"); you may not use this file except in\n-- compliance with the License. You may obtain a copy of the License at\n-- http://www.monetdb.org/Legal/MonetDBLicense\n--\n-- Software distributed under the License is distributed on an \"AS IS\"\n-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the\n-- License for the specific language governing rights and limitations\n-- under the License.\n--\n-- The Original Code is the MonetDB Database System.\n--\n-- The Initial Developer of the Original Code is CWI.\n-- Copyright August 2008-2012 MonetDB B.V.\n-- All Rights Reserved.\n\n-- Perform LZ-compression over a specific table;\ncreate procedure gzcompress (s string, t string)\n external name sql.gzcompress;" ] +[ "sys", "gzcompress", 1, "clob", "" ] +[ "sys", "gzdecompress", 0, "clob", "create procedure gzdecompress (s string, t string)\n external name sql.gzdecompress;" ] +[ "sys", "gzdecompress", 1, "clob", "" ] +[ "sys", "gzexpand", 0, "clob", "-- Remove the compressed images\ncreate procedure gzexpand (s string, t string)\n external name sql.gzexpand;" ] +[ "sys", "gzexpand", 1, "clob", "" ] +[ "sys", "gztruncate", 0, "clob", "-- Truncate the storage for columns with a compressed image\ncreate procedure gztruncate (s string, t string)\n external name sql.gztruncate;" ] +[ "sys", "gztruncate", 1, "clob", "" ] +[ "sys", "host", 0, "clob", "create function \"host\" (p inet) returns clob\n\texternal name inet.\"host\";" ] +[ "sys", "host", 1, "inet", "" ] +[ "sys", "hostmask", 0, "inet", "create function \"hostmask\" (p inet) returns inet\n\texternal name inet.\"hostmask\";" ] +[ "sys", "hostmask", 1, "inet", "" ] +[ "sys", "ilike", 0, "clob", "create filter function \"ilike\"(val string, pat string, esc string) external name pcre.ilike_filter;" ] +[ "sys", "ilike", 1, "clob", "" ] +[ "sys", "ilike", 2, "clob", "" ] +[ "sys", "isaurl", 0, "boolean", "create function isaurl(theurl url) returns bool\n\texternal name url.\"isaURL\";" ] +[ "sys", "isaurl", 1, "url", "" ] +[ "sys", "keepcall", 0, "wrd", "-- the signature is used in the kernel, don't change it\ncreate procedure keepcall(\n\tid wrd, \t\t\t-- references query plan\n\tctime timestamp,\t-- time the first statement was executed\n\targuments string,\n\txtime bigint,\t\t-- time from the first statement until result export\n\trtime bigint,\t\t-- time to ship the result to the client\n\tfoot bigint, \t\t-- footprint for all bats in the plan\n\tmemory bigint,\t\t-- storage size of intermediates created\n\ttuples wrd,\t\t\t-- number of tuples in the result set\n\tinblock bigint,\t\t-- number of physical blocks read\n\toublock bigint\t\t-- number of physical blocks written\n)\nbegin\n\tinsert into callhistory\n\tvalues( id, ctime, arguments, xtime, rtime, \n\t\tfoot, memory, tuples, inblock, oublock );\nend;" ] +[ "sys", "keepcall", 1, "timestamp", "" ] +[ "sys", "keepcall", 2, "clob", "" ] +[ "sys", "keepcall", 3, "bigint", "" ] +[ "sys", "keepcall", 4, "bigint", "" ] +[ "sys", "keepcall", 5, "bigint", "" ] +[ "sys", "keepcall", 6, "bigint", "" ] +[ "sys", "keepcall", 7, "wrd", "" ] +[ "sys", "keepcall", 8, "bigint", "" ] +[ "sys", "keepcall", 9, "bigint", "" ] +[ "sys", "keepquery", 0, "wrd", "-- the signature is used in the kernel, don't change it\ncreate procedure keepquery(\n\ti wrd,\n\tquery string,\n\tparse bigint,\n\toptimize bigint) \nbegin\n\tinsert into queryhistory\n\tvalues(i, now(), user, query, parse, optimize);\nend;" ] +[ "sys", "keepquery", 1, "clob", "" ] +[ "sys", "keepquery", 2, "bigint", "" ] +[ "sys", "keepquery", 3, "bigint", "" ] +[ "sys", "like", 0, "clob", "create filter function \"like\"(val string, pat string, esc string) external name pcre.like_filter;" ] +[ "sys", "like", 1, "clob", "" ] +[ "sys", "like", 2, "clob", "" ] +[ "sys", "masklen", 0, "int", "create function \"masklen\" (p inet) returns int\n\texternal name inet.\"masklen\";" ] +[ "sys", "masklen", 1, "inet", "" ] +[ "sys", "median", 0, "tinyint", "\ncreate aggregate median(val tinyint) returns tinyint\n\texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "tinyint", "" ] +[ "sys", "median", 0, "smallint", "create aggregate median(val smallint) returns smallint\n\texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "smallint", "" ] +[ "sys", "median", 0, "int", "create aggregate median(val integer) returns integer\n\texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "int", "" ] +[ "sys", "median", 0, "bigint", "create aggregate median(val bigint) returns bigint\n\texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "bigint", "" ] +[ "sys", "median", 0, "real", "create aggregate median(val real) returns real\n\texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "real", "" ] +[ "sys", "median", 0, "double", "create aggregate median(val double) returns double\n\texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "double", "" ] +[ "sys", "median", 0, "date", "create aggregate median(val date) returns date\n\texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "date", "" ] +[ "sys", "median", 0, "time", "create aggregate median(val time) returns time\n\texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "time", "" ] +[ "sys", "median", 0, "timestamp", "create aggregate median(val timestamp) returns timestamp\n\texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "timestamp", "" ] +[ "sys", "ms_round", 0, "double", "create function ms_round(num double, prc int, truncat int)\nreturns double\nbegin\n\tif (truncat = 0)\n\t\tthen return round(num, prc);\n\t\telse return ms_trunc(num, prc);\n\tend if;\nend;" ] +[ "sys", "ms_round", 1, "double", "" ] +[ "sys", "ms_round", 2, "int", "" ] +[ "sys", "ms_round", 3, "int", "" ] +[ "sys", "ms_str", 0, "clob", "create function ms_str(num float, prc int, truncat int)\nreturns string\nbegin\n return cast(num as string);\nend;" ] +[ "sys", "ms_str", 1, "double", "" ] +[ "sys", "ms_str", 2, "int", "" ] +[ "sys", "ms_str", 3, "int", "" ] +[ "sys", "ms_stuff", 0, "varchar", "-- The contents of this file are subject to the MonetDB Public License\n-- Version 1.1 (the \"License\"); you may not use this file except in\n-- compliance with the License. You may obtain a copy of the License at\n-- http://www.monetdb.org/Legal/MonetDBLicense\n--\n-- Software distributed under the License is distributed on an \"AS IS\"\n-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the\n-- License for the specific language governing rights and limitations\n-- under the License.\n--\n-- The Original Code is the MonetDB Database System.\n--\n-- The Initial Developer of the Original Code is CWI.\n-- Copyright August 2008-2012 MonetDB B.V.\n-- All Rights Reserved.\n\ncreate function ms_stuff( s1 varchar(32), st int, len int, s3 varchar(32))\nreturns varchar(32)\nbegin\n\tdeclare res varchar(32), aux varchar(32);\n\tdeclare ofset int;\n\n if ( st < 0 or st > length(s1))\n then return '';\n end if;\n\n set ofset = 1;\n set res = substring(s1,ofset,st-1);\n set res = res || s3;\n set ofset = st + len;\n set aux = substring(s1,ofset,length(s1)-ofset+1);\n\tset res = res || aux;\n\treturn res;\nend;" ] +[ "sys", "ms_stuff", 1, "varchar", "" ] +[ "sys", "ms_stuff", 2, "int", "" ] +[ "sys", "ms_stuff", 3, "int", "" ] +[ "sys", "ms_stuff", 4, "varchar", "" ] +[ "sys", "ms_trunc", 0, "double", "create function ms_trunc(num double, prc int)\nreturns double\nexternal name sql.ms_trunc;" ] +[ "sys", "ms_trunc", 1, "double", "" ] +[ "sys", "ms_trunc", 2, "int", "" ] +[ "sys", "netmask", 0, "inet", "create function \"netmask\" (p inet) returns inet\n\texternal name inet.\"netmask\";" ] +[ "sys", "netmask", 1, "inet", "" ] +[ "sys", "network", 0, "inet", "create function \"network\" (p inet) returns inet\n\texternal name inet.\"network\";" ] +[ "sys", "network", 1, "inet", "" ] +[ "sys", "newdictionary", 0, "clob", "-- The contents of this file are subject to the MonetDB Public License\n-- Version 1.1 (the \"License\"); you may not use this file except in\n-- compliance with the License. You may obtain a copy of the License at\n-- http://www.monetdb.org/Legal/MonetDBLicense\n--\n-- Software distributed under the License is distributed on an \"AS IS\"\n-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the\n-- License for the specific language governing rights and limitations\n-- under the License.\n--\n-- The Original Code is the MonetDB Database System.\n--\n-- The Initial Developer of the Original Code is CWI.\n-- Copyright August 2008-2012 MonetDB B.V.\n-- All Rights Reserved.\n\ncreate procedure newdictionary (s string, t string)\n external name sql.newdictionary;" ] +[ "sys", "newdictionary", 1, "clob", "" ] +[ "sys", "newurl", 0, "url", "create function newurl(protocol string, hostname string, \"port\" int, file string) \n\treturns url \n\texternal name url.\"new\";" ] +[ "sys", "newurl", 1, "clob", "" ] +[ "sys", "newurl", 2, "clob", "" ] +[ "sys", "newurl", 3, "int", "" ] +[ "sys", "newurl", 4, "clob", "" ] +[ "sys", "newurl", 0, "url", "create function newurl(protocol string, hostname string, file string) \n\treturns url \n\texternal name url.\"new\";" ] _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
