github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/rows_from (about)

     1  query II colnames
     2  SELECT * FROM ROWS FROM (generate_series(1,2), generate_series(4,8))
     3  ----
     4  generate_series  generate_series
     5  1                4
     6  2                5
     7  NULL             6
     8  NULL             7
     9  NULL             8
    10  
    11  query II colnames
    12  SELECT * FROM ROWS FROM (generate_series(1,4), generate_series(4,5))
    13  ----
    14  generate_series  generate_series
    15  1                4
    16  2                5
    17  3                NULL
    18  4                NULL
    19  
    20  query II colnames
    21  SELECT * FROM ROWS FROM (generate_series(1,0), generate_series(1,0))
    22  ----
    23  generate_series  generate_series
    24  
    25  query II colnames
    26  SELECT * FROM ROWS FROM (generate_series(1,0), generate_series(1,1))
    27  ----
    28  generate_series  generate_series
    29  NULL             1
    30  
    31  query II colnames
    32  SELECT * FROM ROWS FROM (generate_series(1,2), greatest(1,2,3,4))
    33  ----
    34  generate_series  greatest
    35  1                4
    36  2                NULL
    37  
    38  query IT colnames
    39  SELECT * FROM ROWS FROM (generate_series(1,2), current_user)
    40  ----
    41  generate_series  current_user
    42  1                root
    43  2                NULL
    44  
    45  query TI colnames
    46  SELECT * FROM ROWS FROM (current_user, generate_series(1,2))
    47  ----
    48  current_user generate_series
    49  root         1
    50  NULL         2
    51  
    52  query TT colnames
    53  SELECT * FROM ROWS FROM (current_user, current_user)
    54  ----
    55  current_user current_user
    56  root         root
    57  
    58  query III colnames
    59  SELECT * FROM ROWS FROM (information_schema._pg_expandarray(array[4,5,6]), generate_series(10,15));
    60  ----
    61  x     n     generate_series
    62  4     1     10
    63  5     2     11
    64  6     3     12
    65  NULL  NULL  13
    66  NULL  NULL  14
    67  NULL  NULL  15
    68  
    69  # Regression test for #27389.
    70  
    71  statement error pg_get_keywords\(\): set-returning functions must appear at the top level of FROM
    72  SELECT * FROM ROWS FROM(generate_series(length((pg_get_keywords()).word),10));