[
https://issues.apache.org/jira/browse/CALCITE-5241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17582502#comment-17582502
]
Jiajun Xie commented on CALCITE-5241:
-------------------------------------
I execute `select char(256+65)` in MySQL5.6 and I get the result is `A`. So I
also use `n % 256` in CALCITE.
Here is PR: https://github.com/apache/calcite/pull/2878
> Implement CHAR function
> -----------------------
>
> Key: CALCITE-5241
> URL: https://issues.apache.org/jira/browse/CALCITE-5241
> Project: Calcite
> Issue Type: Wish
> Components: core
> Reporter: pengfei.zhan
> Assignee: Jiajun Xie
> Priority: Major
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Implement the {{CHAR\(n)}} function and the \{fn CHAR(string)\} JDBC function.
> Spark and hive support `char\(n\)`, however, calcite doesn't support it. Is
> there any message I missed?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
