Relational XQuery

Hi there,

Your nifty product caught my attention, I like it very much, however, I found some peculiarities in dbXQury editor, as follows.
I use an Oracle database to execute XQuery against. If I run something like:

let $articles := collection('WM20OracleDev:NWCS.NWCS_ARTICLE')/NWCS_ARTICLE

return $articles[ARTICLE_ID <= 1002]

I am getting good result (records with ARTICLE_IDs 1000, 1001, 1002.
However, if I run:

let $articles := collection('WM20OracleDev:NWCS.NWCS_ARTICLE')/NWCS_ARTICLE
let $article-ids := (1000, 1001, 1002)

for $id in $article-ids
return $articles[ARTICLE_ID = $id]

I am only getting the first record with ARTICLE_ID 1000!?

If I run:

let $article-ids := (1000, 1001, 1002)

for $id in $article-ids
return $id

I get 1000, 1001, 1002

Could you please explain this inconsistency? Thank you.

Regards,

John Mikich
Software Developer