Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv22811/src/test/BugTracker/Tests
Modified Files:
All
Added Files:
BETWEEN_error.SF-1911991.sql
BETWEEN_error.SF-1911991.stable.err
BETWEEN_error.SF-1911991.stable.out
Log Message:
propagated changes of Wednesday Mar 19 2008
from the SQL_2-22 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/03/19 - stmane: src/test/BugTracker/Tests/All,1.80.2.8(SQL_2-22)
added test for bug
[ 1911991 ] BETWEEN returns wrong results
https://sourceforge.net/tracker/index.php?func=detail&aid=1911991&group_id=56967&atid=482468
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: BETWEEN_error.SF-1911991.stable.out ---
stdout of test 'BETWEEN_error.SF-1911991` in directory 'src/test/BugTracker`
itself:
# 09:22:38 >
# 09:22:38 > Mserver
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB4/sql_logs"
--set "xquery_logdir=/ufs/manegold/_/scratch0/Monet/Testin
g/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31237 --set
xrpc_port=43099 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" "--dbinit= module(sql_server);" ; echo ;
echo Over..
# 09:22:38 >
# MonetDB Server v4.22.1
# based on GDK v1.22.1
# Copyright (c) 1993-2008, CWI. All rights reserved.
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
# MonetDB/SQL module v2.22.1 loaded
printf("\nReady.\n");
Ready.
quit();
Over..
# 09:22:38 >
# 09:22:38 > mclient -lsql -umonetdb -Pmonetdb --host=corona --port=31237
# 09:22:38 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
% sys.t1911991 # table_name
% id # name
% int # type
% 1 # length
[ 0 ]
[ 1 ]
[ 2 ]
[ 3 ]
[ 4 ]
[ 5 ]
[ 6 ]
[ 7 ]
[ 8 ]
[ 9 ]
% sys.t1911991 # table_name
% id # name
% int # type
% 1 # length
[ 7 ]
[ 8 ]
[ 9 ]
% sys.t1911991 # table_name
% id # name
% int # type
% 1 # length
[ 0 ]
[ 1 ]
[ 2 ]
# 09:22:38 >
# 09:22:38 > Done.
# 09:22:38 >
--- NEW FILE: BETWEEN_error.SF-1911991.stable.err ---
stderr of test 'BETWEEN_error.SF-1911991` in directory 'src/test/BugTracker`
itself:
# 09:22:38 >
# 09:22:38 > Mserver
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB4/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB4/sql_logs"
--set "xquery_logdir=/ufs/manegold/_/scratch0/Monet/Testin
g/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31237 --set
xrpc_port=43099 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" "--dbinit= module(sql_server);" ; echo ;
echo Over..
# 09:22:38 >
# 09:22:38 >
# 09:22:38 > mclient -lsql -umonetdb -Pmonetdb --host=corona --port=31237
# 09:22:38 >
# 09:22:38 >
# 09:22:38 > Done.
# 09:22:38 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.87
retrieving revision 1.88
diff -u -d -r1.87 -r1.88
--- All 14 Mar 2008 12:46:37 -0000 1.87
+++ All 19 Mar 2008 21:37:48 -0000 1.88
@@ -111,3 +111,4 @@
coalesce_equal_coalesce.SF-1907905
like_perl.SF-1907051
sql_prepare_prob.SF-1909638
+BETWEEN_error.SF-1911991
--- NEW FILE: BETWEEN_error.SF-1911991.sql ---
create table t1911991 (id int);
insert into t1911991 values (0);
insert into t1911991 values (1);
insert into t1911991 values (2);
insert into t1911991 values (3);
insert into t1911991 values (4);
insert into t1911991 values (5);
insert into t1911991 values (6);
insert into t1911991 values (7);
insert into t1911991 values (8);
insert into t1911991 values (9);
select * from t1911991;
select * from t1911991 WHERE (id - 5) BETWEEN 2 AND 7;
select * from t1911991 WHERE (4 - id) BETWEEN 2 AND 7;
drop table t1911991;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
