Julian Hyde created CALCITE-5524:
------------------------------------
Summary: JDBC adapter generates LIMIT, OFFSET in wrong order for
Presto dialect
Key: CALCITE-5524
URL: https://issues.apache.org/jira/browse/CALCITE-5524
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
JDBC adapter generates LIMIT, OFFSET in wrong order for Presto dialect.
The presto paging statement should be:
{code}
SELECT * FROM db1.tb1 offset 100 limit 20;
{code}
The original version defaults to spelling limit first and then offset, which
does not conform to presto syntax.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
