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