[
https://issues.apache.org/jira/browse/CALCITE-4776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415450#comment-17415450
]
duan xiong commented on CALCITE-4776:
-------------------------------------
[~zhujiwen] Hi, This function is a debugging function intended for internal use
in Mysql [WEIGHT_STRING IN
MYSQL|https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_weight-string]
And this is not a standard function according to SQL(ISO/IEC 9075) 2016. So
maybe you can implement this in others ways ?
> SqlParseException:WEIGHT_STRING('ab' AS CHAR(4))
> --------------------------------------------------
>
> Key: CALCITE-4776
> URL: https://issues.apache.org/jira/browse/CALCITE-4776
> Project: Calcite
> Issue Type: Bug
> Components: server
> Affects Versions: 1.27.0
> Reporter: zhujiwen
> Priority: Blocker
>
> String sql = "SELECT WEIGHT_STRING('ab' AS CHAR(4))";
> SqlParser sqlParser = SqlParser.create(sql, config);
>
> org.apache.calcite.sql.parser.SqlParseException: Encountered "AS" at line *,
> column *.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
