Changeset: 6877c50944a9 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6877c50944a9 Added Files: sql/test/Tests/systemfunctions_gsl.sql.src sql/test/Tests/systemfunctions_gsl.stable.err sql/test/Tests/systemfunctions_gsl.stable.out sql/test/leaks/Tests/check0_gsl.sql.src sql/test/leaks/Tests/check0_gsl.stable.err sql/test/leaks/Tests/check0_gsl.stable.out sql/test/leaks/Tests/check1_gsl.sql.src sql/test/leaks/Tests/check1_gsl.stable.err sql/test/leaks/Tests/check1_gsl.stable.out sql/test/leaks/Tests/check2_gsl.sql.src sql/test/leaks/Tests/check2_gsl.stable.err sql/test/leaks/Tests/check2_gsl.stable.out sql/test/leaks/Tests/check3_gsl.sql.src sql/test/leaks/Tests/check3_gsl.stable.err sql/test/leaks/Tests/check3_gsl.stable.out sql/test/leaks/Tests/check4_gsl.sql.src sql/test/leaks/Tests/check4_gsl.stable.err sql/test/leaks/Tests/check4_gsl.stable.out sql/test/leaks/Tests/check5_gsl.sql.src sql/test/leaks/Tests/check5_gsl.stable.err sql/test/leaks/Tests/check5_gsl.stable.out sql/test/leaks/Tests/drop3_gsl.sql.src sql/test/leaks/Tests/drop3_gsl.stable.err sql/test/leaks/Tests/drop3_gsl.stable.out sql/test/leaks/Tests/select1_gsl.sql.src sql/test/leaks/Tests/select1_gsl.stable.err sql/test/leaks/Tests/select1_gsl.stable.out sql/test/leaks/Tests/select2_gsl.sql.src sql/test/leaks/Tests/select2_gsl.stable.err sql/test/leaks/Tests/select2_gsl.stable.out sql/test/leaks/Tests/temp1_gsl.sql.src sql/test/leaks/Tests/temp1_gsl.stable.err sql/test/leaks/Tests/temp1_gsl.stable.out sql/test/leaks/Tests/temp2_gsl.sql.src sql/test/leaks/Tests/temp2_gsl.stable.err sql/test/leaks/Tests/temp2_gsl.stable.out sql/test/leaks/Tests/temp3_gsl.sql.src sql/test/leaks/Tests/temp3_gsl.stable.err sql/test/leaks/Tests/temp3_gsl.stable.out Modified Files: sql/test/Tests/All sql/test/leaks/Tests/All testing/Mtest.py.in Branch: default Log Message:
Merge with Jan2014 branch. diffs (truncated from 2763 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,5 +1,6 @@ -HAVE_GEOM?systemfunctions -!HAVE_GEOM?systemfunctions_nogeom +HAVE_GEOM&!HAVE_GSL?systemfunctions +HAVE_GEOM&HAVE_GSL?systemfunctions_gsl +!HAVE_GEOM&!HAVE_GSL?systemfunctions_nogeom example example-queries example-drop diff --git a/sql/test/Tests/systemfunctions_gsl.sql.src b/sql/test/Tests/systemfunctions_gsl.sql.src new file mode 100644 --- /dev/null +++ b/sql/test/Tests/systemfunctions_gsl.sql.src @@ -0,0 +1,1 @@ +$RELSRCDIR/systemfunctions.sql diff --git a/sql/test/Tests/systemfunctions_gsl.stable.err b/sql/test/Tests/systemfunctions_gsl.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/Tests/systemfunctions_gsl.stable.err @@ -0,0 +1,35 @@ +stderr of test 'systemfunctions_gsl` in directory 'sql/test` itself: + + +# 16:20:24 > +# 16:20:24 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36066" "--set" "mapi_usock=/var/tmp/mtest-26153/.s.monetdb.36066" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/sjoerd/Monet-candidate/var/MonetDB/mTests_sql_test" "--set" "mal_listing=0" +# 16:20:24 > + +# builtin opt gdk_dbpath = /ufs/sjoerd/Monet-candidate/var/monetdb5/dbfarm/demo +# builtin opt gdk_debug = 0 +# 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 mapi_open = true +# cmdline opt mapi_port = 36066 +# cmdline opt mapi_usock = /var/tmp/mtest-26153/.s.monetdb.36066 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbpath = /ufs/sjoerd/Monet-candidate/var/MonetDB/mTests_sql_test +# cmdline opt mal_listing = 0 + +# 16:20:25 > +# 16:20:25 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-26153" "--port=36066" +# 16:20:25 > + + +# 16:20:25 > +# 16:20:25 > "Done." +# 16:20:25 > + diff --git a/sql/test/Tests/systemfunctions_gsl.stable.out b/sql/test/Tests/systemfunctions_gsl.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/Tests/systemfunctions_gsl.stable.out @@ -0,0 +1,566 @@ +stdout of test 'systemfunctions_gsl` in directory 'sql/test` itself: + + +# 16:20:24 > +# 16:20:24 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36066" "--set" "mapi_usock=/var/tmp/mtest-26153/.s.monetdb.36066" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/sjoerd/Monet-candidate/var/MonetDB/mTests_sql_test" "--set" "mal_listing=0" +# 16:20:24 > + +# MonetDB 5 server v11.17.0 (hg id: d91089635868) +# This is an unreleased version +# Serving database 'mTests_sql_test', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 15.591 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2013 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:36066/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-26153/.s.monetdb.36066 +# MonetDB/GIS module loaded +# MonetDB/JAQL 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_querylog.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: 26_sysmon.sql +# loading sql script: 39_analytics.sql +# loading sql script: 40_geom.sql +# loading sql script: 40_json.sql +# loading sql script: 41_jsonstore.sql +# loading sql script: 45_uuid.sql +# loading sql script: 46_gsl.sql +# loading sql script: 75_storagemodel.sql +# loading sql script: 80_statistics.sql +# loading sql script: 80_udf.sql +# loading sql script: 99_system.sql + +# 16:20:25 > +# 16:20:25 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-26153" "--port=36066" +# 16:20:25 > + +#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.L3, sys.L3, sys.L3, sys.L3, sys.L3 # table_name +% schema, function, argno, argtype, definition # name +% varchar, varchar, int, varchar, varchar # type +% 3, 35, 1, 15, 1582 # 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", "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", "analyze", 0, "clob", "create procedure analyze(tbl string)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 0, "clob", "create procedure analyze(sch string, tbl string)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 1, "clob", "" ] +[ "sys", "analyze", 0, "clob", "create procedure analyze(sch string, tbl string, col string)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 1, "clob", "" ] +[ "sys", "analyze", 2, "clob", "" ] +[ "sys", "analyze", 0, "bigint", "-- control the sample size\ncreate procedure analyze(\"sample\" bigint)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 0, "clob", "create procedure analyze(tbl string, \"sample\" bigint)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 1, "bigint", "" ] +[ "sys", "analyze", 0, "clob", "create procedure analyze(sch string, tbl string, \"sample\" bigint)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 1, "clob", "" ] +[ "sys", "analyze", 2, "bigint", "" ] +[ "sys", "analyze", 0, "clob", "create procedure analyze(sch string, tbl string, col string, \"sample\" bigint)\nexternal name sql.analyze;" ] +[ "sys", "analyze", 1, "clob", "" ] +[ "sys", "analyze", 2, "clob", "" ] +[ "sys", "analyze", 3, "bigint", "" ] +[ "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 sys.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", "chi2prob", 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-2013 MonetDB B.V.\n-- All Rights Reserved.\n\n-- (co) Arjen de Rijke, Bart Scheers\n-- Use statistical functions from gsl library\n\n-- Calculate Chi squared probability\ncreate function sys.chi2prob(chi2 double, datapoints double)\nreturns double external name gsl.\"chi2prob\";" ] +[ "sys", "chi2prob", 1, "double", "" ] +[ "sys", "chi2prob", 2, "double", "" ] +[ "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-2013 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 operatio n.\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", "columnsize", 0, "bigint", "-- The predicted storage footprint of the complete database\n-- determines the amount of diskspace needed for persistent storage\n-- and the upperbound when all possible index structures are created.\n-- The storage requirement for foreign key joins is split amongst the participants.\n\ncreate function sys.columnsize(nme string, i bigint, d bigint)\nreturns bigint\nbegin\n\tcase\n\twhen nme = 'boolean' then return i;\n\twhen nme = 'char' then return 2*i;\n\twhen nme = 'smallint' then return 2 * i;\n\twhen nme = 'int'\t then return 4 * i;\n\twhen nme = 'bigint'\t then return 8 * i;\n\twhen nme = 'timestamp' then return 8 * i;\n\twhen nme = 'varchar' then\n\t\tcase\n\t\twhen cast(d as bigint) << 8 then return i;\n\t\twhen cast(d as bigint) << 16 then return 2 * i;\n\t\twhen cast(d as bigint) << 32 then return 4 * i;\n\t\telse return 8 * i;\n\t\tend case;\n\telse return 8 * i;\n\tend case;\nend;" ] +[ "sys", "columnsize", 1, "clob", "" ] +[ "sys", "columnsize", 2, "bigint", "" ] +[ "sys", "columnsize", 3, "bigint", "" ] +[ "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, "wrd", "create aggregate corr(e1 wrd, e2 wrd) returns wrd\n\texternal name \"aggr\".\"corr\";" ] +[ "sys", "corr", 1, "wrd", "" ] +[ "sys", "corr", 2, "wrd", "" ] +[ "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-2013 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-2013 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 sys.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 sys.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-2013 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", "heapsize", 0, "bigint", "create function sys.heapsize(tpe string, i bigint, w int)\nreturns bigint\nbegin\n\tif tpe <> 'varchar' and tpe <> 'clob'\n\tthen\n\t\treturn 0;\n\tend if;\n\treturn 10240 + i * w;\nend;" ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
