Yu Xu created CALCITE-7309:
------------------------------
Summary: Position is unparsed incorrectly for ClickHouseSqlDialect
Key: CALCITE-7309
URL: https://issues.apache.org/jira/browse/CALCITE-7309
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.41.0
Reporter: Yu Xu
Assignee: Yu Xu
Fix For: 1.42.0
The SQL：
{code:java}
SELECT POSITION('a' IN 'abca' FROM 1) {code}
Generate Hive SQL should be：
{code:java}
SELECT POSITION('abca', 'a', 1) {code}
But is:
{code:java}
SELECT POSITION('a' IN 'abca' FROM 1) {code}
execute would error out in ClickHouse:
{code:java}
Code: 62. DB::Exception: Syntax error: failed at position 30 ('FROM') (line 1,
col 30): FROM 1)-- SELECT POSITION('abca', 'a', 2). Expected one of:
DoubleColon, LIKE, GLOBAL NOT IN, end of query, AS, DIV, IS, OR, QuestionMark,
BETWEEN, NOT LIKE, MOD, AND, Comma, alias, IN, ILIKE, NOT ILIKE, NOT, token,
NOT IN, GLOBAL IN {code}
we can refer ClickHouse document about Position:
https://clickhouse.com/docs/sql-reference/functions/string-search-functions#position
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
