I am using metamodel with DB2 database. I have one query where I want to fetch records out of database with firstRow and MaxRow clauses. What I found is this query doesn't work as expected and returns duplicate records in different pages/batches.
I looked into the DB2QueryRewriter.java class and found that we are using ROW_NUMBER() OVER() function in inner query to define order but this is not working correctly, If I change this function call to include order by clause on table Id field (ROW_NUMBER() OVER(order by id)every thing works perfectly fine. Please provide your valuable inputs on how to fix this for DB2 database. We are using 3.4.7 version of metatmodel. Regards, Gagan
