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

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)