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

     1  # LogicTest: 5node-default-configs
     2  
     3  # Regression test for #32652: make sure subqueries that have extra columns for
     4  # stream merges don't crash when executed.
     5  
     6  statement ok
     7  CREATE TABLE ab (a INT, b INT)
     8  
     9  statement ok
    10  INSERT INTO ab VALUES (1, 1), (1, 3), (2, 2)
    11  
    12  statement ok
    13  SET CLUSTER SETTING kv.range_merge.queue_enabled = false
    14  
    15  statement ok
    16  ALTER TABLE ab SPLIT AT VALUES (2)
    17  
    18  statement ok
    19  ALTER TABLE ab EXPERIMENTAL_RELOCATE VALUES (ARRAY[1], 1), (ARRAY[2], 2)
    20  
    21  query TTTI colnames
    22  SELECT start_key, end_key, replicas, lease_holder from [SHOW RANGES FROM TABLE ab]
    23  ----
    24  start_key  end_key  replicas  lease_holder
    25  NULL       /2       {1}       1
    26  /2         NULL     {2}       2
    27  
    28  query T
    29  SELECT ARRAY(SELECT a FROM ab ORDER BY b)
    30  ----
    31  {1,2,1}