[jira] [Closed] (FLINK-18240) Correct modulus function usage in documentation or allow % operator

["Benchao Li (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-18240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Benchao Li closed FLINK-18240.
------------------------------
    Resolution: Fixed

> Correct modulus function usage in documentation or allow % operator
> -------------------------------------------------------------------
>
>                 Key: FLINK-18240
>                 URL: https://issues.apache.org/jira/browse/FLINK-18240
>             Project: Flink
>          Issue Type: Bug
>          Components: Documentation, Table SQL / API
>            Reporter: Jark Wu
>            Assignee: Shengkai Fang
>            Priority: Major
>              Labels: pull-request-available
>
> In the documentation: https://ci.apache.org/projects/flink/flink-docs-release-1.10/dev/table/sql/queries.html#scan-projection-and-filter
> There is an example:
> {code}
> SELECT * FROM Orders WHERE a % 2 = 0
> {code}
> But % operator is not allowed in Flink:
> {code:java}
> org.apache.calcite.sql.parser.SqlParseException: Percent remainder '%' is not allowed under the current SQL conformance level
> {code}
> Either we correct the documentation to use {{MOD}} function, or allow % operator. 
> This is reported in user-zh ML: http://apache-flink.147419.n8.nabble.com/FLINK-SQL-td3822.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)