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

Lukáš Svačina (JIRA) issues at jboss.org
Fri Jun 15 11:25:00 EDT 2018


Lukáš Svačina created TEIID-5379:
------------------------------------

             Summary: 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


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