You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@metamodel.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/03/09 18:27:40 UTC
[jira] [Commented] (METAMODEL-239) DB2 query rewriting fails when
first row = 1 and maxRows = null
[ 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 <ak...@gmail.com>
Date: 2015-10-19T15:24:43Z
Set the module versions to be 4.4.1-INTERNAL-SNAPSHOT
commit 10d0ab8ab07dc6a66c1bc6c0ef8c86a5d5461236
Author: ankit2711 <ak...@gmail.com>
Date: 2015-10-19T15:26:49Z
[maven-release-plugin] prepare release MetaModel-4.4.1-INTERNAL
commit e7455de7a4a9f9b88dac154940d409bf1c989fe3
Author: ankit2711 <ak...@gmail.com>
Date: 2015-10-19T15:26:53Z
[maven-release-plugin] prepare for next development iteration
commit 894517fbff8357df34f457f9f4d1742cd41744bd
Author: hdrexler <gi...@klaan.nl>
Date: 2015-10-22T15:13:21Z
Fix query with parenthesis parsing
commit 8f41c68322aa35038ea45a2718758d62d5534951
Author: hdrexler <gi...@klaan.nl>
Date: 2015-10-22T15:13:21Z
Fix query with parenthesis parsing
commit e3b0902e29eb2355ce51dbd74ffbd3028e7770e8
Author: ankit2711 <ak...@gmail.com>
Date: 2016-03-09T17:20:15Z
Fixed METAMODEL-239 DB2 query rewriting fails when first row = 1 and maxRows = null
commit f2d9d787f759b6565759c74d3bc1875df02641cb
Author: ankit2711 <ak...@gmail.com>
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)