Update of /cvsroot/monetdb/sql/src/test/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv10921/src/test/Tests
Modified Files:
50ways.stable.err create_in_schema.stable.err
procedure_syntax.stable.err trace.stable.out
Log Message:
moved most of the DDL statements into mal
Index: 50ways.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/50ways.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- 50ways.stable.err 13 Dec 2009 20:33:16 -0000 1.3
+++ 50ways.stable.err 10 Jan 2010 15:33:37 -0000 1.4
@@ -81,19 +81,19 @@
# 16:07:26 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=36831 -G
# 16:07:26 >
-MAPI = mone...@localhost:30890
+MAPI = mone...@localhost:31166
QUERY = drop table s;
-ERROR = !DROP TABLE: no such table 's'
-MAPI = mone...@localhost:30890
+ERROR = !SQLException:sql.catalog:DROP TABLE: no such table 's'
+MAPI = mone...@localhost:31166
QUERY = drop table sp;
-ERROR = !DROP TABLE: no such table 'sp'
-MAPI = mone...@localhost:30890
+ERROR = !SQLException:sql.catalog:DROP TABLE: no such table 'sp'
+MAPI = mone...@localhost:31166
QUERY = commit;
ERROR = !SQLException:sql.trans:COMMIT: not allowed in auto commit mode
-MAPI = mone...@localhost:30890
+MAPI = mone...@localhost:31166
QUERY = SELECT DISTINCT S.SNAME
ERROR = !SELECT: no such column 's.sname'
-MAPI = mone...@localhost:30890
+MAPI = mone...@localhost:31166
QUERY = SELECT DISTINCT S.SNAME
ERROR = !SELECT: no such column 's.sname'
Index: create_in_schema.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/create_in_schema.stable.err,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- create_in_schema.stable.err 7 Dec 2008 17:31:30 -0000 1.5
+++ create_in_schema.stable.err 10 Jan 2010 15:33:37 -0000 1.6
@@ -10,21 +10,21 @@
# 15:21:44 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=38268 < create_in_schema.sql
# 15:21:44 >
-MAPI = mone...@alf:37993
+MAPI = mone...@localhost:38198
QUERY = select * from bla3; -- should fail
ERROR = !SELECT: no such table 'bla3'
-MAPI = mone...@alf:37993
-QUERY = drop view v_bla5; -- should fail
-ERROR = !DROP VIEW: unknown view 'v_bla5'
-MAPI = mone...@alf:37993
+MAPI = mone...@localhost:38198
+QUERY = drop view tmp.v_bla5;
+ERROR = !SQLException:sql.catalog:DROP VIEW: unknown view 'v_bla5'
+MAPI = mone...@localhost:38198
QUERY = drop view v_bla4; -- should fail
-ERROR = !DROP VIEW: unknown view 'v_bla4'
-MAPI = mone...@alf:37993
+ERROR = !SQLException:sql.catalog:DROP VIEW: unknown view 'v_bla4'
+MAPI = mone...@localhost:38198
QUERY = drop table sys.bla4; -- should fail
-ERROR = !DROP TABLE: no such table 'bla4'
-MAPI = mone...@alf:37993
+ERROR = !SQLException:sql.catalog:DROP TABLE: no such table 'bla4'
+MAPI = mone...@localhost:38198
QUERY = drop table bla3; -- should fail
-ERROR = !DROP TABLE: no such table 'bla3'
+ERROR = !SQLException:sql.catalog:DROP TABLE: no such table 'bla3'
# 15:21:45 >
# 15:21:45 > Done.
Index: trace.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/trace.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- trace.stable.out 28 Nov 2009 19:58:56 -0000 1.2
+++ trace.stable.out 10 Jan 2010 15:33:37 -0000 1.3
@@ -30,7 +30,7 @@
% L1 # name
% wrd # type
% 2 # length
-[ 26 ]
+[ 27 ]
% . # table_name
% L2 # name
% wrd # type
Index: procedure_syntax.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/procedure_syntax.stable.err,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- procedure_syntax.stable.err 7 Dec 2008 17:31:30 -0000 1.4
+++ procedure_syntax.stable.err 10 Jan 2010 15:33:37 -0000 1.5
@@ -12,25 +12,25 @@
# 01:17:48 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=34904
# 01:17:48 >
-MAPI = mone...@alf:37993
+MAPI = mone...@localhost:31166
QUERY = DROP PROCEDURE p1;
ERROR = !DROP PROCEDURE: there are more than one procedure called 'p1', please
use the full signature
-MAPI = mone...@alf:37993
+MAPI = mone...@localhost:31166
QUERY = DROP PROCEDURE p2 (int, varchar(1024));
ERROR = !DROP PROCEDURE: no such procedure 'p2' (int(32), varchar(1024))
-MAPI = mone...@alf:37993
+MAPI = mone...@localhost:31166
QUERY = DROP table t1;
-ERROR = !DROP TABLE: unable to drop table t1 (there are database objects which
depend on it)
-MAPI = mone...@alf:37993
+ERROR = !SQLException:sql.catalog:DROP TABLE: unable to drop table t1 (there
are database objects which depend on it)
+MAPI = mone...@localhost:31166
QUERY = DROP ALL PROCEDURE p1 CASCADE;
ERROR = !DROP ALL PROCEDURE: no such procedure 'p1'
-MAPI = mone...@alf:37993
+MAPI = mone...@localhost:31166
QUERY = DROP FUNCTION p1;
ERROR = !DROP FUNCTION: no such function 'p1'
-MAPI = mone...@alf:37993
+MAPI = mone...@localhost:31166
QUERY = DROP FUNCTION p1 ();
ERROR = !DROP FUNCTION: no such function 'p1' ()
-MAPI = mone...@alf:37993
+MAPI = mone...@localhost:31166
QUERY = DROP ALL FUNCTION p1;
ERROR = !DROP ALL FUNCTION: no such function 'p1'
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
