Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Minor
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 11.0
    • Component/s: Query Engine
    • Labels:
      None
    • Steps to Reproduce:
      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                lukyer Lukas Lukyer
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: