[
https://issues.apache.org/jira/browse/FLINK-28919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jackylau updated FLINK-28919:
-----------------------------
Description:
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]
was:
Syntax:
{code:java}
conv(number, fromBase, toBase)
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
> 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.16.0
> Reporter: jackylau
> Priority: Major
> Fix For: 1.16.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)
