Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv16175
Modified Files:
All
Added Files:
range_predicate.SF-1711242.sql
range_predicate.SF-1711242.stable.err
range_predicate.SF-1711242.stable.out
Log Message:
add test with stable out for bug in handling range predicates
--- NEW FILE: range_predicate.SF-1711242.stable.err ---
stderr of test 'range_predicate.SF-1711242` in directory 'src/test/BugTracker`
itself:
# 00:17:02 >
# 00:17:02 > 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=36932 --set xrpc_port=42466 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 00:17:02 >
# 00:17:02 >
# 00:17:02 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36932
# 00:17:02 >
# 00:17:03 >
# 00:17:03 > Done.
# 00:17:03 >
--- NEW FILE: range_predicate.SF-1711242.stable.out ---
stdout of test 'range_predicate.SF-1711242` in directory 'src/test/BugTracker`
itself:
# 00:17:02 >
# 00:17:02 > 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=36932 --set xrpc_port=42466 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 00:17:02 >
# 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..
# 00:17:02 >
# 00:17:02 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36932
# 00:17:02 >
% sys.c0002, sys.c0002, sys.c0002, sys.c0002, sys.c0002 #
table_name
% pre, size, level, kind, prop # name
% int, int, smallint, smallint, char # type
% 1, 1, 1, 1, 32 # length
[ 1, 1, 1, 1, "foo" ]
[ 2, 0, 2, 1, "bar" ]
% sys.c0002, sys.c0002, sys.c0002, sys.c0002, sys.c0002 #
table_name
% pre, size, level, kind, prop # name
% int, int, smallint, smallint, char # type
% 1, 1, 1, 1, 32 # length
[ 1, 1, 1, 1, "foo" ]
[ 2, 0, 2, 1, "bar" ]
# 00:17:03 >
# 00:17:03 > Done.
# 00:17:03 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.49
retrieving revision 1.50
diff -u -d -r1.49 -r1.50
--- All 9 May 2007 14:27:09 -0000 1.49
+++ All 12 May 2007 22:22:49 -0000 1.50
@@ -53,6 +53,7 @@
prepare_decimal_float.SF-1675795
crash_on_fkey_update.SF-1703497
variable_stack_crash_load.SF-1711251
+range_predicate.SF-1711242
variable_stack_crash.SF-1711251
variable_stack_crash.SF-1711251-2
variable_stack_crash_drop.SF-1711251
--- NEW FILE: range_predicate.SF-1711242.sql ---
SELECT c0002.* FROM test1711251 AS c0002, test1711251 AS c0001 WHERE c0001.pre
+ c0001.size >= c0002.pre AND c0002.pre > c0001.pre AND c0001.prop =
'auctionG.xml';
SELECT c0002.* FROM test1711251 AS c0002, test1711251 AS c0001 WHERE c0002.pre
> c0001.pre AND c0001.prop = 'auctionG.xml';
-------------------------------------------------------------------------
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
