metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (METAMODEL-239) DB2 query rewriting fails when first row = 1 and maxRows = null
Date Wed, 09 Mar 2016 16:06:40 GMT
Ankit Kumar created METAMODEL-239:
-------------------------------------

             Summary: DB2 query rewriting fails when first row = 1 and maxRows = null
                 Key: METAMODEL-239
                 URL: https://issues.apache.org/jira/browse/METAMODEL-239
             Project: Apache MetaModel
          Issue Type: Bug
    Affects Versions: 4.5.1, 4.4.1
            Reporter: Ankit Kumar


In DB2 when firstRow is set as 1 but the maxRows is set to null then the queryRewriting generates
a query like this and in DB2 the query does not get executed.

SELECT table.col1, table.col2 
FROM table FETCH FIRST null ROWS ONLY



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message