[ 
https://issues.apache.org/jira/browse/METAMODEL-239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15187454#comment-15187454
 ] 

ASF GitHub Bot commented on METAMODEL-239:
------------------------------------------

GitHub user ankit2711 opened a pull request:

    https://github.com/apache/metamodel/pull/90

    Fix METAMODEL-239 | DB2 query rewriting fails when first row = 1 and 
maxRows = null

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/ankit2711/metamodel master

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/metamodel/pull/90.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #90
    
----
commit f40b60d688dd20749b4126a56978c75e44422e0e
Author: ankit2711 <[email protected]>
Date:   2015-10-19T15:24:43Z

    Set the module versions to be 4.4.1-INTERNAL-SNAPSHOT

commit 10d0ab8ab07dc6a66c1bc6c0ef8c86a5d5461236
Author: ankit2711 <[email protected]>
Date:   2015-10-19T15:26:49Z

    [maven-release-plugin] prepare release MetaModel-4.4.1-INTERNAL

commit e7455de7a4a9f9b88dac154940d409bf1c989fe3
Author: ankit2711 <[email protected]>
Date:   2015-10-19T15:26:53Z

    [maven-release-plugin] prepare for next development iteration

commit 894517fbff8357df34f457f9f4d1742cd41744bd
Author: hdrexler <[email protected]>
Date:   2015-10-22T15:13:21Z

    Fix query with parenthesis parsing

commit 8f41c68322aa35038ea45a2718758d62d5534951
Author: hdrexler <[email protected]>
Date:   2015-10-22T15:13:21Z

    Fix query with parenthesis parsing

commit e3b0902e29eb2355ce51dbd74ffbd3028e7770e8
Author: ankit2711 <[email protected]>
Date:   2016-03-09T17:20:15Z

    Fixed METAMODEL-239 DB2 query rewriting fails when first row = 1 and 
maxRows = null

commit f2d9d787f759b6565759c74d3bc1875df02641cb
Author: ankit2711 <[email protected]>
Date:   2016-03-09T17:22:01Z

    Merge remote-tracking branch 'origin/master'
    
    Conflicts:
        cassandra/pom.xml
        core/pom.xml
        core/src/main/java/org/apache/metamodel/query/Query.java
        
core/src/test/java/org/apache/metamodel/query/parser/QueryParserTest.java
        couchdb/pom.xml
        csv/pom.xml
        elasticsearch/pom.xml
        excel/pom.xml
        fixedwidth/pom.xml
        full/pom.xml
        hadoop/pom.xml
        hbase/pom.xml
        jdbc/pom.xml
        json/pom.xml
        mongodb/pom.xml
        openoffice/pom.xml
        pojo/pom.xml
        pom.xml
        salesforce/pom.xml
        spring/pom.xml
        sugarcrm/pom.xml
        xml/pom.xml

----


> 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
>
> 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)

Reply via email to