[teiid-issues] [JBoss JIRA] (TEIID-4888) Support for SetQueryLimit
German Tejero created TEIID-4888:
------------------------------------
Summary: Support for SetQueryLimit
Key: TEIID-4888
URL: https://issues.jboss.org/browse/TEIID-4888
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Reporter: German Tejero
Assignee: Steven Hawkins
Priority: Minor
OpenEdge RDBMS not support fetch/offset in a set query. For example, the generated SQL:
SELECT
g_1.ejer AS c_0
FROM PUB.modpre AS g_1
UNION ALL
SELECT
g_0.ejer AS c_0
FROM PUB.modesp AS g_0
FETCH NEXT 100 ROWS ONLY
For the view:
CREATE VIEW Modificaciones(
ejercicio INTEGER
)AS SELECT T.ejercicio
FROM(
SELECT M.ejercicio,
FROM sipbas.modesp AS M
UNION ALL
SELECT M.ejercicio
FROM sipbas.modpre AS M) AS T;
It is necessary to be able to indicate SetQueryLimit in the same way as with
SetQueryOrderBy.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)