Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv14617
Modified Files:
Tag: May2009
All
Added Files:
Tag: May2009
recursion-problem.SF-2827784.sql
recursion-problem.SF-2827784.stable.err
recursion-problem.SF-2827784.stable.out
Log Message:
Test for SF bug 2827784.
--- NEW FILE: recursion-problem.SF-2827784.stable.out ---
stdout of test 'recursion-problem.SF-2827784` in directory
'src/test/BugTracker-2009` itself:
# 14:37:21 >
# 14:37:21 > mserver5 "--config=/home/sjoerd/Monet-Stable/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/home/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5/.libs:/home/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5:/home/sjoerd/Monet-Stable/lib64/MonetDB5:/home/sjoerd/Monet-Stable/lib64/MonetDB5/lib:/home/sjoerd/Monet-Stable/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/home/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=35594 --set
xrpc_port=48399 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 14:37:21 >
# MonetDB server v5.12.4, based on kernel v1.30.4
# Serving database 'mTests_src_test_BugTracker-2009', using 2 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on
mapi:monetdb://koolmees.mullender.nl:35594/
# MonetDB/SQL module v2.30.4 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 14:37:21 >
# 14:37:21 > mclient -lsql -umonetdb -Pmonetdb --host=koolmees --port=35594
# 14:37:21 >
% .cabact, .cabact, .cabact, .cabact, .cabact,
.cabact, .cabact, .cabact, .cabact, .cabact,
.cabact, .cabact, .cabact, .cabact, .cabact,
.cabact, .cabact, .cabact, .cabact, .cabact,
.cabact, .cabact, .cabact, .cabact, .cabact,
.cabact, .cabact, .cabact, .cabact, .cabact,
.cabact, .cabact, .cabact, .cabact, .cabact,
.cabact, .cabact, .cabact, .cabact, .cabact #
table_name
% cabactcsu, cabact___rforefide, cabact___rteprcide,
cabact___rtestdide, cabact___rfovsnide, cabactlil, cabactlic,
cabacttxt, cabact___rfontride, cabact_f1rfodstide,
cabact_f2rfodstide, cabact_f3rfodstide, cabact_f4rfodstide,
cabact_f5rfodstide, cabact_f6rfodstide, cabact_f7rfodstide,
cabact_f8rfodstide, cabact_f9rfodstide, cabact_c1rfodstide,
cabact_c2rfodstide, cabact_c3rfodstide, cabact_c4rfodstide,
cabact_c5rfodstide, cabact_c6rfodstide, cabact_c7rfodstide,
cabact_c8rfodstide, cabact_c9rfodstide, cabactqte,
cabact___rfountide, cabactdtd, cabactdtf, cabactax1,
cabactax2, cabactax3, cabactax4, cabactax5, cabactax6,
cabactax7, cabactax8, cabactax9 # name
% int, varchar, varchar, varchar, varchar,
varchar, varchar, varchar, varchar, varchar,
varchar, varchar, varchar, varchar, varchar,
varchar, varchar, varchar, varchar, varchar,
varchar, varchar, varchar, varchar, varchar,
varchar, varchar, double, varchar, timestamptz,
timestamptz, int, int, int, int, int, int, int, int,
int # type
% 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 22, 0, 26,
26, 1, 1, 1, 1, 1, 1, 1, 1, 1 #
length
# 14:37:36 >
# 14:37:36 > Done.
# 14:37:36 >
--- NEW FILE: recursion-problem.SF-2827784.sql ---
CREATE TABLE cabact
(
cabactcsu integer NOT NULL,
cabact___rforefide character varying(32) NOT NULL,
cabact___rteprcide character varying(32) NOT NULL,
cabact___rtestdide character varying(32) NOT NULL,
cabact___rfovsnide character varying(32) NOT NULL,
cabactlil character varying(100) NOT NULL,
cabactlic character varying(32) NOT NULL,
cabacttxt character varying(1500),
cabact___rfontride character varying(32),
cabact_f1rfodstide character varying(32),
cabact_f2rfodstide character varying(32),
cabact_f3rfodstide character varying(32),
cabact_f4rfodstide character varying(32),
cabact_f5rfodstide character varying(32),
cabact_f6rfodstide character varying(32),
cabact_f7rfodstide character varying(32),
cabact_f8rfodstide character varying(32),
cabact_f9rfodstide character varying(32),
cabact_c1rfodstide character varying(32),
cabact_c2rfodstide character varying(32),
cabact_c3rfodstide character varying(32),
cabact_c4rfodstide character varying(32),
cabact_c5rfodstide character varying(32),
cabact_c6rfodstide character varying(32),
cabact_c7rfodstide character varying(32),
cabact_c8rfodstide character varying(32),
cabact_c9rfodstide character varying(32),
cabactqte double,
cabact___rfountide character varying(32),
cabactdtd timestamp with time zone NOT NULL,
cabactdtf timestamp with time zone NOT NULL,
cabactax1 integer NOT NULL DEFAULT 1,
cabactax2 integer NOT NULL DEFAULT 2,
cabactax3 integer NOT NULL DEFAULT 3,
cabactax4 integer NOT NULL DEFAULT 4,
cabactax5 integer NOT NULL DEFAULT 5,
cabactax6 integer NOT NULL DEFAULT 6,
cabactax7 integer NOT NULL DEFAULT 7,
cabactax8 integer NOT NULL DEFAULT 8,
cabactax9 integer NOT NULL DEFAULT 9
);
CREATE TABLE rfoade
(
rfoade___rforefide character varying(50) NOT NULL,
rfoade___rfovdeide character varying(50) NOT NULL,
rfoade_i_rfodstide character varying(50) NOT NULL,
rfoadeaxe integer DEFAULT 0 NOT NULL,
rfoadervs integer NOT NULL,
rfoadenpm integer DEFAULT 1,
rfoade_s_rfodstide character varying(32) NOT NULL,
rfoadegch character varying(120) DEFAULT 'AAAAA' NOT NULL,
rfoadedrt character varying(120) DEFAULT 'ZZZZZ' NOT NULL,
rfoadeniv integer DEFAULT 0 NOT NULL,
rfoadetxt character varying(1800),
rfoadenum integer DEFAULT 99999 NOT NULL,
rfoadeden integer DEFAULT 999 NOT NULL,
rfoadechm character varying(5500) DEFAULT 'INVALID' NOT NULL,
rfoadeord integer DEFAULT 999999 NOT NULL
);
select * from cabact where cabact___rforefide = 'FHSJ' and
cabact___rteprcide = 'CPTANA' and
cabact___rtestdide = '100' and
cabact___rfovsnide = '200805_001' and
(cabact_f1rfodstide IS NULL or cabact_f1rfodstide IN (select
rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA' and
rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_f2rfodstide IS NULL or cabact_f2rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_f3rfodstide IS NULL or cabact_f3rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_f4rfodstide IS NULL or cabact_f4rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_f5rfodstide IS NULL or cabact_f5rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_f6rfodstide IS NULL or cabact_f6rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_f7rfodstide IS NULL or cabact_f7rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_f8rfodstide IS NULL or cabact_f8rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_f9rfodstide IS NULL or cabact_f9rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_c1rfodstide IS NULL or cabact_c1rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_c2rfodstide IS NULL or cabact_c2rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_c3rfodstide IS NULL or cabact_c3rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_c4rfodstide IS NULL or cabact_c4rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_c5rfodstide IS NULL or cabact_c5rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_c6rfodstide IS NULL or cabact_c6rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_c7rfodstide IS NULL or cabact_c7rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1')) and
(cabact_c8rfodstide IS NULL or cabact_c8rfodstide IN
(select rfoade_i_rfodstide from rfoade where rfoade___rfovdeide='SECA'
and rfoade___rforefide = 'FHSJ' and rfoadervs='1'));
drop table cabact;
drop table rfoade;
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/All,v
retrieving revision 1.27.2.9
retrieving revision 1.27.2.10
diff -u -d -r1.27.2.9 -r1.27.2.10
--- All 19 Jul 2009 19:13:28 -0000 1.27.2.9
+++ All 27 Jul 2009 15:37:39 -0000 1.27.2.10
@@ -66,3 +66,4 @@
mclient-lsql-D
view-except-limit.SF-2798333
utf8_bug.SF-2822855
+recursion-problem.SF-2827784
--- NEW FILE: recursion-problem.SF-2827784.stable.err ---
stderr of test 'recursion-problem.SF-2827784` in directory
'src/test/BugTracker-2009` itself:
# 14:37:21 >
# 14:37:21 > mserver5 "--config=/home/sjoerd/Monet-Stable/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/home/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5/.libs:/home/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5:/home/sjoerd/Monet-Stable/lib64/MonetDB5:/home/sjoerd/Monet-Stable/lib64/MonetDB5/lib:/home/sjoerd/Monet-Stable/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/home/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=35594 --set
xrpc_port=48399 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 14:37:21 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.30.2
# builtin opt prefix = /home/sjoerd/Monet-Stable
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path = ${prefix}/lib64/MonetDB
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = sql_logs
# builtin opt xquery_logdir = xquery_logs
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /home/sjoerd/Monet-Stable
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /home/sjoerd/Monet-Stable
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${prefix}/lib64/MonetDB5:${prefix}/lib64/MonetDB5/lib:${prefix}/lib64/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/MonetDB/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/MonetDB/merovingian.log
# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
# config opt mero_exittimeout = 7
# config opt mero_doproxy = yes
# config opt mero_discoveryttl = 600
# config opt mal_init = ${prefix}/lib64/MonetDB5/mal_init.mal
# config opt mal_listing = 2
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt sql_logdir = sql_logs
# cmdline opt config = /home/sjoerd/Monet-Stable/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/home/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5/.libs:/home/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5:/home/sjoerd/Monet-Stable/lib64/MonetDB5:/home/sjoerd/Monet-Stable/lib64/MonetDB5/lib:/home/sjoerd/Monet-Stable/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/home/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/dbfarm
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 35594
# cmdline opt xrpc_port = 48399
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see /home/sjoerd/Monet-Stable/etc/monetdb5.conf)
# 14:37:21 >
# 14:37:21 > mclient -lsql -umonetdb -Pmonetdb --host=koolmees --port=35594
# 14:37:21 >
# 14:37:36 >
# 14:37:36 > Done.
# 14:37:36 >
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
