Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv10921/src/test/BugTracker/Tests
Modified Files:
alter_table_set_not_null.SF-1997030.stable.err
caching.SF-1651599.stable.out
create_same_temp_tab_after_its_drop.SF-1850809.stable.err
drop_system_tables.SF-1550768.stable.err
pkey_in_temp_table.SF-1841727.stable.err
pkey_in_temp_table.SF-1841727.stable.out
set_a_new_user_password.SF-1844050.stable.err
table_dependency_inside_union.SF-1884382.stable.err
temporary_tables.SF-1715669.stable.err
view_creation_using_func.SF-1714814.stable.err
Log Message:
moved most of the DDL statements into mal
Index: pkey_in_temp_table.SF-1841727.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/pkey_in_temp_table.SF-1841727.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- pkey_in_temp_table.SF-1841727.stable.out 16 May 2009 07:21:43 -0000
1.3
+++ pkey_in_temp_table.SF-1841727.stable.out 10 Jan 2010 15:33:36 -0000
1.4
@@ -22,12 +22,18 @@
Over..
-# 20:40:27 >
-# 20:40:27 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=37526
-# 20:40:27 >
+# 14:52:32 >
+# 14:52:32 > mclient -lsql -i --host=localhost --port=36566
+# 14:52:32 >
+[ 1 ]
+[ 1 ]
+% tmp.pktable1841727 # table_name
+% ptest1 # name
+% int # type
+% 1 # length
-# 20:40:27 >
-# 20:40:27 > Done.
-# 20:40:27 >
+# 14:52:32 >
+# 14:52:32 > Done.
+# 14:52:32 >
Index: view_creation_using_func.SF-1714814.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/view_creation_using_func.SF-1714814.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- view_creation_using_func.SF-1714814.stable.err 29 Jun 2007 11:29:27
-0000 1.2
+++ view_creation_using_func.SF-1714814.stable.err 10 Jan 2010 15:33:36
-0000 1.3
@@ -12,12 +12,12 @@
# 18:25:58 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36305
# 18:25:58 >
-MAPI = mone...@koala:34067
+MAPI = mone...@localhost:38198
QUERY = create view v1 as select * from t1 where id = f(1);
ERROR = !SELECT: no such unary operator 'f(tinyint)'
-MAPI = mone...@koala:34067
+MAPI = mone...@localhost:38198
QUERY = drop view v1;
-ERROR = !DROP VIEW: unknown view 'v1'
+ERROR = !SQLException:sql.catalog:DROP VIEW: unknown view 'v1'
# 18:25:58 >
# 18:25:58 > Done.
Index: drop_system_tables.SF-1550768.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/drop_system_tables.SF-1550768.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- drop_system_tables.SF-1550768.stable.err 26 Jan 2008 13:39:15 -0000
1.2
+++ drop_system_tables.SF-1550768.stable.err 10 Jan 2010 15:33:36 -0000
1.3
@@ -10,15 +10,15 @@
# 10:53:33 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=34124 < drop_system_tables.SF-1550768.sql
# 10:53:33 >
-MAPI = mone...@localhost:34124
+MAPI = mone...@localhost:38198
QUERY = drop table tables;
-ERROR = !DROP TABLE: cannot drop VIEW 'tables'
-MAPI = mone...@localhost:34124
+ERROR = !SQLException:sql.catalog:DROP TABLE: cannot drop VIEW 'tables'
+MAPI = mone...@localhost:38198
QUERY = drop view tables;
-ERROR = !DROP VIEW: cannot drop system view 'tables'
-MAPI = mone...@localhost:34124
+ERROR = !SQLException:sql.catalog:DROP VIEW: cannot drop system view 'tables'
+MAPI = mone...@localhost:38198
QUERY = drop table _tables;
-ERROR = !DROP TABLE: cannot drop system table '_tables'
+ERROR = !SQLException:sql.catalog:DROP TABLE: cannot drop system table
'_tables'
# 10:53:33 >
# 10:53:33 > Done.
Index: set_a_new_user_password.SF-1844050.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- set_a_new_user_password.SF-1844050.stable.err 18 May 2009 07:18:22
-0000 1.3
+++ set_a_new_user_password.SF-1844050.stable.err 10 Jan 2010 15:33:36
-0000 1.4
@@ -15,11 +15,11 @@
#client: "Mtimeout -timeout 60 mclient -lsql -uvoc -Pnew --host=alviss
--port=30700 "
#mserver: "Mtimeout -timeout 60 mserver5
"--config=/ufs/goncalve/scratch/MonetDB/stable/optimized/MonetDB5/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/stable/optimized/MonetDB5//lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/stable/optimized/MonetDB5//lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/stable/optimized/MonetDB5//lib/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/stable/optimized/MonetDB5//var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/goncalve/scratch/MonetDB/stable/optimized/MonetDB5//var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30700 --set
xrpc_port=43497 --set monet_prompt= --trace --dbfarm
"/ufs/goncalve/scratch/MonetDB/stable/optimized/MonetDB5//var/MonetDB5/dbfarm"
--dbname "mTests_src_test_BugTracker" --dbinit="include sql;""
#warning: please don't forget to set your vault key!
-#(see /ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/etc/monetdb5.conf)
-#client: "Mtimeout -timeout 18 mclient -lsql -umonetdb -Pmonetdb --host=alviss
--port=39929 "
-MAPI = mone...@alviss:39929
+#(see /home/niels/scratch/monetdb/Linux-i686/etc/monetdb5.conf)
+#client
+MAPI = mone...@localhost:38198
QUERY = DROP SCHEMA "voc2";
-ERROR = !DROP SCHEMA: unable to drop schema 'voc2' (there are database objects
which depend on it
+ERROR = !SQLException:sql.catalog:DROP SCHEMA: unable to drop schema 'voc2'
(there are database objects which depend on it
# 16:29:47 >
# 16:29:47 > Done.
Index: create_same_temp_tab_after_its_drop.SF-1850809.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/create_same_temp_tab_after_its_drop.SF-1850809.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- create_same_temp_tab_after_its_drop.SF-1850809.stable.err 18 Dec 2007
10:49:14 -0000 1.2
+++ create_same_temp_tab_after_its_drop.SF-1850809.stable.err 10 Jan 2010
15:33:36 -0000 1.3
@@ -12,12 +12,12 @@
# 11:00:59 > mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=35980
# 11:00:59 >
-MAPI = mone...@amelia:35980
+MAPI = mone...@localhost:38198
QUERY = INSERT INTO temptest VALUES (3);
ERROR = !INSERT INTO: no such table 'temptest'
-MAPI = mone...@amelia:35980
+MAPI = mone...@localhost:38198
QUERY = DROP TABLE temptest;
-ERROR = !DROP TABLE: no such table 'temptest'
+ERROR = !SQLException:sql.catalog:DROP TABLE: no such table 'temptest'
# 11:00:59 >
# 11:00:59 > Done.
Index: table_dependency_inside_union.SF-1884382.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/table_dependency_inside_union.SF-1884382.stable.err,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- table_dependency_inside_union.SF-1884382.stable.err 1 Feb 2008 13:46:11
-0000 1.1
+++ table_dependency_inside_union.SF-1884382.stable.err 10 Jan 2010 15:33:36
-0000 1.2
@@ -12,12 +12,12 @@
# 14:42:29 > mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=32819
# 14:42:29 >
-MAPI = mone...@amelia:32819
+MAPI = mone...@localhost:38198
QUERY = drop table t1;
-ERROR = !DROP TABLE: unable to drop table t1 (there are database objects which
depend on it)
-MAPI = mone...@amelia:32819
+ERROR = !SQLException:sql.catalog:DROP TABLE: unable to drop table t1 (there
are database objects which depend on it)
+MAPI = mone...@localhost:38198
QUERY = drop table t2;
-ERROR = !DROP TABLE: unable to drop table t2 (there are database objects which
depend on it)
+ERROR = !SQLException:sql.catalog:DROP TABLE: unable to drop table t2 (there
are database objects which depend on it)
# 14:42:29 >
# 14:42:29 > Done.
Index: temporary_tables.SF-1715669.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/temporary_tables.SF-1715669.stable.err,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- temporary_tables.SF-1715669.stable.err 10 May 2007 07:49:50 -0000
1.1
+++ temporary_tables.SF-1715669.stable.err 10 Jan 2010 15:33:36 -0000
1.2
@@ -10,9 +10,9 @@
# 09:35:56 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32868
# 09:35:56 >
-MAPI = mone...@localhost:32868
+MAPI = mone...@localhost:38198
QUERY = drop table t1;
-ERROR = !DROP TABLE: no such table 't1'
+ERROR = !SQLException:sql.catalog:DROP TABLE: no such table 't1'
# 09:35:56 >
# 09:35:56 > Done.
Index: alter_table_set_not_null.SF-1997030.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/alter_table_set_not_null.SF-1997030.stable.err,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- alter_table_set_not_null.SF-1997030.stable.err 18 Aug 2008 09:45:34
-0000 1.5
+++ alter_table_set_not_null.SF-1997030.stable.err 10 Jan 2010 15:33:36
-0000 1.6
@@ -79,10 +79,9 @@
# 19:06:38 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=35202
# 19:06:38 >
-MAPI = mone...@alf:38580
+MAPI = mone...@localhost:30291
QUERY = ALTER TABLE foo ALTER COLUMN i SET NOT NULL;
-ERROR = !SQLException:assert:ALTER TABLE: NOT NULL constraint violated for
column foo.i
-
+ERROR = !SQLException:sql.catalog:ALTER TABLE: NOT NULL constraint violated
for column foo.i
# 19:06:38 >
# 19:06:38 > Done.
Index: pkey_in_temp_table.SF-1841727.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/pkey_in_temp_table.SF-1841727.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- pkey_in_temp_table.SF-1841727.stable.err 16 May 2009 07:21:39 -0000
1.3
+++ pkey_in_temp_table.SF-1841727.stable.err 10 Jan 2010 15:33:36 -0000
1.4
@@ -12,21 +12,6 @@
# 16:39:59 > mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=35124
# 16:39:59 >
-MAPI = mone...@alf:37526
-QUERY = CREATE TEMP TABLE pktable1841727 (ptest1 int PRIMARY KEY);
-ERROR = !CONSTRAINT: constraints on temporary tables are not supported
-MAPI = mone...@alf:37526
-QUERY = insert into pktable1841727 values(1);
-ERROR = !INSERT INTO: no such table 'pktable1841727'
-MAPI = mone...@alf:37526
-QUERY = insert into pktable1841727 values(1);
-ERROR = !INSERT INTO: no such table 'pktable1841727'
-MAPI = mone...@alf:37526
-QUERY = select * from pktable1841727;
-ERROR = !SELECT: no such table 'pktable1841727'
-MAPI = mone...@alf:37526
-QUERY = drop table pktable1841727;
-ERROR = !DROP TABLE: no such table 'pktable1841727'
# 16:39:59 >
# 16:39:59 > Done.
Index: caching.SF-1651599.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/caching.SF-1651599.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- caching.SF-1651599.stable.out 7 Dec 2008 20:19:01 -0000 1.3
+++ caching.SF-1651599.stable.out 10 Jan 2010 15:33:36 -0000 1.4
@@ -2678,6 +2678,7 @@
[ "insert into foo (foo1,foo2,foo3,foo4,foo5,foo6,foo7) select
5423.298,611.794,512.611,298.611,794.512,6927.7794,7794.6927;", 1 ]
[ "insert into foo (foo1,foo2,foo3,foo4,foo5,foo6,foo7) select
7527.5970,null,7844.3785,5970.3785,5737.7844,4238.329,329.4238;", 1
]
[ "insert into foo (foo1,foo2,foo3,foo4,foo5,foo6,foo7) select
3869.3905,null,9208.3881,null,9725.9208,435.9519,9519.435;", 1 ]
+[ "create table foo (foo1 float,foo2 float,foo3 float,foo4 float,foo5
float,foo6 float,foo7 float);", 1 ]
# 16:22:23 >
# 16:22:23 > Done.
------------------------------------------------------------------------------
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
