Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv15769
Modified Files:
Tag: SQL_2-18
All
Added Files:
Tag: SQL_2-18
float2dec.sql float2dec.stable.err float2dec.stable.out
Log Message:
added test for problem with casts from float to decimal on m5
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/All,v
retrieving revision 1.93
retrieving revision 1.93.2.1
diff -u -d -r1.93 -r1.93.2.1
--- All 27 Apr 2007 09:45:56 -0000 1.93
+++ All 29 Jun 2007 11:18:18 -0000 1.93.2.1
@@ -66,3 +66,4 @@
predicate_or-sf-1409824
alter_view
simple_view
+float2dec
--- NEW FILE: float2dec.stable.err ---
stderr of test 'float2dec` in directory 'src/test/bugs` itself:
# 13:12:17 >
# 13:12:17 > Mtimeout -timeout 180 mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/xquery_logs"
--set mapi_open=true --set mapi_port=31519 --set xrpc_port=43468 --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs" --dbinit=' include sql;'
; echo ; echo Over..
# 13:12:17 >
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf)
# 13:12:17 >
# 13:12:17 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=31519
# 13:12:17 >
# 13:12:18 >
# 13:12:18 > Done.
# 13:12:18 >
--- NEW FILE: float2dec.stable.out ---
stdout of test 'float2dec` in directory 'src/test/bugs` itself:
# 13:12:17 >
# 13:12:17 > Mtimeout -timeout 180 mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/xquery_logs"
--set mapi_open=true --set mapi_port=31519 --set xrpc_port=43468 --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs" --dbinit=' include sql;'
; echo ; echo Over..
# 13:12:17 >
# MonetDB Server v5.0.0
# 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_bugs
# Visit http://monetdb.cwi.nl/ for further information
Ready.
Over..
# 13:12:17 >
# 13:12:17 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=31519
# 13:12:17 >
[ 1 ]
% sys. # table_name
% avg_col # name
% decimal # type
% 6 # length
[ 74.95 ]
# 13:12:18 >
# 13:12:18 > Done.
# 13:12:18 >
--- NEW FILE: float2dec.sql ---
create table float2dec (col float);
insert into float2dec values (74.95);
select CAST(AVG(col) as decimal(4,2)) from float2dec;
drop table float2dec;
-------------------------------------------------------------------------
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
