Changeset: ed53d5c80740 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ed53d5c80740 Added Files: sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.sql.src sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.out 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 sql/test/leaks/Tests/check0_nogeom.sql.src sql/test/leaks/Tests/check0_nogeom.stable.err sql/test/leaks/Tests/check0_nogeom.stable.out sql/test/leaks/Tests/check1_nogeom.sql.src sql/test/leaks/Tests/check1_nogeom.stable.err sql/test/leaks/Tests/check1_nogeom.stable.out sql/test/leaks/Tests/check2_nogeom.sql.src sql/test/leaks/Tests/check2_nogeom.stable.err sql/test/leaks/Tests/check2_nogeom.stable.out sql/test/leaks/Tests/check3_nogeom.sql.src sql/test/leaks/Tests/check3_nogeom.stable.err sql/test/leaks/Tests/check3_nogeom.stable.out sql/test/leaks/Tests/check4_nogeom.sql.src sql/test/leaks/Tests/check4_nogeom.stable.err sql/test/leaks/Tests/check4_nogeom.stable.out sql/test/leaks/Tests/check5_nogeom.sql.src sql/test/leaks/Tests/check5_nogeom.stable.err sql/test/leaks/Tests/check5_nogeom.stable.out sql/test/leaks/Tests/drop3_nogeom.sql.src sql/test/leaks/Tests/drop3_nogeom.stable.err sql/test/leaks/Tests/drop3_nogeom.stable.out sql/test/leaks/Tests/select1_nogeom.sql.src sql/test/leaks/Tests/select1_nogeom.stable.err sql/test/leaks/Tests/select1_nogeom.stable.out sql/test/leaks/Tests/select2_nogeom.sql.src sql/test/leaks/Tests/select2_nogeom.stable.err sql/test/leaks/Tests/select2_nogeom.stable.out sql/test/leaks/Tests/temp1_nogeom.sql.src sql/test/leaks/Tests/temp1_nogeom.stable.err sql/test/leaks/Tests/temp1_nogeom.stable.out sql/test/leaks/Tests/temp2_nogeom.sql.src sql/test/leaks/Tests/temp2_nogeom.stable.err sql/test/leaks/Tests/temp2_nogeom.stable.out sql/test/leaks/Tests/temp3_nogeom.sql.src sql/test/leaks/Tests/temp3_nogeom.stable.err sql/test/leaks/Tests/temp3_nogeom.stable.out sql/test/mapi/Tests/php_monetdb_nogeom.SQL.bat sql/test/mapi/Tests/php_monetdb_nogeom.SQL.sh sql/test/mapi/Tests/php_monetdb_nogeom.stable.err sql/test/mapi/Tests/php_monetdb_nogeom.stable.out Modified Files: sql/test/BugTracker-2012/Tests/All sql/test/Tests/All sql/test/leaks/Tests/All sql/test/mapi/Tests/All sql/test/testdb-upgrade-chain/Tests/All sql/test/testdb-upgrade/Tests/All testing/Mtest.py.in Branch: default Log Message:
Merge with Oct2012 branch. diffs (truncated from 2620 to 300 lines): diff --git a/sql/test/BugTracker-2012/Tests/All b/sql/test/BugTracker-2012/Tests/All --- a/sql/test/BugTracker-2012/Tests/All +++ b/sql/test/BugTracker-2012/Tests/All @@ -40,7 +40,8 @@ bug_large-insert-Bug.2960 any_null.Bug-2594 float-mod.Bug-3086 aggregate_vs_positional_column_crash.Bug-3085 -predicate_select.Bug-3090 +HAVE_GEOM?predicate_select.Bug-3090 +!HAVE_GEOM?predicate_select.Bug-3090_nogeom hash_join_crash.Bug-3089 row-number-nyi.Bug-3087 insert_serial_with_unique_key.Bug-3091 diff --git a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.sql.src b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.sql.src new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.sql.src @@ -0,0 +1,1 @@ +$RELSRCDIR/predicate_select.Bug-3090.sql diff --git a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err @@ -0,0 +1,40 @@ +stderr of test 'predicate_select.Bug-3090_nogeom` in directory 'test/BugTracker-2012` itself: + + +# 18:53:13 > +# 18:53:13 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=32323" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_test_BugTracker-2012" "--set" "mal_listing=0" +# 18:53:13 > + +# builtin opt gdk_dbname = demo +# builtin opt gdk_dbfarm = /home/niels/scratch/rc-clean/Linux-x86_64/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 = /home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 32323 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbname = mTests_test_BugTracker-2012 +# cmdline opt mal_listing = 0 + +# 18:53:13 > +# 18:53:13 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=niels" "--port=32323" +# 18:53:13 > + +MAPI = monetdb@sofia:39129 +QUERY = select * from tables where name; +ERROR = !conversion from string to type bit failed. + +# 18:53:13 > +# 18:53:13 > "Done." +# 18:53:13 > + diff --git a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.out b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.out @@ -0,0 +1,66 @@ +stdout of test 'predicate_select.Bug-3090_nogeom` in directory 'test/BugTracker-2012` itself: + + +# 18:53:13 > +# 18:53:13 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=32323" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_test_BugTracker-2012" "--set" "mal_listing=0" +# 18:53:13 > + +# MonetDB 5 server v11.9.2 +# This is an unreleased version +# Serving database 'mTests_test_BugTracker-2012', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 3.778 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://niels.nesco.mine.nu:32323/ +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 18:53:13 > +# 18:53:13 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=niels" "--port=32323" +# 18:53:13 > + +#select * from tables where 1; +% .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables # table_name +% id, name, schema_id, query, type, system, commit_action, readonly, temporary # name +% int, varchar, int, varchar, smallint, boolean, smallint, boolean, tinyint # type +% 4, 15, 4, 192, 1, 5, 1, 5, 1 # length +[ 2001, "schemas", 2000, NULL, 0, true, 0, false, 0 ] +[ 2006, "types", 2000, NULL, 0, true, 0, false, 0 ] +[ 2015, "functions", 2000, NULL, 0, true, 0, false, 0 ] +[ 2024, "args", 2000, NULL, 0, true, 0, false, 0 ] +[ 2032, "sequences", 2000, NULL, 0, true, 0, false, 0 ] +[ 2042, "dependencies", 2000, NULL, 0, true, 0, false, 0 ] +[ 2046, "connections", 2000, NULL, 0, true, 0, false, 0 ] +[ 2055, "_tables", 2000, NULL, 0, true, 0, false, 0 ] +[ 2064, "_columns", 2000, NULL, 0, true, 0, false, 0 ] +[ 2075, "keys", 2000, NULL, 0, true, 0, false, 0 ] +[ 2082, "idxs", 2000, NULL, 0, true, 0, false, 0 ] +[ 2087, "triggers", 2000, NULL, 0, true, 0, false, 0 ] +[ 2098, "objects", 2000, NULL, 0, true, 0, false, 0 ] +[ 2103, "_tables", 2102, NULL, 0, true, 2, false, 0 ] +[ 2112, "_columns", 2102, NULL, 0, true, 2, false, 0 ] +[ 2123, "keys", 2102, NULL, 0, true, 2, false, 0 ] +[ 2130, "idxs", 2102, NULL, 0, true, 2, false, 0 ] +[ 2135, "triggers", 2102, NULL, 0, true, 2, false, 0 ] +[ 2146, "objects", 2102, NULL, 0, true, 2, false, 0 ] +[ 4993, "tables", 2000, "SELECT * FROM (SELECT p.*, 0 AS \"temporary\" FROM \"sys\".\"_tables\" AS p UNION ALL SELECT t.*, 1 AS \"temporary\" FROM \"tmp\".\"_tables\" AS t) AS tables where tables.type < 2;", 1, true, 0, false, 0 ] +[ 5003, "columns", 2000, "SELECT * FROM (SELECT p.* FROM \"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t) AS columns;", 1, true, 0, false, 0 ] +[ 5023, "db_user_info", 2000, NULL, 0, true, 0, false, 0 ] +[ 5031, "users", 2000, "SELECT u.\"name\" AS \"name\", ui.\"fullname\", ui.\"default_schema\" FROM db_users() AS u LEFT JOIN \"sys\".\"db_user_info\" AS ui ON u.\"name\" = ui.\"name\" ;", 1, true, 0, false, 0 ] +[ 5035, "user_role", 2000, NULL, 0, true, 0, false, 0 ] +[ 5038, "auths", 2000, NULL, 0, true, 0, false, 0 ] +[ 5042, "privileges", 2000, NULL, 0, true, 0, false, 0 ] +[ 5195, "queryhistory", 2000, NULL, 0, true, 0, false, 0 ] +[ 5209, "callhistory", 2000, NULL, 0, true, 0, false, 0 ] +[ 5226, "querylog", 2000, "create view querylog as\nselect qd.*, ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, ql.inblock, ql.oublock from queryhistory qd, callhistory ql\nwhere qd.id = ql.id;", 1, true, 0, false, 0 ] +[ 5641, "systemfunctions", 2000, NULL, 0, true, 0, false, 0 ] +[ 5750, "r", 2000, NULL, 0, false, 0, false, 0 ] + +# 18:53:13 > +# 18:53:13 > "Done." +# 18:53:13 > + 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);" ] _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
