Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv23359
Modified Files:
All
Added Files:
decimal.SF-1718253.sql decimal.SF-1718253.stable.err
decimal.SF-1718253.stable.out
Log Message:
added test with stable output for bug
[ 1718253 ] SQL: decimal handling errors
--- NEW FILE: decimal.SF-1718253.sql ---
create table t( i decimal(10,4) default null);
insert into t values('1.12345');
insert into t values('1.1234');
insert into t values('1.123');
insert into t values('1.12');
insert into t values('1.1');
insert into t values('1.');
select * from t;
drop table t;
--- NEW FILE: decimal.SF-1718253.stable.err ---
stderr of test 'decimal.SF-1718253` in directory 'src/test/BugTracker` itself:
# 20:08:09 >
# 20:08:09 > 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=33854 --set xrpc_port=48575 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 20:08:09 >
# 20:08:10 >
# 20:08:10 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33854
# 20:08:10 >
# 20:08:10 >
# 20:08:10 > Done.
# 20:08:10 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.50
retrieving revision 1.51
diff -u -d -r1.50 -r1.51
--- All 12 May 2007 22:22:49 -0000 1.50
+++ All 13 May 2007 18:09:58 -0000 1.51
@@ -64,4 +64,4 @@
temporary_tables.SF-1715669
like_for_time_values.SF-1715659
local_global_temporary_table.SF-1715672
-
+decimal.SF-1718253
--- NEW FILE: decimal.SF-1718253.stable.out ---
stdout of test 'decimal.SF-1718253` in directory 'src/test/BugTracker` itself:
# 20:08:09 >
# 20:08:09 > 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=33854 --set xrpc_port=48575 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 20:08:09 >
# 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");
Ready.
quit();
Over..
# 20:08:10 >
# 20:08:10 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33854
# 20:08:10 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
% sys.t # table_name
% i # name
% decimal # type
% 12 # length
[ 1.1235 ]
[ 1.1234 ]
[ 1.1230 ]
[ 1.1200 ]
[ 1.1000 ]
[ 1.0000 ]
# 20:08:10 >
# 20:08:10 > Done.
# 20:08:10 >
-------------------------------------------------------------------------
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
