[jira] [Created] (FLINK-28919) Add built-in generate_series function.

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

jackylau created FLINK-28919:
--------------------------------

             Summary: 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
             Fix For: 1.16.0


 

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



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