Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv18605
Modified Files:
create_table_with_data.SF-1715679.sql
create_table_with_data.SF-1715679.stable.out
subquery_orderby.SF-1688915.stable.out
temporary_tables.SF-1715669.sql
temporary_tables.SF-1715669.stable.out
Log Message:
Remove table tables which should not be used in the test examples..
Index: create_table_with_data.SF-1715679.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/create_table_with_data.SF-1715679.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- create_table_with_data.SF-1715679.stable.out 10 May 2007 09:32:46
-0000 1.2
+++ create_table_with_data.SF-1715679.stable.out 10 May 2007 12:20:59
-0000 1.3
@@ -5,56 +5,41 @@
# 11:31:41 > 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=32335 --set xrpc_port=44303 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=' include sql;' ; echo ; echo
Over..
# 11:31:41 >
-
-
-# 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
+printf("\nReady.\n");
Ready.
+quit();
Over..
-# 10:18:19 >
-# 10:18:19 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=38149
-# 10:18:19 >
+# 14:16:53 >
+# 14:16:53 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=39662
+# 14:16:53 >
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
% sys.t1 # table_name
-% name # name
-% varchar # type
-% 12 # length
-[ "_columns" ]
-[ "_columns" ]
-[ "_tables" ]
-[ "_tables" ]
-[ "args" ]
-[ "auths" ]
-[ "columns" ]
-[ "connections" ]
-[ "db_user_info" ]
-[ "dependencies" ]
-[ "functions" ]
-[ "idxs" ]
-[ "idxs" ]
-[ "keycolumns" ]
-[ "keycolumns" ]
-[ "keys" ]
-[ "keys" ]
-[ "privileges" ]
-[ "profile" ]
-[ "schemas" ]
-[ "sequences" ]
-[ "t1" ]
-[ "tables" ]
-[ "triggers" ]
-[ "triggers" ]
-[ "types" ]
-[ "user_role" ]
-[ "users" ]
+% id # name
+% int # type
+% 1 # length
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
+[ 7 ]
+[ 8 ]
+[ 9 ]
-# 11:31:41 >
-# 11:31:41 > Done.
-# 11:31:41 >
+# 14:16:53 >
+# 14:16:53 > Done.
+# 14:16:53 >
Index: create_table_with_data.SF-1715679.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/create_table_with_data.SF-1715679.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- create_table_with_data.SF-1715679.sql 10 May 2007 09:32:45 -0000
1.2
+++ create_table_with_data.SF-1715679.sql 10 May 2007 12:20:59 -0000
1.3
@@ -1,5 +1,18 @@
-create table t1 as select name from tables order by name asc with data;
---create table t1 as select id from tables with data;
-select name from t1;
+create table t2 (id int);
+
+insert into t2 values(1);
+insert into t2 values(2);
+insert into t2 values(3);
+insert into t2 values(4);
+insert into t2 values(5);
+insert into t2 values(6);
+insert into t2 values(7);
+insert into t2 values(8);
+insert into t2 values(9);
+
+
+create table t1 as select * from t2 order by id asc with data;
+select * from t1;
drop table t1;
+drop table t2;
Index: subquery_orderby.SF-1688915.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/subquery_orderby.SF-1688915.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- subquery_orderby.SF-1688915.stable.out 1 Apr 2007 22:08:59 -0000
1.2
+++ subquery_orderby.SF-1688915.stable.out 10 May 2007 12:20:59 -0000
1.3
@@ -24,7 +24,7 @@
% .x # table_name
% name # name
% varchar # type
-% 13 # length
+% 12 # length
[ "schemas" ]
[ "types" ]
[ "functions" ]
@@ -52,13 +52,8 @@
[ "auths" ]
[ "privileges" ]
[ "profile" ]
-[ "test1440214" ]
-[ "system" ]
-[ "target" ]
-[ "configuration" ]
-[ "test" ]
-# 10:11:41 >
-# 10:11:41 > Done.
-# 10:11:41 >
+# 14:16:47 >
+# 14:16:47 > Done.
+# 14:16:47 >
Index: temporary_tables.SF-1715669.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/temporary_tables.SF-1715669.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- temporary_tables.SF-1715669.sql 10 May 2007 10:53:00 -0000 1.2
+++ temporary_tables.SF-1715669.sql 10 May 2007 12:21:00 -0000 1.3
@@ -1,4 +1,4 @@
create TEMPORARY table t1 (id int) ON COMMIT DROP;
-select name from tables;
+select name from tables where name = 't1';
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.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- temporary_tables.SF-1715669.stable.out 10 May 2007 10:53:00 -0000
1.2
+++ temporary_tables.SF-1715669.stable.out 10 May 2007 12:21:01 -0000
1.3
@@ -5,15 +5,10 @@
# 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 >
-
-
-# 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
+printf("\nReady.\n");
Ready.
+quit();
Over..
@@ -24,36 +19,9 @@
% 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" ]
+% 0 # length
-# 11:44:58 >
-# 11:44:58 > Done.
-# 11:44:58 >
+# 14:13:56 >
+# 14:13:56 > Done.
+# 14:13:56 >
-------------------------------------------------------------------------
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
