Yu Xu created CALCITE-6822: ------------------------------ Summary: Write LIMIT for fetch operations in Postgresql/Phoenix/Paraccel/Teradata Key: CALCITE-6822 URL: https://issues.apache.org/jira/browse/CALCITE-6822 Project: Calcite Issue Type: Improvement Components: core Affects Versions: 1.38.0 Reporter: Yu Xu Fix For: 1.39.0
Postgresql/Phoenix/Paraccel/Teradata support limit and offset syntax, but currently would call as: SELECT \"product_id\"\nFROM \"foodmart\".\"product\"\nOFFSET 10 ROWS\nFETCH NEXT 100 ROWS ONLY, which not consistent with the syntax,need to support it. -- This message was sent by Atlassian Jira (v8.20.10#820010)