Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv13963
Modified Files:
set_default_value.SF-1715553.sql
Added Files:
set_default_value.SF-1715553.stable.err
set_default_value.SF-1715553.stable.out
Log Message:
Approve out and err output...
--- NEW FILE: set_default_value.SF-1715553.stable.out ---
stdout of test 'set_default_value.SF-1715553` in directory
'src/test/BugTracker` itself:
# 00:12:35 >
# 00:12:35 > 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=35378 --set xrpc_port=47655 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=' include sql;' ; echo ; echo
Over..
# 00:12:35 >
# 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.
Over..
# 00:12:35 >
# 00:12:35 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35378
# 00:12:35 >
% sys.columns, sys.columns, sys.columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 2, 5 # length
[ "id", "50", true ]
% sys.columns, sys.columns, sys.columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 2, 5 # length
[ "id", "30", true ]
% sys.columns, sys.columns, sys.columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
[ "id", NULL, true ]
% sys.columns, sys.columns, sys.columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
[ "id", NULL, true ]
% sys.columns, sys.columns, sys.columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
[ "id", NULL, true ]
% sys.columns, sys.columns, sys.columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
[ "id", NULL, true ]
% sys.columns, sys.columns, sys.columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
[ "id", NULL, false ]
# 00:12:36 >
# 00:12:36 > Done.
# 00:12:36 >
--- NEW FILE: set_default_value.SF-1715553.stable.err ---
stderr of test 'set_default_value.SF-1715553` in directory
'src/test/BugTracker` itself:
# 00:12:35 >
# 00:12:35 > 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=35378 --set xrpc_port=47655 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=' include sql;' ; echo ; echo
Over..
# 00:12:35 >
#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf)
# 00:12:35 >
# 00:12:35 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35378
# 00:12:35 >
# 00:12:36 >
# 00:12:36 > Done.
# 00:12:36 >
Index: set_default_value.SF-1715553.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/set_default_value.SF-1715553.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- set_default_value.SF-1715553.sql 9 May 2007 14:27:11 -0000 1.1
+++ set_default_value.SF-1715553.sql 9 May 2007 22:16:52 -0000 1.2
@@ -1,6 +1,20 @@
-create table t1(id int, name varchar(1024), age int );
+create table t1(id int DEFAULT 50, name varchar(1024), age int );
+select name, "default", "null" from columns where name = 'id' and table_id =
(select id from tables where name = 't1');
+alter table t1 alter id set DEFAULT 30;
+select name, "default", "null" from columns where name = 'id' and table_id =
(select id from tables where name = 't1');
+alter table t1 alter id DROP DEFAULT;
+select name, "default", "null" from columns where name = 'id' and table_id =
(select id from tables where name = 't1');
+drop table t1;
-alter table t1 alter id set DEFAULT RANK() OVER (PARTITION BY id, age ORDER
-BY id DESC);
+create table t1(id int, name varchar(1024), age int );
+select name, "default", "null" from columns where name = 'id' and table_id =
(select id from tables where name = 't1');
+alter table t1 alter id set NULL;
+select name, "default", "null" from columns where name = 'id' and table_id =
(select id from tables where name = 't1');
+drop table t1;
+create table t1(id int, name varchar(1024), age int );
+select name, "default", "null" from columns where name = 'id' and table_id =
(select id from tables where name = 't1');
+alter table t1 alter id set NOT NULL;
+select name, "default", "null" from columns where name = 'id' and table_id =
(select id from tables where name = 't1');
drop table t1;
+
-------------------------------------------------------------------------
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
