Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv2296
Modified Files:
All
Added Files:
variable_stack_crash.SF-1711251-2.stable.err
variable_stack_crash.SF-1711251-2.stable.out
variable_stack_crash.SF-1711251.sql
variable_stack_crash.SF-1711251.stable.err
variable_stack_crash.SF-1711251.stable.out
variable_stack_crash_drop.SF-1711251.sql
variable_stack_crash_drop.SF-1711251.stable.err
variable_stack_crash_drop.SF-1711251.stable.out
variable_stack_crash_load.SF-1711251.sql
variable_stack_crash_load.SF-1711251.stable.err
variable_stack_crash_load.SF-1711251.stable.out
Log Message:
added test for bug 1711251
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.46
retrieving revision 1.47
diff -u -d -r1.46 -r1.47
--- All 27 Apr 2007 09:45:54 -0000 1.46
+++ All 6 May 2007 08:59:25 -0000 1.47
@@ -52,3 +52,7 @@
like_join.SF-1684798
prepare_decimal_float.SF-1675795
crash_on_fkey_update.SF-1703497
+variable_stack_crash_load.SF-1711251
+variable_stack_crash.SF-1711251
+variable_stack_crash.SF-1711251-2
+variable_stack_crash_drop.SF-1711251
--- NEW FILE: variable_stack_crash_drop.SF-1711251.stable.out ---
stdout of test 'variable_stack_crash_drop.SF-1711251` in directory
'src/test/BugTracker` itself:
# 10:56:20 >
# 10:56:20 > 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=31258 --set xrpc_port=49123 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:56:20 >
# 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..
# 10:56:20 >
# 10:56:20 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31258
# 10:56:20 >
# 10:56:20 >
# 10:56:20 > Done.
# 10:56:20 >
--- NEW FILE: variable_stack_crash.SF-1711251-2.stable.out ---
stdout of test 'variable_stack_crash.SF-1711251-2` in directory
'src/test/BugTracker` itself:
# 10:56:19 >
# 10:56:19 > 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=31258 --set xrpc_port=49123 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:56:19 >
# 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..
# 10:56:19 >
# 10:56:19 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31258
# 10:56:19 >
% .result, .result # table_name
% pos_nat, item_int # name
% smallint, int # type
% 1, 1 # length
[ 1, 0 ]
# 10:56:19 >
# 10:56:19 > Done.
# 10:56:19 >
--- NEW FILE: variable_stack_crash_drop.SF-1711251.sql ---
drop table test1711251;
--- NEW FILE: variable_stack_crash.SF-1711251.stable.out ---
stdout of test 'variable_stack_crash.SF-1711251` in directory
'src/test/BugTracker` itself:
# 10:56:19 >
# 10:56:19 > 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=31258 --set xrpc_port=49123 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:56:19 >
# 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..
# 10:56:19 >
# 10:56:19 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31258
# 10:56:19 >
% .result, .result # table_name
% pos_nat, item_int # name
% smallint, int # type
% 1, 1 # length
[ 1, 0 ]
# 10:56:19 >
# 10:56:19 > Done.
# 10:56:19 >
--- NEW FILE: variable_stack_crash_load.SF-1711251.sql ---
create table test1711251 (pre integer not null primary key, size integer not
null,
level smallint not null, kind smallint not null, prop char (32));
copy 3 records into test1711251 from stdin DELIMITERS ',';
0, 2, 0, 6, "auctionG.xml"
1, 1, 1, 1, "foo"
2, 0, 2, 1, "bar"
select * from test1711251;
--- NEW FILE: variable_stack_crash_drop.SF-1711251.stable.err ---
stderr of test 'variable_stack_crash_drop.SF-1711251` in directory
'src/test/BugTracker` itself:
# 10:56:20 >
# 10:56:20 > 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=31258 --set xrpc_port=49123 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:56:20 >
# 10:56:20 >
# 10:56:20 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31258
# 10:56:20 >
# 10:56:20 >
# 10:56:20 > Done.
# 10:56:20 >
--- NEW FILE: variable_stack_crash_load.SF-1711251.stable.out ---
stdout of test 'variable_stack_crash_load.SF-1711251` in directory
'src/test/BugTracker` itself:
# 10:56:18 >
# 10:56:18 > 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=31258 --set xrpc_port=49123 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:56:18 >
# 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..
# 10:56:19 >
# 10:56:19 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31258
# 10:56:19 >
[ 3 ]
% sys.test1711251, sys.test1711251, sys.test1711251,
sys.test1711251, sys.test1711251 # table_name
% pre, size, level, kind, prop # name
% int, int, smallint, smallint, char # type
% 1, 1, 1, 1, 32 # length
[ 0, 2, 0, 6, "auctionG.xml" ]
[ 1, 1, 1, 1, "foo" ]
[ 2, 0, 2, 1, "bar" ]
# 10:56:19 >
# 10:56:19 > Done.
# 10:56:19 >
--- NEW FILE: variable_stack_crash_load.SF-1711251.stable.err ---
stderr of test 'variable_stack_crash_load.SF-1711251` in directory
'src/test/BugTracker` itself:
# 10:56:18 >
# 10:56:18 > 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=31258 --set xrpc_port=49123 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:56:18 >
# 10:56:19 >
# 10:56:19 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31258
# 10:56:19 >
# 10:56:19 >
# 10:56:19 > Done.
# 10:56:19 >
--- NEW FILE: variable_stack_crash.SF-1711251.sql ---
WITH
-- Rel: ScjRel
-- Binding due to: dirty node
a0000(item_pre, iter_nat) AS
(SELECT DISTINCT c0002.pre, 1 AS iter_nat
FROM test1711251 AS c0002,
test1711251 AS c0001
WHERE (((c0001.pre + c0001.size) >= c0002.pre) AND ((c0002.pre >
c0001.pre)
AND ((c0002.kind = 1) AND ((c0002.prop = 'open_auction') AND
((c0001.prop = 'auctionG.xml') AND (c0001.kind = 6))))))),
-- Rel: count(Rel)
-- Binding due to: dirty node
a0001(item_int) AS
(SELECT COUNT (*) AS item_int
FROM a0000 AS c0003),
-- Rel: attach(Rel)
-- Binding due to: refctr > 1
a0002(iter_nat, item_int) AS
(SELECT 1 AS iter_nat, c0004.item_int
FROM a0001 AS c0004),
-- Rel: difference(Rel, Rel)
-- Binding due to: kind != sql_select
a0003(iter_nat) AS
((SELECT 1 AS iter_nat)
EXCEPT ALL
(SELECT c0008.iter_nat
FROM a0002 AS c0008)),
-- Rel: disjunion(Rel, Rel)
-- Binding due to: kind != sql_select
a0004(item_int) AS
((SELECT c0006.item_int
FROM a0002 AS c0006)
UNION ALL
(SELECT 0 AS item_int
FROM a0003 AS c0009)),
-- Rel: attach(Rel)
-- Binding due to: dirty node
a0005(pos_nat, item_int) AS
(SELECT 1 AS pos_nat, c0010.item_int
FROM a0004 AS c0010),
-- ====================
-- = RESULT RELATIONS =
-- ====================
result(pos_nat, item_int) AS
(SELECT c0011.pos_nat, c0011.item_int
FROM a0005 AS c0011)
select * from result;
--- NEW FILE: variable_stack_crash.SF-1711251-2.stable.err ---
stderr of test 'variable_stack_crash.SF-1711251-2` in directory
'src/test/BugTracker` itself:
# 10:56:19 >
# 10:56:19 > 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=31258 --set xrpc_port=49123 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:56:19 >
# 10:56:19 >
# 10:56:19 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31258
# 10:56:19 >
# 10:56:19 >
# 10:56:19 > Done.
# 10:56:19 >
--- NEW FILE: variable_stack_crash.SF-1711251.stable.err ---
stderr of test 'variable_stack_crash.SF-1711251` in directory
'src/test/BugTracker` itself:
# 10:56:19 >
# 10:56:19 > 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=31258 --set xrpc_port=49123 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:56:19 >
# 10:56:19 >
# 10:56:19 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31258
# 10:56:19 >
# 10:56:19 >
# 10:56:19 > Done.
# 10:56:19 >
-------------------------------------------------------------------------
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
