Gagan Deep Juneja created METAMODEL-35:
------------------------------------------
Summary: DB2 query with limit returns random order results
Key: METAMODEL-35
URL: https://issues.apache.org/jira/browse/METAMODEL-35
Project: Metamodel
Issue Type: Bug
Reporter: Gagan Deep Juneja
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.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
