Bugs item #2141012, was opened at 2008-10-01 22:13
Message generated for change (Comment added) made by lafanasi
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: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Loredana Afanasiev (lafanasi)
Assigned to: Nobody/Anonymous (nobody)
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..
[EMAIL PROTECTED] xq]$ diff tmp1.xq tmp2.xq
1c1
< let $col := fn:collection("MotiesTweedeKamer")
---
> let $col := fn:collection("MotiesTweedeKamer_Updatable")
[EMAIL PROTECTED] xq]$ mclient -lx -g tmp1.xq
<result count="1" year=""/>,
...
[EMAIL PROTECTED] xq]$ mclient -lx -g tmp2.xq
MAPI = [EMAIL PROTECTED]: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: 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
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
