Bugs item #2141012, was opened at 2008-10-01 22:13
Message generated for change (Settings changed) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2141012&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: PF general
Group: Pathfinder "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Loredana Afanasiev (lafanasi)
>Assigned to: Stefan Manegold (stmane)
Summary: XQ: unclear error
Initial Comment:
Hi,
I have two identical in content collections, but one is read only the other is
updatable. I have two queries, which are identical with the exception of one
line that indicates the queried collection. Query 1 retrieves results, query 2
produces the error. I don't have any good guesses why..
[lafan...@zookst4 xq]$ diff tmp1.xq tmp2.xq
1c1
< let $col := fn:collection("MotiesTweedeKamer")
---
> let $col := fn:collection("MotiesTweedeKamer_Updatable")
[lafan...@zookst4 xq]$ mclient -lx -g tmp1.xq
<result count="1" year=""/>,
...
lafan...@zookst4 xq]$ mclient -lx -g tmp2.xq
MAPI = mone...@localhost:50000
QUERY = let $col := fn:collection("MotiesTweedeKamer_Updatable")
ERROR = !ERROR: err:FORG0003: function fn:zero-or-one expects at most one value.
cheers,
l.
----------------------------------------------------------------------
Comment By: Peter Boncz (boncz)
Date: 2008-12-11 23:56
Message:
Stefan: I also asked Lefteris to look at this, but the problem here is that
the child staircase join does not handle NIL tuples that occur in updatable
documents.
It should ignore these, and filter them out.. Could you maybe help?
----------------------------------------------------------------------
Comment By: Peter Boncz (boncz)
Date: 2008-12-09 00:46
Message:
I did:
$ ls | wc
27946 27946 335352
$ ls *xml | awk 'BEGIN { print "<a>"} { printf "<b
p=\"/export/scratch0/boncz/bug/XML/%s\" f=\"%s\"/>\n", $1, $1 } END { print
"</a>" }' > /tmp/g.xml
Then I see that in algebra mode, fn:collection() returns the wrong count
for the updatable collection:
more>for $d in doc("/tmp/g.xml")//b return pf:add-doc(exactly-one($d/@p),
exactly-one($d/@f), "rdonly")
more><>
xquery>count(fn:collection("rdonly"))
more><>
27946
xquery>for $d in doc("/tmp/g.xml")//b return
pf:add-doc(exactly-one($d/@p), concat(exactly-one($d/@f),"_"), "wr", 10)
more><>
xquery>count(fn:collection("wr"))
more><>
28012
That is, the child step does not work correctly from the pf:collection()
node:
xquery>count(pf:collection("wr")/child::text())
more><>
42
xquery>count(pf:collection("wr")/child::attribute())
more><>
0
xquery>count(pf:collection("wr")/child::element())
more><>
38
xquery>count(pf:collection("wr")/child::node())
more><>
28012
(this holds for both mps and alg)
Funny thing is that 27946 + 38 + 42 = 28026, not 28012 ???
I think the child step should be fixed to properly support the collection
node...
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2008-10-07 17:36
Message:
I can reproduce the error in the development version after I loaded all
data. I didn't try the stable version (yet).
----------------------------------------------------------------------
Comment By: Loredana Afanasiev (lafanasi)
Date: 2008-10-03 18:49
Message:
Hi Stefan,
here's the data:
http://staff.science.uva.nl/~lafanasi/data.tgz
and the queries are:
::::::::::::::
tmp1.xq
::::::::::::::
let $col := fn:collection("MotiesTweedeKamer")
let $years := fn:distinct-values(
for $date in $col//hiddendatum
return fn:substring(fn:string($date),1,4))
for $y in $years
order by $y ascending
return <result year="{$y}" count="{
count($col//document[fn:substring(fn:string(.//hiddendatum),1,4) =
$y])}"/>
::::::::::::::
tmp2.xq
::::::::::::::
let $col := fn:collection("MotiesTweedeKamer_Updatable")
let $years := fn:distinct-values(
for $date in $col//hiddendatum
return fn:substring(fn:string($date),1,4))
for $y in $years
order by $y ascending
return <result year="{$y}" count="{
count($col//document[fn:substring(fn:string(.//hiddendatum),1,4) =
$y])}"/>
Thanks,
l.
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2008-10-01 22:50
Message:
Loredana,
could you please provide us with (e.g., attach) the complete queries, and
possible also with (access to) the document collections you are using?
Thanks in advance!
Stefan
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2141012&group_id=56967
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
