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

Voters

Watch issue

Watchers

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Cannot Reproduce
Affects Version/s: None
Fix Version/s: 1.34.0
Component/s: None
Labels:
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

Issue Links

Add Link

links to

PR 3062

Delete this link

Activity

Comment

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

Cancel

People

Assignee:: Unassigned

Reporter:: Julian Hyde

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 10/Feb/23 11:22

Updated:: 6 days ago 16:53

Resolved:: 10/Feb/23 11:34

Agile

View on Board

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