[ https://issues.jboss.org/browse/TEIID-4207?page=com.atlassian.jira.plugin... ] Tugba Dogan edited comment on TEIID-4207 at 5/25/16 8:08 AM: ------------------------------------------------------------- I checked the connector's source code.There are 2 options to solve this issue: * We can remove the limit support by removing the following lines. {code:java} @Override public boolean supportsRowLimit() { return true; } {code} {code:java} if (!useSelectLimit() && obj.getLimit() != null) { buffer.append(Tokens.SPACE); append(obj.getLimit()); } {code} * We don't know how many rows will be in each page so we can count the retrieved rows and we can return limited rows. was (Author: tugbadogan): I checked the connector's source code.There are 2 options to solve this issue: * We can remove the limit support by removing the following lines. {code:java} @Override public boolean supportsRowLimit() { return true; } {code} {code:java} if (!useSelectLimit() && obj.getLimit() != null) { buffer.append(Tokens.SPACE); append(obj.getLimit()); } {code} * We don't know how many rows will be in each page so we can count the retrieved rows and we can return limited rows. -- This message was sent by Atlassian JIRA (v6.4.11#64026)