[
https://issues.apache.org/jira/browse/FLINK-28919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jackylau updated FLINK-28919:
-----------------------------
Affects Version/s: 1.17.0
(was: 1.16.0)
> Add built-in generate_series function.
> --------------------------------------
>
> Key: FLINK-28919
> URL: https://issues.apache.org/jira/browse/FLINK-28919
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Affects Versions: 1.17.0
> Reporter: jackylau
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.17.0
>
>
>
> Syntax:
> {code:java}
> generate_series ( start numeric, stop numeric [, step numeric ] ) → setof
> numeric{code}
> and it does n't support timestamp now, just like mysql
> Returns:
> When _{{step}}_ is positive, zero rows are returned if _{{start}}_ is greater
> than {_}{{stop}}{_}. Conversely, when _{{step}}_ is negative, zero rows are
> returned if _{{start}}_ is less than {_}{{stop}}{_}. Zero rows are also
> returned if any input is {{{}NULL{}}}. It is an error for _{{step}}_ to be
> zero. Some examples follow:
> Examples:
> {code:java}
> SELECT * FROM generate_series(2,4);
> generate_series
> -----------------
> 2
> 3
> 4
> (3 rows)
> SELECT * FROM generate_series(5,1,-2);
> generate_series
> -----------------
> 5
> 3
> 1
> (3 rows)
> SELECT * FROM generate_series(4,3);
> generate_series
> -----------------
> (0 rows)
> SELECT generate_series(1.1, 4, 1.3);
> generate_series
> -----------------
> 1.1
> 2.4
> 3.7{code}
> See more:
> * pg: [https://www.postgresql.org/docs/current/functions-srf.html]
> * mysql:
> [https://docs.microsoft.com/en-us/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
