11762 2011-01-14 17:46:02 +0000 [XQuery30UC] additional parens needed in "Windowing" Q18 and Q19 2011-03-30 19:17:45 +0000 1 1 1 Unclassified XPath / XQuery / XSLT XQuery 3.0 Use Cases Working drafts PC Windows XP CLOSED FIXED P2 normal --- 1 andrew.eisenberg jonathan.robie matthias.brantner public-qt-comments oldest_to_newest 44353 0 andrew.eisenberg 2011-01-14 17:46:02 +0000 The query in Q18 is declare variable $seq := fn:doc("cxml.xml"); <result>{ for sliding window $w in $seq/sequence/* start $s when $s[self::OrderRequest] end $e when $e/@orderID eq $s/@orderID and $e[self::ConfirmationRequest] and $e/@status eq "reject" or $e[self::ShipNotice] where $e[self::ShipNotice] return <timeToShip orderID="{ $s/@orderID}">{xs:dateTime($e/@date) - xs:dateTime($s/@date) }</timeToShip> }</result> The end condition requires additional parens: declare variable $seq := fn:doc("cxml.xml"); <result>{ for sliding window $w in $seq/sequence/* start $s when $s[self::OrderRequest] end $e when $e/@orderID eq $s/@orderID and ( $e[self::ConfirmationRequest] and $e/@status eq "reject" or $e[self::ShipNotice]) where $e[self::ShipNotice] return <timeToShip orderID="{ $s/@orderID}">{xs:dateTime($e/@date) - xs:dateTime($s/@date) }</timeToShip> }</result> The same issue occurs in Q19. It current reads: declare variable $seq := fn:doc("cxml.xml"); <result>{ for sliding window $w in $seq/sequence/* start previous $wSPrev when $wSPrev[self::OrderRequest] end next $wENext when $wENext/@orderID eq $wSPrev/@orderID and ( $wENext[self::ConfirmationRequest] and $wENext/@status eq "reject") or $wENext[self::ShipNotice] where $wENext[self::ShipNotice] return <bundleWith orderId="{$wSPrev/@orderID}">{ for sliding window $bundle in $w start $bSCur when $bSCur[self::OrderRequest] and $bSCur/@shipTo eq $wSPrev/@shipTo end $bECur next $bENext when $bECur/@orderID eq $bSCur/@orderID and ($bECur[self::ConfirmationRequest] and $bECur/@status eq "reject") or $bECur[self::ShipNotice] where empty($bENext) return $bSCur }</bundleWith> }</result> In both end conditions, additional parens are needed: declare variable $seq := fn:doc("cxml.xml"); <result>{ for sliding window $w in $seq/sequence/* start previous $wSPrev when $wSPrev[self::OrderRequest] end next $wENext when $wENext/@orderID eq $wSPrev/@orderID and ( ( $wENext[self::ConfirmationRequest] and $wENext/@status eq "reject") or $wENext[self::ShipNotice] ) where $wENext[self::ShipNotice] return <bundleWith orderId="{$wSPrev/@orderID}">{ for sliding window $bundle in $w start $bSCur when $bSCur[self::OrderRequest] and $bSCur/@shipTo eq $wSPrev/@shipTo end $bECur next $bENext when $bECur/@orderID eq $bSCur/@orderID and ( ($bECur[self::ConfirmationRequest] and $bECur/@status eq "reject") or $bECur[self::ShipNotice] ) where empty($bENext) return $bSCur }</bundleWith> }</result> 44948 1 matthias.brantner 2011-02-01 14:31:16 +0000 *** Bug 11913 has been marked as a duplicate of this bug. *** 44952 2 matthias.brantner 2011-02-01 14:39:33 +0000 *** Bug 11929 has been marked as a duplicate of this bug. ***