Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5379

LIMIT a OFFSET b

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 11.0
    • None
    • Query Engine
    • None
    • Hide

      Issue SQL command against VDB JDBC connection:
      select * from mytable limit 5 offset 3;

      Show
      Issue SQL command against VDB JDBC connection: select * from mytable limit 5 offset 3;

      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

              rhn-engineering-shawkins Steven Hawkins
              lukyer Lukas Lukyer (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: