[
https://issues.apache.org/jira/browse/CALCITE-5241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17582886#comment-17582886
]
pengfei.zhan edited comment on CALCITE-5241 at 8/22/22 10:28 AM:
-----------------------------------------------------------------
For MySQL:
[https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char]
For SqlServer：
[https://docs.microsoft.com/zh-cn/sql/t-sql/functions/char-transact-sql?view=sql-server-ver16]
For
Oracle：[https://download.oracle.com/otn-pub/jcp/jdbc-4_1-mrel-spec/jdbc4.1-fr-spec.pdf]
SparkSQL: [https://spark.apache.org/docs/latest/api/sql/#char]
For Hive: Not Supported yet
For Postgre SQL： Not supported yet
Is it a good choice to add this function to the class of SqlStdOperatorTable?
was (Author: JIRAUSER294653):
For MySQL:
[https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char]
For SqlServer：
[https://docs.microsoft.com/zh-cn/sql/t-sql/functions/char-transact-sql?view=sql-server-ver16]
For
Oracle：[https://download.oracle.com/otn-pub/jcp/jdbc-4_1-mrel-spec/jdbc4.1-fr-spec.pdf]
SparkSQL: [https://spark.apache.org/docs/latest/api/sql/#char]
For Hive: Not Supported yet
For Postgre SQL： Not supported yet
> 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)
