Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv30796
Modified Files:
case_in_aggr_bug.SF-1506545.sql
crash_on_fkey_update.SF-1703497.sql
create_column_name_data.SF-1440214.sql
prepare_decimal_float.SF-1675795.sql
rank_over.SF-1691098.stable.out
sequence_not_stored_3.SF-1509894.sql
subquery_orderby.SF-1688915.stable.out.Five
temporary_tables.SF-1715669.sql
temporary_tables.SF-1715669.stable.out
Log Message:
Drop tables which were not dropped in some tests.
Approve the out output for these tests.
Remove the ids from the select result.
Index: subquery_orderby.SF-1688915.stable.out.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/subquery_orderby.SF-1688915.stable.out.Five,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- subquery_orderby.SF-1688915.stable.out.Five 17 Apr 2007 13:29:59 -0000
1.2
+++ subquery_orderby.SF-1688915.stable.out.Five 10 May 2007 10:53:00 -0000
1.3
@@ -22,7 +22,7 @@
% .x # table_name
% name # name
% varchar # type
-% 13 # length
+% 12 # length
[ "schemas" ]
[ "types" ]
[ "functions" ]
@@ -50,11 +50,6 @@
[ "auths" ]
[ "privileges" ]
[ "profile" ]
-[ "test1440214" ]
-[ "system" ]
-[ "target" ]
-[ "configuration" ]
-[ "test" ]
# 10:11:41 >
# 10:11:41 > Done.
Index: crash_on_fkey_update.SF-1703497.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- crash_on_fkey_update.SF-1703497.sql 27 Apr 2007 09:45:54 -0000 1.2
+++ crash_on_fkey_update.SF-1703497.sql 10 May 2007 10:52:59 -0000 1.3
@@ -3,3 +3,6 @@
insert into t1 values(3, 'monb');
insert into t2 values(3, 25);
update t2 set id = 10 where id =3;
+
+drop table t2;
+drop table t1;
Index: prepare_decimal_float.SF-1675795.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/prepare_decimal_float.SF-1675795.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- prepare_decimal_float.SF-1675795.sql 1 Apr 2007 22:08:58 -0000
1.2
+++ prepare_decimal_float.SF-1675795.sql 10 May 2007 10:53:00 -0000
1.3
@@ -2,3 +2,4 @@
prepare insert into xy values (?,?,?);
exec 0 (timestamp '2007-03-07 15:28:16.577', 0.6841, 0.684);
select * from xy;
+DROP TABLE xy;
Index: case_in_aggr_bug.SF-1506545.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/case_in_aggr_bug.SF-1506545.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- case_in_aggr_bug.SF-1506545.sql 20 Jun 2006 17:19:55 -0000 1.2
+++ case_in_aggr_bug.SF-1506545.sql 10 May 2007 10:52:59 -0000 1.3
@@ -29,3 +29,8 @@
select avg(target_id / case (system_id - 1) WHEN 0 THEN cast(null as int)
ELSE system_id - 1 END) from configuration;
+
+DROP TABLE configuration;
+DROP TABLE system;
+DROP TABLE target;
+
Index: rank_over.SF-1691098.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/rank_over.SF-1691098.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- rank_over.SF-1691098.stable.out 1 Apr 2007 22:08:58 -0000 1.3
+++ rank_over.SF-1691098.stable.out 10 May 2007 10:53:00 -0000 1.4
@@ -1,19 +1,17 @@
stdout of test 'rank_over.SF-1691098` in directory 'src/test/BugTracker`
itself:
-# 16:03:46 >
-# 16:03:46 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=38533 --set xrpc_port=44649 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
-# 16:03:46 >
-
-# Monet Database Server V4.16.3
-# Copyright (c) 1993-2007, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 11:41:16 >
+# 11:41:16 > 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
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs"
--set mapi_port=33648 --set xrpc_port=42118 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=' include sql;' ; echo ; echo
Over..
+# 11:41:16 >
-printf("\nReady.\n");
+# MonetDB Server v5.0.0_beta2_1
+# Copyright (c) 1993-2007 CWI, all rights reserved
+# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
+# dbname:mTests_src_test_BugTracker
+# Visit http://monetdb.cwi.nl/ for further information
Ready.
-quit();
Over..
@@ -52,13 +50,8 @@
[ 24 ]
[ 25 ]
[ 26 ]
-[ 27 ]
-[ 28 ]
-[ 29 ]
-[ 30 ]
-[ 31 ]
-# 22:21:05 >
-# 22:21:05 > Done.
-# 22:21:05 >
+# 11:52:56 >
+# 11:52:56 > Done.
+# 11:52:56 >
Index: create_column_name_data.SF-1440214.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/create_column_name_data.SF-1440214.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- create_column_name_data.SF-1440214.sql 7 Mar 2006 19:10:31 -0000
1.1
+++ create_column_name_data.SF-1440214.sql 10 May 2007 10:52:59 -0000
1.2
@@ -2,3 +2,5 @@
id int,
data varchar(30) -- DATA is a reserved keyword officially
);
+
+drop table test1440214;
Index: temporary_tables.SF-1715669.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/temporary_tables.SF-1715669.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- temporary_tables.SF-1715669.sql 9 May 2007 14:27:11 -0000 1.1
+++ temporary_tables.SF-1715669.sql 10 May 2007 10:53:00 -0000 1.2
@@ -1,4 +1,4 @@
create TEMPORARY table t1 (id int) ON COMMIT DROP;
-select * from tables;
+select name from tables;
drop table t1;
Index: temporary_tables.SF-1715669.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/temporary_tables.SF-1715669.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- temporary_tables.SF-1715669.stable.out 10 May 2007 07:49:51 -0000
1.1
+++ temporary_tables.SF-1715669.stable.out 10 May 2007 10:53:00 -0000
1.2
@@ -1,65 +1,59 @@
stdout of test 'temporary_tables.SF-1715669` in directory
'src/test/BugTracker` itself:
-# 09:35:56 >
-# 09:35:56 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=32868 --set xrpc_port=47833 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
-# 09:35:56 >
+# 11:44:58 >
+# 11:44:58 > 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
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs"
--set mapi_port=36802 --set xrpc_port=42131 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=' include sql;' ; echo ; echo
Over..
+# 11:44:58 >
-# Monet Database Server V4.17.1
-# Copyright (c) 1993-2007, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
-printf("\nReady.\n");
+
+# MonetDB Server v5.0.0_beta2_1
+# Copyright (c) 1993-2007 CWI, all rights reserved
+# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
+# dbname:mTests_src_test_BugTracker
+# Visit http://monetdb.cwi.nl/ for further information
Ready.
-quit();
Over..
-# 09:35:56 >
-# 09:35:56 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32868
-# 09:35:56 >
+# 11:44:58 >
+# 11:44:58 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36802
+# 11:44:58 >
-% sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables, sys.tables, sys.tables # table_name
-% id, name, schema_id, query, type, system, commit_action,
temporary # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, smallint # type
-% 5, 13, 3, 168, 1, 5, 1, 1 # length
-[ 845, "schemas", 844, NULL, 0, true, 0, 0 ]
-[ 850, "types", 844, NULL, 0, true, 0, 0 ]
-[ 859, "functions", 844, NULL, 0, true, 0, 0 ]
-[ 867, "args", 844, NULL, 0, true, 0, 0 ]
-[ 875, "sequences", 844, NULL, 0, true, 0, 0 ]
-[ 885, "_tables", 844, NULL, 0, true, 0, 0 ]
-[ 893, "_columns", 844, NULL, 0, true, 0, 0 ]
-[ 903, "keys", 844, NULL, 0, true, 0, 0 ]
-[ 910, "idxs", 844, NULL, 0, true, 0, 0 ]
-[ 915, "triggers", 844, NULL, 0, true, 0, 0 ]
-[ 926, "keycolumns", 844, NULL, 0, true, 0, 0 ]
-[ 931, "dependencies", 844, NULL, 0, true, 0, 0 ]
-[ 935, "connections", 844, NULL, 0, true, 0, 0 ]
-[ 945, "_tables", 944, NULL, 0, true, 2, 0 ]
-[ 953, "_columns", 944, NULL, 0, true, 2, 0 ]
-[ 963, "keys", 944, NULL, 0, true, 2, 0 ]
-[ 970, "idxs", 944, NULL, 0, true, 2, 0 ]
-[ 975, "triggers", 944, NULL, 0, true, 2, 0 ]
-[ 986, "keycolumns", 944, NULL, 0, true, 2, 0 ]
-[ 3263, "tables", 844, "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, 0 ]
-[ 3272, "columns", 844, "SELECT * FROM (SELECT p.* FROM
\"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t)
AS columns;", 1, true, 0, 0 ]
-[ 3291, "db_users", 844, NULL, 0, true, 0, 0
]
-[ 3296, "users", 844, "SELECT \"name\", \"fullname\",
\"default_schema\" FROM \"sys\".\"db_users\";", 1, true, 0, 0
]
-[ 3300, "user_role", 844, NULL, 0, true, 0, 0
]
-[ 3303, "auths", 844, NULL, 0, true, 0, 0
]
-[ 3307, "privileges", 844, NULL, 0, true, 0, 0
]
-[ 3313, "profile", 944, NULL, 0, true, 2, 0
]
-[ 8413, "test1440214", 844, NULL, 0, false, 0, 0
]
-[ 12108, "system", 844, NULL, 0, false, 0, 0
]
-[ 12121, "target", 844, NULL, 0, false, 0, 0
]
-[ 12132, "configuration", 844, NULL, 0, false, 0,
0 ]
-[ 13844, "test", 844, NULL, 0, false, 0, 0 ]
-[ 25744, "xy", 844, NULL, 0, false, 0, 0 ]
+% sys.tables # table_name
+% name # name
+% varchar # type
+% 12 # length
+[ "schemas" ]
+[ "types" ]
+[ "functions" ]
+[ "args" ]
+[ "sequences" ]
+[ "_tables" ]
+[ "_columns" ]
+[ "keys" ]
+[ "idxs" ]
+[ "triggers" ]
+[ "keycolumns" ]
+[ "dependencies" ]
+[ "connections" ]
+[ "_tables" ]
+[ "_columns" ]
+[ "keys" ]
+[ "idxs" ]
+[ "triggers" ]
+[ "keycolumns" ]
+[ "tables" ]
+[ "columns" ]
+[ "db_user_info" ]
+[ "users" ]
+[ "user_role" ]
+[ "auths" ]
+[ "privileges" ]
+[ "profile" ]
-# 09:35:56 >
-# 09:35:56 > Done.
-# 09:35:56 >
+# 11:44:58 >
+# 11:44:58 > Done.
+# 11:44:58 >
Index: sequence_not_stored_3.SF-1509894.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/sequence_not_stored_3.SF-1509894.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- sequence_not_stored_3.SF-1509894.sql 21 Jun 2006 21:30:10 -0000
1.2
+++ sequence_not_stored_3.SF-1509894.sql 10 May 2007 10:53:00 -0000
1.3
@@ -1 +1,2 @@
insert into test (val) values (1);
+drop table test;
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
