[
https://issues.apache.org/jira/browse/CALCITE-7309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yu Xu updated CALCITE-7309:
---------------------------
Description:
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}
result is ok:
{code:java}
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]
was:
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
> 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
> Priority: Minor
> 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}
> result is ok:
> {code:java}
> 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)
