Update of /cvsroot/monetdb/sql/src/test/Dependencies/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv13463/src/test/Dependencies/Tests
Modified Files:
Tag: SQL_2-24
Dependencies.stable.err
Log Message:
added dynamic type checks in more cases (fixes
auto_coersion_bug.SF-2075157.sql,string_length_not_checked.SF-2075078.sql)
added checks in alter table (fixes alter_view_not_allowed.SF-2075195.sql)
fixed hanling of not in (fixes select_in_wrong_result.SF-2080168.sql)
use the new thetauselect (fixes select_not_wrong_result.SF-2080151.sql)
U Dependencies.stable.err
Index: Dependencies.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Dependencies/Tests/Dependencies.stable.err,v
retrieving revision 1.6
retrieving revision 1.6.4.1
diff -u -d -r1.6 -r1.6.4.1
--- Dependencies.stable.err 26 Jan 2008 13:39:16 -0000 1.6
+++ Dependencies.stable.err 30 Aug 2008 06:44:17 -0000 1.6.4.1
@@ -10,55 +10,55 @@
# 23:01:45 > Mtimeout -timeout 60 ./Dependencies.SQL Dependencies
# 23:01:45 >
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP USER monetdb;
ERROR = !DROP USER: 'monetdb' owns a schema
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP SCHEMA test;
ERROR = !DROP SCHEMA: unable to drop schema 'test' (there are database objects
which depend on it
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = CREATE SCHEMA "test_2" AUTHORIZATION "public";
ERROR = !CREATE SCHEMA: insufficient privileges for user 'monet_test'
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP USER monetdb;
ERROR = !DROP USER: 'monetdb' owns a schema
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = CREATE INDEX id_age_index ON v1(id,age);
ERROR = !CREATE INDEX: cannot create index on view 'v1'
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = ALTER TABLE t1 DROP COLUMN id;
ERROR = !unable to drop column id (there are database objects which depend on
it)
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = ALTER TABLE v1 DROP COLUMN age;
-ERROR = !cannot drop column age (v1 is a view)
-MAPI = [EMAIL PROTECTED]:33628
+ERROR = !ALTER TABLE: cannot drop column from VIEW 'v1'
+MAPI = [EMAIL PROTECTED]:34730
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 = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP TABLE t1;
ERROR = !DROP TABLE: FOREIGN KEY t2.t2_id_t1_fkey depends on t1
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP VIEW v1;
ERROR = !unable to drop view v1 (there are database objects which depend on it)
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP TABLE t2;
ERROR = !DROP TABLE: unable to drop table t2 (there are database objects which
depend on it)
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP FUNCTION f1;
ERROR = !DROP FUNCTION: there are database objects dependent on function f1;
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP INDEX id_age_index;
ERROR = !DROP INDEX: no such index 'id_age_index'
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP VIEW v1;
ERROR = !unable to drop view v1 (there are database objects which depend on it)
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP TABLE t1;
ERROR = !DROP TABLE: unable to drop table t1 (there are database objects which
depend on it)
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP function f1;
ERROR = !DROP FUNCTION: there are database objects dependent on function f1;
-MAPI = [EMAIL PROTECTED]:33628
+MAPI = [EMAIL PROTECTED]:34730
QUERY = DROP SCHEMA test_2;
ERROR = !DROP SCHEMA: name test_2 does not exist
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
