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

     1  statement ok
     2  CREATE TABLE data (a INT PRIMARY KEY)
     3  
     4  statement ok
     5  INSERT INTO data SELECT generate_series(0, 9)
     6  
     7  # Correlated SRF
     8  query II
     9  SELECT a, generate_series(a, a + 1) FROM data ORDER BY 1, 2
    10  ----
    11  0  0
    12  0  1
    13  1  1
    14  1  2
    15  2  2
    16  2  3
    17  3  3
    18  3  4
    19  4  4
    20  4  5
    21  5  5
    22  5  6
    23  6  6
    24  6  7
    25  7  7
    26  7  8
    27  8  8
    28  8  9
    29  9  9
    30  9  10
    31  
    32  # Filter on ProjectSet node
    33  query II rowsort
    34  SELECT a, b FROM (SELECT a, generate_series(1, 3) AS b FROM data) WHERE a < 4 AND b = 3
    35  ----
    36  0  3
    37  1  3
    38  2  3
    39  3  3
    40  
    41  # Multiple SRFs with different lengths
    42  query III
    43  SELECT a, generate_series(1, 2), generate_series(1, 4) FROM data WHERE a < 2 ORDER BY 1, 2, 3
    44  ----
    45  0  NULL  3
    46  0  NULL  4
    47  0  1     1
    48  0  2     2
    49  1  NULL  3
    50  1  NULL  4
    51  1  1     1
    52  1  2     2
    53  
    54  statement ok
    55  CREATE TABLE groups(
    56    id SERIAL,
    57    data jsonb,
    58    primary key (id)
    59  )
    60  
    61  query TT
    62  SELECT g.data->>'name' AS group_name, jsonb_array_elements(g.data->'members') FROM groups g;
    63  ----