You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Caican Cai (Jira)" <ji...@apache.org> on 2025/03/15 10:43:00 UTC

[jira] [Commented] (CALCITE-6892) CHAR_LENGTH Function is not recognized in DerbySQL

    [ https://issues.apache.org/jira/browse/CALCITE-6892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17935736#comment-17935736 ] 

Caican Cai commented on CALCITE-6892:
-------------------------------------

[~xuzifu666] Thanks. Are the definitions of Calcite's char_length and Derby's length the same? If not, do you need to explain? The following is the definition of the length function of derby

{code:java}
LENGTH ( characterExpression | bitExpression )
{code}



>  CHAR_LENGTH Function is not recognized in DerbySQL
> ---------------------------------------------------
>
>                 Key: CALCITE-6892
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6892
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.38.0
>            Reporter: Yu Xu
>            Assignee: Yu Xu
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.40.0
>
>
> Derby is not support CHAR_LENGTH function and it is use LENGTH support it.
> Add LENGTH function in DerbySqlDialect
> we can refer to：[https://db.apache.org/derby/docs/10.17/ref/index.html]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)