Changeset: c943a5e1a755 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c943a5e1a755 Modified Files: sql/test/Dependencies/Tests/Dependencies.stable.err Branch: default Log Message:
approved correct error message diffs (83 lines): 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 @@ -5,60 +5,55 @@ stderr of test 'Dependencies` in directo # 23:01:45 > Mtimeout -timeout 180 mserver5 "--config=/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/monetdb5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/monetdb5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/monetdb5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/sql_logs" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/xquery_logs" --set mapi_port=39017 --set monet_prompt= --trace "--dbname=mTests_src_test_Dependencies" --dbinit='include sql;' ; echo ; echo Over.. # 23:01:45 > - -# 23:01:45 > -# 23:01:45 > Mtimeout -timeout 60 ./Dependencies.SQL Dependencies -# 23:01:45 > - -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP USER monetdb; - -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +ERROR = !DROP USER: 'monetdb' owns a schema +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP SCHEMA test; ERROR = !DROP SCHEMA: unable to drop schema 'test' (there are database objects which depend on it -MAPI = (monet_test) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monet_test) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = CREATE SCHEMA "test_2" AUTHORIZATION "public"; ERROR = !CREATE SCHEMA: insufficient privileges for user 'monet_test' -MAPI = (monet_test) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monet_test) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP USER monetdb; - -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +ERROR = !DROP USER: 'monetdb' owns a schema +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = CREATE INDEX id_age_index ON v1(id,age); ERROR = !CREATE INDEX: cannot create index on view 'v1' -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = ALTER TABLE t1 DROP COLUMN id; ERROR = !ALTER TABLE: cannot drop column 'id': there are database objects which depend on it -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = ALTER TABLE v1 DROP COLUMN age; ERROR = !ALTER TABLE: cannot drop column from VIEW 'v1' -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 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) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP TABLE t1; ERROR = !DROP TABLE: FOREIGN KEY t2.t2_id_t1_fkey depends on t1 -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP VIEW v1; ERROR = !DROP VIEW: cannot drop view 'v1', there are database objects which depend on it -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP TABLE t2; ERROR = !DROP TABLE: unable to drop table t2 (there are database objects which depend on it) -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP FUNCTION f1; ERROR = !DROP FUNCTION: there are database objects dependent on function f1; -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP INDEX id_age_index; ERROR = !DROP INDEX: no such index 'id_age_index' -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP VIEW v1; ERROR = !DROP VIEW: cannot drop view 'v1', there are database objects which depend on it -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP TABLE t1; ERROR = !DROP TABLE: unable to drop table t1 (there are database objects which depend on it) -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP function f1; ERROR = !DROP FUNCTION: there are database objects dependent on function f1; -MAPI = (monetdb) /var/tmp/mtest-19467/.s.monetdb.38439 +MAPI = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091 QUERY = DROP SCHEMA test_2; ERROR = !DROP SCHEMA: name test_2 does not exist _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
