Hi Alessandro,

I got the database that you sent. I can reproduce the problem but
currently have no idea whats going wrong. Perhaps you should also
send a copy of the database script to Jason, he may be able to spot
the problem quicker than I can.

As you pointed out, there seems to be some inconsistencies in the
parameter data types. You have a query like...

SELECT FIRST 1 SKIP ?SKP * FROM WORKS
WHERE PROJECT_CATEGORY = ?CATEGORY /* should be smallint */

and the parameter list looks like...
SKP = smallint
CATEGORY = int64

this seems to be reversed to what it should be (since the skip
parameter was int64 in all my earlier tests). I looked to see if
the parameter names were reversed inside IBO but it is not as
simple as that.

If I can find some spare time tomorrow I will take a closer look,
otherwise hopefully Jason may have an idea.

--
Geoff Worboys
Telesis Computing