Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv31693/src/test/BugTracker/Tests
Modified Files:
All
Added Files:
bind_with_cast.SF-1720934.sql
bind_with_cast.SF-1720934.stable.err
bind_with_cast.SF-1720934.stable.out
Log Message:
renamed sql_prelude to sqlinit
fixed bug (crash) in parameters in cast expression
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.54
retrieving revision 1.55
diff -u -d -r1.54 -r1.55
--- All 16 May 2007 20:45:07 -0000 1.54
+++ All 19 May 2007 12:18:15 -0000 1.55
@@ -68,3 +68,4 @@
decimal.SF-1718253
alter-default.SF-1695290
with_only_once.SF-1720293
+bind_with_cast.SF-1720934
--- NEW FILE: bind_with_cast.SF-1720934.stable.out ---
stdout of test 'bind_with_cast.SF-1720934` in directory 'src/test/BugTracker`
itself:
# 14:16:53 >
# 14:16:53 > 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=32953 --set xrpc_port=47402 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 14:16:53 >
# 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..
# 14:16:53 >
# 14:16:53 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32953
# 14:16:53 >
% prepare, prepare, prepare # table_name
% type, digits, scale # name
% varchar, int, int # type
% 0, 0, 0 # length
[ "int", 32, 0 ]
# 14:16:53 >
# 14:16:53 > Done.
# 14:16:53 >
--- NEW FILE: bind_with_cast.SF-1720934.sql ---
CREATE TABLE data_1mto10m (
id INTEGER,
col1 INTEGER,
col2 VARCHAR(5)
) ;
PREPARE select id from data_1mto10m where id > CAST(? AS INTEGER) limit 10;
exec 0('100');
--- NEW FILE: bind_with_cast.SF-1720934.stable.err ---
stderr of test 'bind_with_cast.SF-1720934` in directory 'src/test/BugTracker`
itself:
# 14:16:53 >
# 14:16:53 > 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=32953 --set xrpc_port=47402 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 14:16:53 >
# 14:16:53 >
# 14:16:53 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32953
# 14:16:53 >
MAPI = [EMAIL PROTECTED]:32953
QUERY = exec 0('100');
ERROR = !wrong argument for prepared statement (expected int instead of char)
# 14:16:53 >
# 14:16:53 > Done.
# 14:16:53 >
-------------------------------------------------------------------------
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
