[jira] [Updated] (FLINK-31622) Add ARRAY_APPEND supported in SQL & Table API

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

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

jackylau updated FLINK-31622:
-----------------------------
    Description: 
array_append(array, element) - Append the element at the end of the array.

Syntax:
array_append(array, element)

Arguments:
array: An ARRAY to be handled.

Returns:

Append the element at the end of the array.

This function does not return null when the elements are null. It appends null at the end of the array. But returns null if the array is null.
{code:sql}
> SELECT array_append(array(3, 2, 1), 1);
 3 {code}
See also
spark not in docs but in code.

snowflake https://docs.snowflake.com/en/sql-reference/functions/array_append

postgresql [https://www.postgresql.org/docs/12/functions-array.html#ARRAY-FUNCTIONS-TABLE]

> Add ARRAY_APPEND supported in SQL & Table API
> ---------------------------------------------
>
>                 Key: FLINK-31622
>                 URL: https://issues.apache.org/jira/browse/FLINK-31622
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / Planner
>    Affects Versions: 1.18.0
>            Reporter: jackylau
>            Priority: Major
>             Fix For: 1.18.0
>
>
> array_append(array, element) - Append the element at the end of the array.
> Syntax:
> array_append(array, element)
> Arguments:
> array: An ARRAY to be handled.
> Returns:
> Append the element at the end of the array.
> This function does not return null when the elements are null. It appends null at the end of the array. But returns null if the array is null.
> {code:sql}
> > SELECT array_append(array(3, 2, 1), 1);
>  3 {code}
> See also
> spark not in docs but in code.
> snowflake https://docs.snowflake.com/en/sql-reference/functions/array_append
> postgresql [https://www.postgresql.org/docs/12/functions-array.html#ARRAY-FUNCTIONS-TABLE]



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