[
https://issues.apache.org/jira/browse/CALCITE-7322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18045363#comment-18045363
]
Caican Cai commented on CALCITE-7322:
-------------------------------------
fix in
https://github.com/apache/calcite/commit/20fae9a1b12cb993b06a1722826a4a64f7965373
> The POSITION function in MySQL is missing the FROM clause
> ---------------------------------------------------------
>
> Key: CALCITE-7322
> URL: https://issues.apache.org/jira/browse/CALCITE-7322
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.41.0
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.42.0
>
>
> POSITION function would convert to 'instr' in MySQL dialect，but instr
> function would lost the the third paramter 'from clause'
> origin sql:
> {code:java}
> select POSITION('a' in 'bbacdac' from 4) {code}
>
> in MysqlDialect would convert to:
> {code:java}
> select INSTR('bbacdac', 'a')
> {code}
> which lost the 'from clause': '4'.
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
