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

     1  index-constraints vars=(int, int) index=(@1, @2)
     2  @1 IS NULL AND @2 = 2
     3  ----
     4  [/NULL/2 - /NULL/2]
     5  
     6  index-constraints vars=(int, int) index=(@1, @2)
     7  @1 IS NULL AND @2 > 2
     8  ----
     9  [/NULL/3 - /NULL]
    10  
    11  index-constraints vars=(int, int) index=(@1, @2)
    12  @1 = 1 AND @2 IS NULL
    13  ----
    14  [/1/NULL - /1/NULL]
    15  
    16  index-constraints vars=(int, int) index=(@1, @2)
    17  @1 >= 1 AND @2 IS NULL
    18  ----
    19  [/1/NULL - ]
    20  Remaining filter: @2 IS NULL
    21  
    22  index-constraints vars=(int) index=(@1)
    23  @1 IS NOT DISTINCT FROM NULL
    24  ----
    25  [/NULL - /NULL]
    26  
    27  index-constraints vars=(int) index=(@1)
    28  @1 IS NOT NULL
    29  ----
    30  (/NULL - ]
    31  
    32  index-constraints vars=(int) index=(@1)
    33  @1 IS DISTINCT FROM NULL
    34  ----
    35  (/NULL - ]
    36  
    37  index-constraints vars=(int) index=(@1 desc)
    38  @1 IS NOT NULL
    39  ----
    40  [ - /NULL)
    41  
    42  index-constraints vars=(int) index=(@1 not null)
    43  @1 IS NULL
    44  ----
    45  
    46  index-constraints vars=(int) index=(@1 not null)
    47  @1 IS NOT DISTINCT FROM NULL
    48  ----
    49  
    50  index-constraints vars=(int) index=(@1 not null)
    51  @1 IS NOT NULL
    52  ----
    53  [ - ]
    54  
    55  index-constraints vars=(int) index=(@1 not null)
    56  @1 IS DISTINCT FROM NULL
    57  ----
    58  [ - ]
    59  
    60  index-constraints vars=(int) index=(@1 desc not null)
    61  @1 IS NOT NULL
    62  ----
    63  [ - ]