Update of /cvsroot/monetdb/sql/src/test/xquery/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv21930/xquery/Tests
Added Files:
create.sql create.stable.err create.stable.out drop.sql
drop.stable.err drop.stable.out q01.sql q01.stable.err
q01.stable.out
Log Message:
added test for long time bug (xquery -> sql, performance problem with
range joins)
--- NEW FILE: create.stable.out ---
stdout of test 'create` in directory 'src/test/xquery` itself:
# 14:17:03 >
# 14:17:03 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36845 --set
xrpc_port=49590 --set monet_prompt= --trace "--dbname=mTests_src_test_xquery"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 14:17:03 >
# MonetDB server v5.3.0, based on kernel v1.21.0
# Serving database 'mTests_src_test_xquery'
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-2007 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:36845/
# MonetDB/SQL module v2.21.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 14:17:03 >
# 14:17:03 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=36845
# 14:17:03 >
[ 77 ]
[ 156690 ]
[ 1 ]
# 14:17:17 >
# 14:17:17 > Done.
# 14:17:17 >
--- NEW FILE: q01.stable.err ---
stderr of test 'q01` in directory 'src/test/xquery` itself:
# 14:17:17 >
# 14:17:17 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36845 --set
xrpc_port=49590 --set monet_prompt= --trace "--dbname=mTests_src_test_xquery"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 14:17:17 >
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf)
# 14:17:17 >
# 14:17:17 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=36845
# 14:17:17 >
# 14:17:31 >
# 14:17:31 > Done.
# 14:17:31 >
--- NEW FILE: q01.stable.out ---
stdout of test 'q01` in directory 'src/test/xquery` itself:
# 14:17:17 >
# 14:17:17 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36845 --set
xrpc_port=49590 --set monet_prompt= --trace "--dbname=mTests_src_test_xquery"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 14:17:17 >
# MonetDB server v5.3.0, based on kernel v1.21.0
# Serving database 'mTests_src_test_xquery'
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-2007 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:36845/
# MonetDB/SQL module v2.21.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 14:17:17 >
# 14:17:17 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=36845
# 14:17:17 >
% .result, sys.result # table_name
% pos_nat, item_pre # name
% int, int # type
% 1, 5 # length
[ 1, 53910 ]
# 14:17:31 >
# 14:17:31 > Done.
# 14:17:31 >
--- NEW FILE: create.sql ---
create table names(
nameid integer not null primary key,
name varchar(100));
create table doc(
pre integer not null primary key,
size integer not null,
level smallint not null,
kind smallint not null,
nameid integer references names(nameid),
value varchar(100));
copy 77 RECORDS into names from stdin DELIMITERS ',', '\n', '"';
0, "site"
1, "regions"
2, "africa"
3, "item"
4, "id"
5, "location"
[...156750 lines suppressed...]
156597, 85, 5, 1, 9, NULL
156683, 0, 5, 3, , " "
156685, 0, 6, 3, , "6"
156684, 1, 5, 1, 67, NULL
156686, 0, 5, 3, , " "
156592, 94, 4, 1, 65, NULL
156687, 0, 4, 3, , " "
156569, 118, 3, 1, 74, NULL
156688, 0, 3, 3, , " "
138711, 17977, 2, 1, 73, NULL
156689, 0, 2, 3, , " "
1, 156688, 1, 1, 0, NULL
0, 156689, 0, 6, 0, "../../document/D/D.xml"
update doc set value='auctionG.xml' where kind=6;
create view xmldoc(pre, size, level, kind, nameid, value, name) as
select d.pre, d.size, d.level, d.kind, d.nameid, d.value, n.name
from doc as d left outer join names as n on
(d.nameid = n.nameid);
--- NEW FILE: create.stable.err ---
stderr of test 'create` in directory 'src/test/xquery` itself:
# 14:17:03 >
# 14:17:03 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36845 --set
xrpc_port=49590 --set monet_prompt= --trace "--dbname=mTests_src_test_xquery"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 14:17:03 >
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf)
# 14:17:03 >
# 14:17:03 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=36845
# 14:17:03 >
# 14:17:17 >
# 14:17:17 > Done.
# 14:17:17 >
--- NEW FILE: drop.stable.out ---
stdout of test 'drop` in directory 'src/test/xquery` itself:
# 14:17:31 >
# 14:17:31 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36845 --set
xrpc_port=49590 --set monet_prompt= --trace "--dbname=mTests_src_test_xquery"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 14:17:31 >
# MonetDB server v5.3.0, based on kernel v1.21.0
# Serving database 'mTests_src_test_xquery'
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-2007 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:36845/
# MonetDB/SQL module v2.21.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 14:17:31 >
# 14:17:31 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=36845
# 14:17:31 >
# 14:17:31 >
# 14:17:31 > Done.
# 14:17:31 >
--- NEW FILE: drop.sql ---
drop view xmldoc;
drop table doc;
drop table names;
--- NEW FILE: q01.sql ---
-- set optimizer='off';
-- !! START SCHEMA INFORMATION ** DO NOT EDIT THESE LINES !!
-- document-relation: document
-- document-pre: pre
-- document-size: size
-- document-level: level
-- document-kind: kind
-- document-value: value
-- document-name: name
-- document-tag: tag
-- result-relation: result
-- result-pos_nat: pos_nat
-- result-item_pre: item_pre
-- !! END SCHEMA INFORMATION ** DO NOT EDIT THESE LINES !!
WITH
-- Rel: ScjRel
-- Binding due to: dirty node
a0000(item1_pre, iter_nat) AS
(SELECT DISTINCT c0004.pre, 1 AS iter_nat
FROM xmldoc AS c0004,
xmldoc AS c0003,
xmldoc AS c0002,
xmldoc AS c0001
WHERE ((c0004.level = (c0003.level + 1)) AND (((c0003.pre + c0003.size) >=
c0004.pre) AND ((c0004.pre > c0003.pre) AND ((c0004.kind = 1) AND
((c0004.name = 'person') AND ((c0003.level = (c0002.level + 1)) AND
(((c0002.pre + c0002.size) >= c0003.pre) AND ((c0003.pre > c0002.pre)
AND ((c0003.kind = 1) AND ((c0003.name = 'people') AND ((c0002.level =
(c0001.level + 1)) AND (((c0001.pre + c0001.size) >= c0002.pre) AND
((c0002.pre > c0001.pre) AND ((c0002.kind = 1) AND ((c0002.name =
'site') AND ((c0001.value = 'auctionG.xml') AND (c0001.kind =
6)))))))))))))))))),
-- Rel: rownum(Rel)
-- Binding due to: dirty node
a0001(pos_nat, item1_pre) AS
(SELECT 1 + ROW_NUMBER () OVER (ORDER BY c0005.item1_pre ASC) AS pos_nat,
c0005.item1_pre
FROM a0000 AS c0005),
-- Rel: number(Rel)
-- Binding due to: refctr > 1 and dirty node
a0002(iter_nat, pos_nat, item1_pre) AS
(SELECT 1 + ROW_NUMBER () OVER () AS iter_nat, c0006.pos_nat, c0006.item1_pre
FROM a0001 AS c0006),
-- Rel: project(Rel)
-- Binding due to: dirty node
a0003(iter1_nat) AS
(SELECT DISTINCT c0008.iter_nat AS iter1_nat
FROM xmldoc AS c0011,
xmldoc AS c0009,
xmldoc AS c0010,
a0002 AS c0008
WHERE ((c0011.value = 'person0') AND ((c0011.kind = 2) AND ((c0009.pre =
c0011.pre) AND ((c0009.level = (c0010.level + 1)) AND (((c0010.pre +
c0010.size) >= c0009.pre) AND ((c0009.pre > c0010.pre) AND
((c0009.kind = 2) AND ((c0009.name = 'id') AND (c0010.pre =
c0008.item1_pre)))))))))),
-- Rel: rownum(Rel)
-- Binding due to: dirty node
a0004(pos1_nat, pos_nat, item1_pre) AS
(SELECT 1 + ROW_NUMBER () OVER (ORDER BY c0008.pos_nat ASC) AS pos1_nat,
c0008.pos_nat, c0008.item1_pre
FROM a0003 AS c0012,
a0002 AS c0008
WHERE (c0008.iter_nat = c0012.iter1_nat)),
-- Rel: number(Rel)
-- Binding due to: refctr > 1 and dirty node
a0005(iter_nat, pos1_nat, item1_pre) AS
(SELECT 1 + ROW_NUMBER () OVER () AS iter_nat, c0013.pos1_nat,
c0013.item1_pre
FROM a0004 AS c0013),
-- Rel: ScjRel
-- Binding due to: dirty node
a0006(item_pre, iter1_nat) AS
(SELECT DISTINCT c0019.pre, c0016.iter_nat AS iter1_nat
FROM xmldoc AS c0019,
xmldoc AS c0017,
xmldoc AS c0018,
a0005 AS c0016
WHERE ((c0019.level = (c0017.level + 1)) AND (((c0017.pre + c0017.size) >=
c0019.pre) AND ((c0019.pre > c0017.pre) AND ((c0019.kind = 3) AND
((c0017.level = (c0018.level + 1)) AND (((c0018.pre + c0018.size) >=
c0017.pre) AND ((c0017.pre > c0018.pre) AND ((c0017.kind = 1) AND
((c0017.name = 'name') AND (c0018.pre = c0016.item1_pre))))))))))),
-- Rel: rownum(Rel)
-- Binding due to: dirty node
a0007(sort_nat, item_pre, iter_nat, pos1_nat) AS
(SELECT 1 + ROW_NUMBER () OVER
(PARTITION BY c0015.iter_nat ORDER BY c0020.item_pre ASC) AS sort_nat,
c0020.item_pre, c0015.iter_nat, c0015.pos1_nat
FROM a0006 AS c0020,
a0005 AS c0015
WHERE (c0015.iter_nat = c0020.iter1_nat)),
-- Rel: rownum(Rel)
-- Binding due to: dirty node
a0008(pos_nat, sort_nat, item_pre, pos1_nat) AS
(SELECT 1 + ROW_NUMBER () OVER (ORDER BY c0021.pos1_nat ASC, c0021.sort_nat
ASC)
AS pos_nat, c0021.sort_nat, c0021.item_pre, c0021.pos1_nat
FROM a0007 AS c0021),
-- Rel: project(Rel)
-- Binding due to: dirty node
a0009(pos_nat, item_pre) AS
(SELECT c0022.pos_nat, c0022.item_pre
FROM a0008 AS c0022),
-- ====================
-- = RESULT RELATIONS =
-- ====================
result(pos_nat, item_pre) AS
(SELECT c0023.pos_nat, c0023.item_pre
FROM a0009 AS c0023),
document(pre, size, level, kind, value, tag, name) AS
(SELECT pre, size, level, kind, value, name, name
FROM xmldoc AS c0024)
select * from result;
--- NEW FILE: drop.stable.err ---
stderr of test 'drop` in directory 'src/test/xquery` itself:
# 14:17:31 >
# 14:17:31 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36845 --set
xrpc_port=49590 --set monet_prompt= --trace "--dbname=mTests_src_test_xquery"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 14:17:31 >
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf)
# 14:17:31 >
# 14:17:31 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=36845
# 14:17:31 >
# 14:17:31 >
# 14:17:31 > Done.
# 14:17:31 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
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
