[ https://issues.apache.org/jira/browse/METAMODEL-239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197793#comment-15197793 ]
ASF GitHub Bot commented on METAMODEL-239: ------------------------------------------ Github user asfgit closed the pull request at: https://github.com/apache/metamodel/pull/90 > 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.4.1, 4.5.1 > Reporter: Ankit Kumar > Assignee: Ankit Kumar > Fix For: 4.5.2 > > > 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)