Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory 
sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv18804/src/test/BugTracker/Tests

Modified Files:
        All 
Added Files:
        decimal_prepare.SF-1655818.sql 
        decimal_prepare.SF-1655818.stable.err 
        decimal_prepare.SF-1655818.stable.out 
Log Message:
propagated changes of Wednesday Feb 07 2007 - Friday Feb 09 2007
from the SQL_2-16 branch to the development trunk



--- NEW FILE: decimal_prepare.SF-1655818.stable.err ---
stderr of test 'decimal_prepare.SF-1655818` in directory 'src/test/BugTracker` 
itself:


# 11:47:08 >  
# 11:47:08 >  Mtimeout -timeout 180 mserver5 
"--config=/ufs/fabian/scratch/monetdb/stable/program-x86_64/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5/lib:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5/bin"
 --set 
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-pegasus.ins.cwi.nl/sql/dbfarm"
 --set 
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-pegasus.ins.cwi.nl/sql/sqllog"
 --set 
"xquery_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-pegasus.ins.cwi.nl/sql/xquerylog"
 --set mapi_port=33419 --set monet_prompt= --trace 
"--dbname=mTests_src_test_BugTracker" --dbinit='include sql;' ; echo ; echo 
Over..
# 11:47:08 >  

# builtin opt   gdk_arch = 64bitx86_64-pc-linux-gnu
# builtin opt   gdk_version = 1.16.1
# builtin opt   monet_pid = 12784
# builtin opt   prefix = /ufs/fabian/scratch/monetdb/stable/program-x86_64
# builtin opt   exec_prefix = ${prefix}
# builtin opt   gdk_dbname = tst
# builtin opt   gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt   gdk_debug = 8
# builtin opt   gdk_mem_bigsize = 262144
# builtin opt   gdk_vm_minsize = 137438953472
# builtin opt   gdk_alloc_map = yes
# builtin opt   gdk_mem_pagebits = 14
# builtin opt   monet_admin = adm
# builtin opt   monet_prompt = >
# builtin opt   monet_welcome = yes
# builtin opt   monet_mod_path = 
/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/bin
# builtin opt   monet_daemon = yes
# builtin opt   host = localhost
# builtin opt   mapi_port = 50000
# builtin opt   mapi_noheaders = no
# builtin opt   mapi_debug = 0
# builtin opt   mapi_clients = 2
# builtin opt   sql_debug = 0
# builtin opt   sql_logdir = ${prefix}/var/MonetDB/sql_logs
# builtin opt   xquery_logdir = ${prefix}/var/MonetDB/xquery_logs
# builtin opt   standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt   standoff_start = start
# builtin opt   standoff_end = end
# config opt    prefix = /ufs/fabian/scratch/monetdb/stable/program-x86_64
# config opt    config = ${prefix}/etc/monetdb5.conf
# config opt    prefix = /ufs/fabian/scratch/monetdb/stable/program-x86_64
# config opt    exec_prefix = ${prefix}
# config opt    gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt    gdk_dbname = demo
# config opt    gdk_version = 5.0.0_beta1_1
# config opt    gdk_alloc_map = no
# config opt    gdk_embedded = no
# config opt    gdk_debug = 0
# config opt    monet_mod_path = 
/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5/lib:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5/bin
# config opt    monet_daemon = no
# config opt    monet_welcome = yes
# config opt    delay = 120
# config opt    mal_init = 
/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5/mal_init.mal
# config opt    mal_listing = 15
# config opt    checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt
# config opt    mapi_port = 0
# config opt    sql_debug = 0
# config opt    sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt    pf_httpd_port = 8080
# config opt    xquery_output = dm
# config opt    xquery_cacheMB = 100
# config opt    xquery_logdir = ${prefix}/var/MonetDB5/xquery_logs
# cmdline opt   config = 
/ufs/fabian/scratch/monetdb/stable/program-x86_64/etc/monetdb5.conf
# cmdline opt   gdk_debug = 10
# cmdline opt   monet_mod_path = 
/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5/lib:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5/bin
# cmdline opt   gdk_dbfarm = 
/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-pegasus.ins.cwi.nl/sql/dbfarm
# cmdline opt   sql_logdir = 
/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-pegasus.ins.cwi.nl/sql/sqllog
# cmdline opt   xquery_logdir = 
/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-pegasus.ins.cwi.nl/sql/xquerylog
# cmdline opt   mapi_port = 33419
# cmdline opt   monet_prompt = 
# cmdline opt   gdk_dbname = mTests_src_test_BugTracker
#warning: please don't forget to set your vault key!
#(see /ufs/fabian/scratch/monetdb/stable/program-x86_64/etc/monetdb5.conf)

# 11:47:08 >  
# 11:47:08 >  Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb 
--host=localhost --port=33419  < decimal_prepare.SF-1655818.sql
# 11:47:08 >  


# 11:47:08 >  
# 11:47:08 >  Done.
# 11:47:08 >  


--- NEW FILE: decimal_prepare.SF-1655818.stable.out ---
stdout of test 'decimal_prepare.SF-1655818` in directory 'src/test/BugTracker` 
itself:


# 11:47:08 >  
# 11:47:08 >  Mtimeout -timeout 180 mserver5 
"--config=/ufs/fabian/scratch/monetdb/stable/program-x86_64/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5/lib:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib64/MonetDB5/bin"
 --set 
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-pegasus.ins.cwi.nl/sql/dbfarm"
 --set 
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-pegasus.ins.cwi.nl/sql/sqllog"
 --set 
"xquery_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-pegasus.ins.cwi.nl/sql/xquerylog"
 --set mapi_port=33419 --set monet_prompt= --trace 
"--dbname=mTests_src_test_BugTracker" --dbinit='include sql;' ; echo ; echo 
Over..
# 11:47:08 >  



# MonetDB Server v5.0.0_beta1_1
# Copyright (c) 1993-2007 CWI, all rights reserved
# Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
# dbname:mTests_src_test_BugTracker
# Visit http://monetdb.cwi.nl/ for further information

Ready.

Over..

# 11:47:08 >  
# 11:47:08 >  Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb 
--host=localhost --port=33419  < decimal_prepare.SF-1655818.sql
# 11:47:08 >  

% prepare,      prepare,        prepare # table_name
% type, digits, scale # name
% varchar,      int,    int # type
% 0,    0,      0 # length
[ "timestamp",  7,      0       ]
[ "decimal",    5,      2       ]
[ "decimal",    5,      2       ]
[ 1     ]

# 11:47:08 >  
# 11:47:08 >  Done.
# 11:47:08 >  


Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.42
retrieving revision 1.43
diff -u -d -r1.42 -r1.43
--- All 4 Feb 2007 22:55:19 -0000       1.42
+++ All 9 Feb 2007 23:19:40 -0000       1.43
@@ -43,3 +43,4 @@
 create_column.SF-1643542
 cache
 caching.SF-1651599
+decimal_prepare.SF-1655818

--- NEW FILE: decimal_prepare.SF-1655818.sql ---
-- origin: Anders Blaagaard

START TRANSACTION;

create table P1655818 (
        time timestamp not null,
        x numeric(5,2) not null,
        y numeric(5,2) not null
);

PREPARE insert into P1655818 (time,x,y) values (?,?,?);

exec 0(timestamp '2003-01-30 18:03:35.0', 71.91, 71.98);

ROLLBACK;


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to