Jacky Woo created CALCITE-3247:
----------------------------------
Summary: wrong sql format when transforming ANSI sql to hive sql
Key: CALCITE-3247
URL: https://issues.apache.org/jira/browse/CALCITE-3247
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.19.0
Reporter: Jacky Woo
When we use HiveSqlDialect and transform "sql", we expect SUBSTRING(' abc',
2)，but get SUBSTRING(' abc', 2) which is incorrect sql format in hive.
So maybe HiveSqlDialect behavior should be changed when transform function
SUBSTRING:
# {{SELECT SUBSTRING('ABC', 2) => SELECT SUBSTRING('ABC', 2)}}
# {{SELECT SUBSTRING('ABC', 2, 3) => SELECT SUBSTRING('ABC', 2, 3) }}
# {{SELECT SUBSTRING('ABC' FROM 2) => SELECT SUBSTRING('ABC', 2) }}
# {{SELECT SUBSTRING('ABC' FROM 2 FOR 3) => SELECT SUBSTRING('ABC', 2, 3) }}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
