[CALCITE-5524] JDBC adapter generates LIMIT, OFFSET in wrong order for Presto dialect

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Fix Version/s: 1.34.0
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 10/Feb/23 08:22
• Updated: 14/Mar/23 13:53
• Resolved: 10/Feb/23 08:34

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.

Issue Links

• links to: PR 3062