Changeset: 39ecabef4d57 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=39ecabef4d57 Added Files: sql/test/Tests/systemfunctions.sql sql/test/Tests/systemfunctions.stable.err sql/test/Tests/systemfunctions.stable.out Modified Files: sql/test/Tests/All Branch: Apr2012 Log Message:
Added test to check availability and type of system functions. diffs (truncated from 435 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,3 +1,4 @@ +systemfunctions example example-queries example-drop diff --git a/sql/test/Tests/systemfunctions.sql b/sql/test/Tests/systemfunctions.sql new file mode 100644 --- /dev/null +++ b/sql/test/Tests/systemfunctions.sql @@ -0,0 +1,1 @@ +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; diff --git a/sql/test/Tests/systemfunctions.stable.err b/sql/test/Tests/systemfunctions.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/Tests/systemfunctions.stable.err @@ -0,0 +1,37 @@ +stderr of test 'systemfunctions` 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.stable.out b/sql/test/Tests/systemfunctions.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/Tests/systemfunctions.stable.out @@ -0,0 +1,374 @@ +stdout of test 'systemfunctions` 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: 40_geom.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, 15, 1317 # length +[ "sys", "Intersect", 0, "boolean", "create function \"Intersect\"(a geometry, b geometry) returns boolean external name geom.\"Intersect\";" ] +[ "sys", "Intersect", 1, "geometry", "" ] +[ "sys", "Intersect", 2, "geometry", "" ] +[ "sys", "Union", 0, "geometry", "create function \"Union\"(a geometry, b geometry) returns geometry external name geom.\"Union\";" ] +[ "sys", "Union", 1, "geometry", "" ] +[ "sys", "Union", 2, "geometry", "" ] +[ "sys", "abbrev", 0, "clob", "create function \"abbrev\" (p inet) returns clob\n\texternal name inet.\"abbrev\";" ] +[ "sys", "abbrev", 1, "inet", "" ] +[ "sys", "area", 0, "double", "-- ogc Spatial Analysis methods\n\ncreate function area(g geometry) returns float external name geom.\"Area\";" ] +[ "sys", "area", 1, "geometry", "" ] +[ "sys", "astext", 0, "clob", "create function astext(g geometry) returns string external name geom.\"AsText\";" ] +[ "sys", "astext", 1, "geometry", "" ] +[ "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", "boundary", 0, "geometry", "create function boundary(g geometry) returns geometry external name geom.\"Boundary\";" ] +[ "sys", "boundary", 1, "geometry", "" ] +[ "sys", "broadcast", 0, "inet", "create function \"broadcast\" (p inet) returns inet \n\texternal name inet.\"broadcast\";" ] +[ "sys", "broadcast", 1, "inet", "" ] +[ "sys", "buffer", 0, "geometry", "create function buffer(a geometry, distance float) returns geometry external name geom.\"Buffer\";" ] +[ "sys", "buffer", 1, "geometry", "" ] +[ "sys", "buffer", 2, "double", "" ] +[ "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", "contains", 0, "boolean", "create function contains(a geometry, b geometry) returns boolean external name geom.\"Contains\";" ] +[ "sys", "contains", 1, "geometry", "" ] +[ "sys", "contains", 2, "geometry", "" ] +[ "sys", "convexhull", 0, "geometry", "create function convexhull(a geometry) returns geometry external name geom.\"ConvexHull\";" ] +[ "sys", "convexhull", 1, "geometry", "" ] +[ "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", "crosses", 0, "boolean", "create function crosses(a geometry, b geometry) returns boolean external name geom.\"Crosses\";" ] +[ "sys", "crosses", 1, "geometry", "" ] +[ "sys", "crosses", 2, "geometry", "" ] +[ "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", "difference", 0, "geometry", "create function difference(a geometry, b geometry) returns geometry external name geom.\"Difference\";" ] +[ "sys", "difference", 1, "geometry", "" ] +[ "sys", "difference", 2, "geometry", "" ] +[ "sys", "dimension", 0, "int", "-- CREATE FUNCTION Point(g Geometry) RETURNS Point external name geom.point;\n-- CREATE FUNCTION Curve(g Geometry) RETURNS Curve external name geom.curve;\n-- CREATE FUNCTION LineString(g Geometry) RETURNS LineString external name geom.linestring;\n-- CREATE FUNCTION Surface(g Geometry) RETURNS Surface external name geom.surface;\n-- CREATE FUNCTION Polygon(g Geometry) RETURNS Polygon external name geom.polygon;\n\n-- ogc basic methods\ncreate function dimension(g geometry) returns integer external name geom.\"Dimension\";" ] +[ "sys", "dimension", 1, "geometry", "" ] +[ "sys", "disjoint", 0, "boolean", "create function disjoint(a geometry, b geometry) returns boolean external name geom.\"Disjoint\";" ] +[ "sys", "disjoint", 1, "geometry", "" ] +[ "sys", "disjoint", 2, "geometry", "" ] +[ "sys", "distance", 0, "double", "create function distance(a geometry, b geometry) returns float external name geom.\"Distance\";" ] +[ "sys", "distance", 1, "geometry", "" ] +[ "sys", "distance", 2, "geometry", "" ] +[ "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", "envelope", 0, "geometry", "create function envelope(g geometry) returns geometry external name geom.\"Envelope\";" ] +[ "sys", "envelope", 1, "geometry", "" ] +[ "sys", "environment", 0, "table", "-- The environment table\ncreate function environment()\n\treturns table (\"name\" string, value string)\n\texternal name sql.sql_environment;" ] +[ "sys", "equals", 0, "boolean", "-- ogc spatial relation methods\ncreate function equals(a geometry, b geometry) returns boolean external name geom.\"Equals\";" ] +[ "sys", "equals", 1, "geometry", "" ] +[ "sys", "equals", 2, "geometry", "" ] +[ "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", "geomcollectionfromtext", 0, "multipolygon", "create function geomcollectionfromtext(wkt string, srid smallint) returns multipolygon external name geom.\"GeomCollectionFromText\";" ] +[ "sys", "geomcollectionfromtext", 1, "clob", "" ] +[ "sys", "geomcollectionfromtext", 2, "smallint", "" ] +[ "sys", "geometrytypeid", 0, "int", "create function geometrytypeid(g geometry) returns integer external name geom.\"GeometryTypeId\";" ] +[ "sys", "geometrytypeid", 1, "geometry", "" ] +[ "sys", "geomfromtext", 0, "geometry", "-- The srid in the *FromText Functions is currently not used\ncreate function geomfromtext(wkt string, srid smallint) returns geometry external name geom.\"GeomFromText\";" ] +[ "sys", "geomfromtext", 1, "clob", "" ] +[ "sys", "geomfromtext", 2, "smallint", "" ] +[ "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", "intersection", 0, "geometry", "create function intersection(a geometry, b geometry) returns geometry external name geom.\"Intersection\";" ] +[ "sys", "intersection", 1, "geometry", "" ] +[ "sys", "intersection", 2, "geometry", "" ] +[ "sys", "isaurl", 0, "boolean", "create function isaurl(theurl url) returns bool\n\texternal name url.\"isaURL\";" ] +[ "sys", "isaurl", 1, "url", "" ] +[ "sys", "isempty", 0, "boolean", "create function isempty(g geometry) returns boolean external name geom.\"IsEmpty\";" ] +[ "sys", "isempty", 1, "geometry", "" ] +[ "sys", "issimple", 0, "boolean", "create function issimple(g geometry) returns boolean external name geom.\"IsSimple\";" ] +[ "sys", "issimple", 1, "geometry", "" ] +[ "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", "length", 0, "double", "create function length(g geometry) returns float external name geom.\"Length\";" ] +[ "sys", "length", 1, "geometry", "" ] +[ "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", "linefromtext", 0, "linestring", "create function linefromtext(wkt string, srid smallint) returns linestring external name geom.\"LineFromText\";" ] +[ "sys", "linefromtext", 1, "clob", "" ] +[ "sys", "linefromtext", 2, "smallint", "" ] +[ "sys", "masklen", 0, "int", "create function \"masklen\" (p inet) returns int\n\texternal name inet.\"masklen\";" ] +[ "sys", "masklen", 1, "inet", "" ] _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
