Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv19050/src/test/BugTracker/Tests
Modified Files:
All
Added Files:
convert_dec2varchar.SF-1774312.sql
convert_dec2varchar.SF-1774312.stable.err
convert_dec2varchar.SF-1774312.stable.out
convert_dec2varchar_crash.SF-1775550.sql
convert_dec2varchar_crash.SF-1775550.stable.err
convert_dec2varchar_crash.SF-1775550.stable.out
limit_timestampz.SF-1774217.sql
limit_timestampz.SF-1774217.stable.err
limit_timestampz.SF-1774217.stable.out
Log Message:
propagated changes of Wednesday Aug 01 2007 - Friday Aug 17 2007
from the SQL_2-18 branch to the development trunk
There were conflicts in the following files:
src/benchmarks/arno/Tests/check0a.stable.out
src/benchmarks/arno/Tests/check1a.stable.out
src/common/sql_types.mx
src/test/BugTracker/Tests/All
src/test/Tests/rank.stable.out
src/test/leaks/Tests/check0.stable.out
src/test/leaks/Tests/check1.stable.out
src/test/leaks/Tests/check2.stable.out
src/test/leaks/Tests/check3.stable.out
src/test/leaks/Tests/check4.stable.out
src/test/leaks/Tests/check5.stable.out
Please have a look at my resolution of src/common/sql_types.mx.
I have not attempted to resolve the conflicts in the stable.out files,
so please take a look and approve if necessary.
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.62
retrieving revision 1.63
diff -u -d -r1.62 -r1.63
--- All 17 Jul 2007 11:13:07 -0000 1.62
+++ All 17 Aug 2007 14:58:08 -0000 1.63
@@ -77,3 +77,6 @@
select_id_not_in_another_select.SF-1737777
crash_on_concurrent_use.SF-1411926
HAVE_JAVA?explain.SF-1739353
+limit_timestampz.SF-1774217
+convert_dec2varchar.SF-1774312
+convert_dec2varchar_crash.SF-1775550
--- NEW FILE: convert_dec2varchar_crash.SF-1775550.sql ---
select 11.456;
select 11.456 || 'hi';
--- NEW FILE: convert_dec2varchar.SF-1774312.stable.err ---
stderr of test 'convert_dec2varchar.SF-1774312` in directory
'src/test/BugTracker` itself:
# 23:35:36 >
# 23:35:36 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=33233 --set
xrpc_port=44672 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 23:35:36 >
# 23:35:37 >
# 23:35:37 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33233
# 23:35:37 >
# 23:35:37 >
# 23:35:37 > Done.
# 23:35:37 >
--- NEW FILE: limit_timestampz.SF-1774217.sql ---
create table t1 (
nr integer auto_increment,
tr_time timestamp(3) with time zone
)
;
insert into t1 (tr_time)
select *
from
(
select timestamp with time zone '2005-04-12 06:30-07:00' as tr_time
union
select timestamp with time zone '2005-04-12 07:30-07:00' as tr_time
union
select timestamp with time zone '2005-04-12 05:30-07:00' as tr_time
union
select timestamp with time zone '2005-04-12 05:35-07:00' as tr_time
union
select timestamp with time zone '2005-04-12 07:15-07:00' as tr_time
) as foo
;
-- this will crash server
select nr from t1
order by tr_time
limit 3
;
--- NEW FILE: convert_dec2varchar.SF-1774312.sql ---
select tr, cast(tr as varchar(10)) from (select 11.34555 as tr) as foo;
--- NEW FILE: limit_timestampz.SF-1774217.stable.err ---
stderr of test 'limit_timestampz.SF-1774217` in directory 'src/test/BugTracker`
itself:
# 23:35:36 >
# 23:35:36 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=33233 --set
xrpc_port=44672 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 23:35:36 >
# 23:35:36 >
# 23:35:36 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33233
# 23:35:36 >
# 23:35:36 >
# 23:35:36 > Done.
# 23:35:36 >
--- NEW FILE: limit_timestampz.SF-1774217.stable.out ---
stdout of test 'limit_timestampz.SF-1774217` in directory 'src/test/BugTracker`
itself:
# 23:35:36 >
# 23:35:36 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=33233 --set
xrpc_port=44672 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 23:35:36 >
# Monet Database Server V4.18.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..
# 23:35:36 >
# 23:35:36 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33233
# 23:35:36 >
[ 5 ]
% sys.t1 # table_name
% nr # name
% int # type
% 1 # length
[ 3 ]
[ 4 ]
[ 1 ]
# 09:08:26 >
# 09:08:26 > Done.
# 09:08:26 >
--- NEW FILE: convert_dec2varchar_crash.SF-1775550.stable.err ---
stderr of test 'convert_dec2varchar_crash.SF-1775550` in directory
'src/test/BugTracker` itself:
# 23:35:37 >
# 23:35:37 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=33233 --set
xrpc_port=44672 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 23:35:37 >
# 23:35:37 >
# 23:35:37 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33233
# 23:35:37 >
# 23:35:37 >
# 23:35:37 > Done.
# 23:35:37 >
--- NEW FILE: convert_dec2varchar.SF-1774312.stable.out ---
stdout of test 'convert_dec2varchar.SF-1774312` in directory
'src/test/BugTracker` itself:
# 23:35:36 >
# 23:35:36 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=33233 --set
xrpc_port=44672 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 23:35:36 >
# Monet Database Server V4.18.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..
# 23:35:37 >
# 23:35:37 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33233
# 23:35:37 >
% .foo, . # table_name
% tr, tr # name
% decimal, varchar # type
% 9, 8 # length
[ 11.34555, "11.34555" ]
# 23:35:37 >
# 23:35:37 > Done.
# 23:35:37 >
--- NEW FILE: convert_dec2varchar_crash.SF-1775550.stable.out ---
stdout of test 'convert_dec2varchar_crash.SF-1775550` in directory
'src/test/BugTracker` itself:
# 23:35:37 >
# 23:35:37 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=33233 --set
xrpc_port=44672 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 23:35:37 >
# Monet Database Server V4.18.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..
# 23:35:37 >
# 23:35:37 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33233
# 23:35:37 >
% . # table_name
% single_value # name
% decimal # type
% 7 # length
[ 11.456 ]
% . # table_name
% concat_single_value # name
% char # type
% 0 # length
[ "11.456hi" ]
# 23:35:37 >
# 23:35:37 > Done.
# 23:35:37 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
