Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5524

JDBC adapter generates LIMIT, OFFSET in wrong order for Presto dialect

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Cannot Reproduce
    • None
    • 1.34.0
    • None
    • None

    Description

      JDBC adapter generates LIMIT, OFFSET in wrong order for Presto dialect.

      The presto paging statement should be:

      SELECT * FROM db1.tb1 offset 100 limit 20;
      

      The original version defaults to spelling limit first and then offset, which does not conform to presto syntax.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            julianhyde Julian Hyde
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment