github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/idxconstraint/testdata/strings (about)

     1  index-constraints vars=(string) index=@1
     2  @1 LIKE 'ABC%'
     3  ----
     4  [/'ABC' - /'ABD')
     5  
     6  index-constraints vars=(string) index=@1
     7  @1 LIKE 'ABC_'
     8  ----
     9  [/'ABC' - /'ABD')
    10  Remaining filter: @1 LIKE 'ABC_'
    11  
    12  index-constraints vars=(string) index=@1
    13  @1 LIKE 'ABC%Z'
    14  ----
    15  [/'ABC' - /'ABD')
    16  Remaining filter: @1 LIKE 'ABC%Z'
    17  
    18  index-constraints vars=(string) index=@1
    19  @1 LIKE 'ABC'
    20  ----
    21  [/'ABC' - /'ABC']
    22  
    23  index-constraints vars=(string) index=@1
    24  @1 LIKE '%'
    25  ----
    26  (/NULL - ]
    27  Remaining filter: @1 LIKE '%'
    28  
    29  index-constraints vars=(string) index=@1
    30  @1 LIKE '%XY'
    31  ----
    32  (/NULL - ]
    33  Remaining filter: @1 LIKE '%XY'
    34  
    35  index-constraints vars=(string) index=(@1 desc)
    36  @1 LIKE 'ABC%'
    37  ----
    38  (/'ABD' - /'ABC']
    39  
    40  index-constraints vars=(int,string) index=(@1, @2 desc)
    41  @1 = 1 AND @2 LIKE 'ABC%'
    42  ----
    43  (/1/'ABD' - /1/'ABC']
    44  
    45  index-constraints vars=(int,string) index=(@1, @2 desc)
    46  @1 >= 1 AND @1 <= 4 AND @2 LIKE 'ABC%'
    47  ----
    48  (/1/'ABD' - /4/'ABC']
    49  Remaining filter: @2 LIKE 'ABC%'
    50  
    51  index-constraints vars=(string) index=(@1)
    52  @1 SIMILAR TO 'ABC.*'
    53  ----
    54  [/'ABC' - /'ABD')
    55  Remaining filter: @1 SIMILAR TO 'ABC.*'
    56  
    57  index-constraints vars=(string) index=(@1)
    58  @1 SIMILAR TO 'ABC.*Z'
    59  ----
    60  [/'ABC' - /'ABD')
    61  Remaining filter: @1 SIMILAR TO 'ABC.*Z'
    62  
    63  index-constraints vars=(string) index=(@1)
    64  @1 SIMILAR TO 'ABC'
    65  ----
    66  [/'ABC' - /'ABC']
    67  
    68  index-constraints vars=(string) index=(@1)
    69  @1 SIMILAR TO '(ABC|ABCDEF).*'
    70  ----
    71  [/'ABC' - /'ABD')
    72  Remaining filter: @1 SIMILAR TO '(ABC|ABCDEF).*'
    73  
    74  index-constraints vars=(string) index=(@1)
    75  @1 SIMILAR TO '.*'
    76  ----
    77  [/'' - ]
    78  Remaining filter: @1 SIMILAR TO '.*'
    79  
    80  index-constraints vars=(string) index=(@1)
    81  @1 = 'eu' OR (@1 > 'eu' AND @1 < 'us')
    82  ----
    83  [/'eu' - /'us')
    84  
    85  index-constraints vars=(string, string) index=(@1, @2)
    86  (@1 = 'us' AND @2 = 'cali') OR (@1 = 'eu') OR (@1 > 'eu' AND @1 < 'us')
    87  ----
    88  [/'eu' - /'us')
    89  [/'us'/'cali' - /'us'/'cali']