[
https://issues.apache.org/jira/browse/CALCITE-7267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18035500#comment-18035500
]
Julian Hyde commented on CALCITE-7267:
--------------------------------------
The summary is currently "CHAR_LENGTH function is not recognized in Oracle".
Passive voice doesn't indicate who is not recognizing the function...
presumably Oracle? Change it so it is clear what Calcite needs to do.
And as I said earlier, Calcite both parses SQL and generates SQL. Make it clear
which one you have a problem with.
> 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)
