[ 
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)

Reply via email to