Illes S created CALCITE-6790:
--------------------------------
Summary: Write LIMIT for fetch operations in Vertica
Key: CALCITE-6790
URL: https://issues.apache.org/jira/browse/CALCITE-6790
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.38.0
Reporter: Illes S
Vertica does not support `FETCH NEXT ? ROWS ONLY` syntax:
*SQL*
{code:sql}
SELECT * FROM dual LIMIT 1 {code}
*actual*
{code:sql}
SELECT *
FROM "dual"
FETCH NEXT 1 ROWS ONLY
{code}
*expected*
{code:sql}
SELECT *
FROM "dual"
FETCH NEXT 1 ROWS ONLY
{code}
The fix seems to be adding this to
[VerticaSqlDialect.java|https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/sql/dialect/VerticaSqlDialect.java]:
{code:java}
@Override
public void unparseOffsetFetch(SqlWriter writer, @Nullable SqlNode offset,
@Nullable SqlNode fetch) {
unparseFetchUsingLimit(writer, offset, fetch);
}
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
