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

LIMIT a OFFSET b

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • 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;

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: