Changeset: f4e6658a6c22 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f4e6658a6c22 Modified Files: sql/jdbc/tests/Tests/Test_Dobjects.stable.out sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out 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/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out sql/test/Dependencies/Tests/Dependencies.stable.err sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/Tests/dependency_loop.stable.out sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions_nogeom.stable.out sql/test/Tests/trace_nogeom.stable.out sql/test/bugs/Tests/crash_order_by.stable.err sql/test/bugs/Tests/crash_order_by.stable.out sql/test/bugs/Tests/insert_delete-bug-sf-904025.stable.out sql/test/bugs/Tests/simple_view.stable.out sql/test/leaks/Tests/check0.stable.out sql/test/leaks/Tests/check0_nogeom.stable.out sql/test/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check1_nogeom.stable.out sql/test/leaks/Tests/check2.stable.out sql/test/leaks/Tests/check2_nogeom.stable.out sql/test/leaks/Tests/check3.stable.out sql/test/leaks/Tests/check3_nogeom.stable.out sql/test/leaks/Tests/check4.stable.out sql/test/leaks/Tests/check4_nogeom.stable.out sql/test/leaks/Tests/check5.stable.out sql/test/leaks/Tests/check5_nogeom.stable.out sql/test/leaks/Tests/drop3.stable.out sql/test/leaks/Tests/drop3_nogeom.stable.out sql/test/leaks/Tests/select1.stable.out sql/test/leaks/Tests/select1_nogeom.stable.out sql/test/leaks/Tests/select2.stable.out sql/test/leaks/Tests/select2_nogeom.stable.out sql/test/leaks/Tests/temp1.stable.out sql/test/leaks/Tests/temp1_nogeom.stable.out sql/test/leaks/Tests/temp2.stable.out sql/test/leaks/Tests/temp2_nogeom.stable.out sql/test/leaks/Tests/temp3.stable.out sql/test/leaks/Tests/temp3_nogeom.stable.out sql/test/mapi/Tests/php_monetdb.stable.out sql/test/mapi/Tests/php_monetdb_nogeom.stable.out Branch: default Log Message:
Approvals after changesets 523120729e8d and 0735f6e1ddfc. diffs (truncated from 2545 to 300 lines): diff --git a/sql/jdbc/tests/Tests/Test_Dobjects.stable.out b/sql/jdbc/tests/Tests/Test_Dobjects.stable.out --- a/sql/jdbc/tests/Tests/Test_Dobjects.stable.out +++ b/sql/jdbc/tests/Tests/Test_Dobjects.stable.out @@ -77,6 +77,7 @@ mTests_jdbc_tests sys privileges SYSTEM mTests_jdbc_tests sys queryhistory SYSTEM TABLE null null null null rowid SYSTEM mTests_jdbc_tests sys schemas SYSTEM TABLE null null null null rowid SYSTEM mTests_jdbc_tests sys sequences SYSTEM TABLE null null null null rowid SYSTEM +mTests_jdbc_tests sys storagemodelinput SYSTEM TABLE null null null null rowid SYSTEM mTests_jdbc_tests sys systemfunctions SYSTEM TABLE null null null null rowid SYSTEM mTests_jdbc_tests sys triggers SYSTEM TABLE null null null null rowid SYSTEM mTests_jdbc_tests sys types SYSTEM TABLE null null null null rowid SYSTEM @@ -92,6 +93,16 @@ mTests_jdbc_tests sys querylog SYSTEM VI select qd.*, ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, ql.inblock, ql.oublock from queryhistory qd, callhistory ql where qd.id = ql.id; null null null rowid SYSTEM mTests_jdbc_tests sys tables SYSTEM VIEW 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; null null null rowid SYSTEM +mTests_jdbc_tests sys tablestoragemodel SYSTEM VIEW -- A summary of the table storage requirement is is available as a table view. +-- The auxillary column denotes the maximum space if all non-sorted columns +-- would be augmented with a hash (rare situation) +create view tablestoragemodel +as select "schema","table",max(count) as "count", + sum(columnsize) as columnsize, + sum(heapsize) as heapsize, + sum(indices) as indices, + sum(case when sorted = false then 8 * count else 0 end) as auxillary +from storagemodel() group by "schema","table"; null null null rowid SYSTEM mTests_jdbc_tests sys users SYSTEM VIEW 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" ; null null null rowid SYSTEM # 20:09:14 > diff --git a/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err b/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err --- a/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err +++ b/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err @@ -82,9 +82,9 @@ stderr of test 'sql_command_kills_db.SF- # 16:15:09 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=39774 -G # 16:15:09 > -MAPI = monetdb@niels:30424 +MAPI = monetdb@madrid:36834 QUERY = insert into t1 values ((select id from tables)); -ERROR = !cardinality violation (31>1) +ERROR = !cardinality violation (33>1) # 16:15:09 > # 16:15:09 > Done. diff --git a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out --- a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out +++ b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out @@ -29,19 +29,19 @@ Ready. % L1 # name % wrd # type % 2 # length -[ 30 ] +[ 32 ] #select count(distinct name) from tables; % .tables # table_name % L1 # name % wrd # type % 2 # length -[ 24 ] +[ 26 ] #select count(name) , count(distinct name) from tables; % .tables, .tables # table_name % L1, L2 # name % wrd, wrd # type % 2, 2 # length -[ 30, 24 ] +[ 32, 26 ] # 10:05:42 > # 10:05:42 > Done. diff --git a/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out b/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out --- a/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out +++ b/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out @@ -123,6 +123,8 @@ Ready. [ 123 ] [ 123 ] [ 123 ] +[ 123 ] +[ 123 ] # 17:14:07 > # 17:14:07 > "Done." diff --git a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out --- a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out +++ b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out @@ -28,13 +28,13 @@ Ready. % L2, L1 # name % tinyint, wrd # type % 1, 2 # length -[ 1, 31 ] +[ 1, 33 ] #SELECT (SELECT count(*) FROM tables), 1; % .tables, . # table_name % L1, single_value # name % wrd, tinyint # type % 2, 1 # length -[ 31, 1 ] +[ 33, 1 ] # 21:48:51 > # 21:48:51 > "Done." diff --git a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err --- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err +++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err @@ -30,7 +30,7 @@ stderr of test 'predicate_select.Bug-309 # 18:53:13 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=niels" "--port=32323" # 18:53:13 > -MAPI = monetdb@sofia:39129 +MAPI = monetdb@madrid:36834 QUERY = select * from tables where name; ERROR = !conversion from string to type bit failed. diff --git a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out --- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out +++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out @@ -27,7 +27,7 @@ Ready. % .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 +% 4, 17, 4, 488, 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 ] @@ -57,8 +57,10 @@ Ready. [ 5220, "queryhistory", 2000, NULL, 0, true, 0, false, 0 ] [ 5234, "callhistory", 2000, NULL, 0, true, 0, false, 0 ] [ 5251, "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 ] -[ 5843, "systemfunctions", 2000, NULL, 0, true, 0, false, 0 ] -[ 5952, "r", 2000, NULL, 0, false, 0, false, 0 ] +[ 5848, "storagemodelinput", 2000, NULL, 0, true, 0, false, 0 ] +[ 5889, "tablestoragemodel", 2000, "-- A summary of the table storage requirement is is available as a table view.\n-- The auxillary column denotes the maximum space if all non-sorted columns\n-- would be augmented with a hash (rare situation)\ncreate view tablestoragemodel\nas select \"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as auxillary\nfrom storagemodel() group by \"schema\",\"table\";", 1, true, 0, false, 0 ] +[ 5911, "systemfunctions", 2000, NULL, 0, true, 0, false, 0 ] +[ 6020, "r", 2000, NULL, 0, false, 0, false, 0 ] # 18:53:13 > # 18:53:13 > "Done." 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 --- 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 @@ -30,7 +30,7 @@ stderr of test 'predicate_select.Bug-309 # 18:53:13 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=niels" "--port=32323" # 18:53:13 > -MAPI = monetdb@madrid:32839 +MAPI = monetdb@madrid:37409 QUERY = select * from tables where name; ERROR = !conversion from string to type bit failed. 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 --- 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 @@ -27,7 +27,7 @@ Ready. % .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 +% 4, 17, 4, 488, 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 ] @@ -47,18 +47,20 @@ Ready. [ 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 ] -[ 5632, "systemfunctions", 2000, NULL, 0, true, 0, false, 0 ] -[ 5741, "r", 2000, NULL, 0, false, 0, false, 0 ] +[ 5018, "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 ] +[ 5028, "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 ] +[ 5048, "db_user_info", 2000, NULL, 0, true, 0, false, 0 ] +[ 5056, "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 ] +[ 5060, "user_role", 2000, NULL, 0, true, 0, false, 0 ] +[ 5063, "auths", 2000, NULL, 0, true, 0, false, 0 ] +[ 5067, "privileges", 2000, NULL, 0, true, 0, false, 0 ] +[ 5220, "queryhistory", 2000, NULL, 0, true, 0, false, 0 ] +[ 5234, "callhistory", 2000, NULL, 0, true, 0, false, 0 ] +[ 5251, "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 ] +[ 5648, "storagemodelinput", 2000, NULL, 0, true, 0, false, 0 ] +[ 5689, "tablestoragemodel", 2000, "-- A summary of the table storage requirement is is available as a table view.\n-- The auxillary column denotes the maximum space if all non-sorted columns\n-- would be augmented with a hash (rare situation)\ncreate view tablestoragemodel\nas select \"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as auxillary\nfrom storagemodel() group by \"schema\",\"table\";", 1, true, 0, false, 0 ] +[ 5711, "systemfunctions", 2000, NULL, 0, true, 0, false, 0 ] +[ 5820, "r", 2000, NULL, 0, false, 0, false, 0 ] # 18:53:13 > # 18:53:13 > "Done." diff --git a/sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err b/sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err --- a/sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err +++ b/sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err @@ -80,12 +80,12 @@ stderr of test 'cardinality_violation.SF # 21:00:43 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=38808 # 21:00:43 > -MAPI = monetdb@niels:32557 +MAPI = monetdb@madrid:36834 QUERY = select * from env() as env where name = ( select 'prefix' from env() as env ); ERROR = !cardinality violation (20>1) -MAPI = monetdb@niels:32557 +MAPI = monetdb@madrid:36834 QUERY = select * from columns where name = (select columns.name from _tables, columns where _tables.id = columns.table_id); -ERROR = !cardinality violation (289>1) +ERROR = !cardinality violation (326>1) # 21:00:43 > diff --git a/sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out b/sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out --- a/sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out +++ b/sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out @@ -58,6 +58,8 @@ Ready. [ 28 ] [ 29 ] [ 30 ] +[ 31 ] +[ 32 ] # 11:15:39 > # 11:15:39 > Done. diff --git a/sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out b/sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out --- a/sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out +++ b/sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out @@ -28,13 +28,13 @@ Ready. % L1 # name % wrd # type % 2 # length -[ 30 ] +[ 32 ] #WITH t AS ( SELECT count(*) FROM tables ) SELECT * FROM t; % .t # table_name % L1 # name % wrd # type % 2 # length -[ 30 ] +[ 32 ] # 22:41:45 > # 22:41:45 > Done. diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.err b/sql/test/Dependencies/Tests/Dependencies.stable.err --- a/sql/test/Dependencies/Tests/Dependencies.stable.err +++ b/sql/test/Dependencies/Tests/Dependencies.stable.err @@ -10,55 +10,55 @@ stderr of test 'Dependencies` in directo # 23:01:45 > Mtimeout -timeout 60 ./Dependencies.SQL Dependencies # 23:01:45 > -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = DROP USER monetdb; ERROR = !DROP USER: cannot remove yourself -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = DROP SCHEMA test; ERROR = !DROP SCHEMA: unable to drop schema 'test' (there are database objects which depend on it -MAPI = monet_test@alf:38889 +MAPI = monet_test@madrid:36834 QUERY = CREATE SCHEMA "test_2" AUTHORIZATION "public"; ERROR = !CREATE SCHEMA: insufficient privileges for user 'monet_test' -MAPI = monet_test@alf:38889 +MAPI = monet_test@madrid:36834 QUERY = DROP USER monetdb; ERROR = !DROP USER: access denied for user 'monet_test' -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = CREATE INDEX id_age_index ON v1(id,age); ERROR = !CREATE INDEX: cannot create index on view 'v1' -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = ALTER TABLE t1 DROP COLUMN id; ERROR = !ALTER TABLE: cannot drop column 'id': there are database objects which depend on it -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = ALTER TABLE v1 DROP COLUMN age; ERROR = !ALTER TABLE: cannot drop column from VIEW 'v1' -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = ALTER TABLE t2 ADD FOREIGN KEY(age_v1) REFERENCES v1(age); ERROR = !CONSTRAINT FOREIGN KEY: could not find referenced PRIMARY KEY in table 'v1' -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = DROP TABLE t1; ERROR = !DROP TABLE: FOREIGN KEY t2.t2_id_t1_fkey depends on t1 -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = DROP VIEW v1; ERROR = !DROP VIEW: cannot drop view 'v1', there are database objects which depend on it -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = DROP TABLE t2; ERROR = !DROP TABLE: unable to drop table t2 (there are database objects which depend on it) -MAPI = monetdb@alf:38889 +MAPI = monetdb@madrid:36834 QUERY = DROP FUNCTION f1; ERROR = !DROP FUNCTION: there are database objects dependent on function f1; -MAPI = monetdb@alf:38889 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list