[teiid-issues] [JBoss JIRA] (TEIID-5379) LIMIT a OFFSET b

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13592279#comment-13592279 ] 

Steven Hawkins commented on TEIID-5379:
---------------------------------------

Teiid supports both: 
LIMIT a, b 
OFFSET a ROWS FETCH NEXT b ROWS ONLY

The latter form is the ANSI sql standard.

It should be possible though to add support for an explicit offset:

LIMIT b OFFSET a

> LIMIT a OFFSET b
> ----------------
>
>                 Key: TEIID-5379
>                 URL: https://issues.jboss.org/browse/TEIID-5379
>             Project: Teiid
>          Issue Type: Bug
>            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)