[jira] [Closed] (FLINK-35965) Add ENDSWITH function

["lincoln lee (Jira)" <ji...@apache.org>]

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

lincoln lee closed FLINK-35965.
-------------------------------
    Fix Version/s: 2.0.0
       Resolution: Fixed

Fixed in master: 5bbdbb2889268e879b6aa06d2cdab02fd6154cb6

> Add ENDSWITH function
> ---------------------
>
>                 Key: FLINK-35965
>                 URL: https://issues.apache.org/jira/browse/FLINK-35965
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table SQL / API
>            Reporter: Dylan He
>            Assignee: Dylan He
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 2.0.0
>
>
> Add ENDSWITH function.
> ----
> Returns if {{expr}} ends with {{endExpr}}.
> Example:
> {code:sql}
> > SELECT ENDSWITH('SparkSQL', 'SQL');
>  true
> > SELECT ENDSWITH('SparkSQL', 'sql');
>  false
> {code}
> Syntax:
> {code:sql}
> ENDSWITH(expr, endExpr)
> {code}
> Arguments:
>  * {{expr}}: A STRING or BINARY expression.
>  * {{endExpr}}: A STRING or BINARY expression.
> Returns:
> A BOOLEAN.
> {{expr}} and {{endExpr}} should have same type.
> If {{expr}} or {{endExpr}} is NULL, the result is NULL.
> If {{endExpr}} is the empty, the result is true.
> See also:
>  * [Spark|https://spark.apache.org/docs/3.5.1/sql-ref-functions-builtin.html#string-functions]
>  * [Databricks|https://docs.databricks.com/en/sql/language-manual/functions/endswith.html]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)