[
https://issues.apache.org/jira/browse/CALCITE-7267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18035499#comment-18035499
]
Zhen Chen commented on CALCITE-7267:
------------------------------------
I'd also like to understand this in more detail. Currently, I haven't seen this
type of mapping table in the Calcite dialect conversions - I've only noticed
that some dialects are implemented based on classes of certain dialects. After
checking, I found that the CHAR_LENGTH function is actually supported in some
databases like Doris and DuckDB. The percentage of dialects that don't support
it might be quite small. Would it be possible to update the Jira title and
maintain this fix?
> CHAR_LENGTH function is not recognized in Oracle dialect
> --------------------------------------------------------
>
> Key: CALCITE-7267
> URL: https://issues.apache.org/jira/browse/CALCITE-7267
> 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
>
>
> CHAR_LENGTH function is not support for Oracle, but LENGTH is supported
> sql
>
> {code:java}
> select CHAR_LENGTH('aaa') {code}
>
>
> error
>
> {code:java}
> ORA-00904: "CHAR_LENGTH": invalid identifier
> https://docs.oracle.com/error-help/db/ora-00904/
> 00904. 00000 - "%s: invalid identifier"
> *Cause: The identifier or column name entered was invalid.
> *Action: Ensure the following
> Error at Line: 1 Column: 6 {code}
>
>
> sql
>
> {code:java}
> select LENGTH('aaa') {code}
>
>
> result is ok:
>
> {code:java}
> 3
> {code}
> refer:
> https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/LENGTH.html
>
> This function is widely used and needs to be fixed.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
