[teiid-issues] [JBoss JIRA] (TEIID-5379) LIMIT a OFFSET b
Lukas Eder (JIRA)
issues at jboss.org
Fri Jun 15 14:23:00 EDT 2018
[ https://issues.jboss.org/browse/TEIID-5379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13592289#comment-13592289 ]
Lukas Eder commented on TEIID-5379:
-----------------------------------
Do note that some databases support both LIMIT a OFFSET b and OFFSET b LIMIT a
> LIMIT a OFFSET b
> ----------------
>
> Key: TEIID-5379
> URL: https://issues.jboss.org/browse/TEIID-5379
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Lukáš Svačina
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 11.0
>
>
> Tradition syntax for limiting result set in teiid sql dialect is not supported.
> *select * from X limit A offset B;*
> It is a problem for SQL builders like JOOQ to work properly with TEIID syntax. I need to build SQL queries by some builder, but i didn't find anything suitable for TEIID SQL syntax.
> JOOQ works quite good with DEFAULT dialect except for limit/offset syntax.
> Are there any other ways how to build syntax correct TEIID SQL queries?
> Please add this syntax support. More info here: https://groups.google.com/forum/#!topic/jooq-user/M1X6_I2JLpg
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list