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

     1  # This test verifies that we correctly perform an index join when the KV
     2  # batches span ranges. This is testing that SQL disables batch limits for index
     3  # join; otherwise it can get out of order results from KV that it can't handle.
     4  
     5  kv-batch-size 10
     6  
     7  statement ok
     8  CREATE TABLE t (
     9    a INT PRIMARY KEY,
    10    b INT,
    11    c INT,
    12    d INT,
    13    FAMILY (a),
    14    FAMILY (b),
    15    FAMILY (c),
    16    FAMILY (d),
    17    INDEX c (c)
    18  )
    19  
    20  statement ok
    21  INSERT INTO t VALUES
    22  (1, 0, 99, 0),
    23  (2, 0, 80, 0),
    24  (3, 0, 90, 0),
    25  (4, 0, 10, 0),
    26  (5, 0, 20, 0),
    27  (6, 0, 85, 0),
    28  (7, 0, 91, 0),
    29  (8, 0, 12, 0),
    30  (9, 0, 91, 0),
    31  (10, 0, 11, 0),
    32  (11, 0, 12, 0),
    33  (12, 0, 88, 0),
    34  (13, 0, 13, 0)
    35  
    36  # Split the table across multiple ranges.
    37  statement ok
    38  ALTER TABLE t SPLIT AT VALUES (2)
    39  
    40  statement ok
    41  ALTER TABLE t SPLIT AT VALUES (3)
    42  
    43  statement ok
    44  ALTER TABLE t SPLIT AT VALUES (5)
    45  
    46  statement ok
    47  ALTER TABLE t SPLIT AT VALUES (8)
    48  
    49  statement ok
    50  ALTER INDEX t@c SPLIT AT VALUES (90)
    51  
    52  statement ok
    53  ALTER INDEX c SPLIT AT VALUES (10)
    54  
    55  query IIII partialsort(3)
    56  SELECT * FROM t@c WHERE (c >= 80) ORDER BY c
    57  ----
    58  2   0  80  0
    59  6   0  85  0
    60  12  0  88  0
    61  3   0  90  0
    62  7   0  91  0
    63  9   0  91  0
    64  1   0  99  0