[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