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

     1  index-constraints vars=(int) index=(@1)
     2  NULL
     3  ----
     4  
     5  index-constraints vars=(int) index=(@1)
     6  false
     7  ----
     8  
     9  index-constraints vars=(int) index=(@1)
    10  true
    11  ----
    12  [ - ]
    13  
    14  index-constraints vars=(int) index=(@1)
    15  @1
    16  ----
    17  [ - ]
    18  Remaining filter: @1
    19  
    20  index-constraints vars=(int) index=(@1)
    21  @1 > 2
    22  ----
    23  [/3 - ]
    24  
    25  index-constraints vars=(int) index=(@1)
    26  NOT (@1 <= 2)
    27  ----
    28  [/3 - ]
    29  
    30  index-constraints vars=(int) index=(@1 desc)
    31  @1 > 2
    32  ----
    33  [ - /3]
    34  
    35  index-constraints vars=(int) index=(@1)
    36  @1 >= 2
    37  ----
    38  [/2 - ]
    39  
    40  index-constraints vars=(int) index=(@1 desc)
    41  @1 >= 2
    42  ----
    43  [ - /2]
    44  
    45  index-constraints vars=(int) index=(@1 not null)
    46  @1 != 2
    47  ----
    48  [ - /1]
    49  [/3 - ]
    50  
    51  index-constraints vars=(int) index=(@1 not null)
    52  NOT (@1 = 2)
    53  ----
    54  [ - /1]
    55  [/3 - ]
    56  
    57  index-constraints vars=(int) index=(@1 desc not null)
    58  @1 != 2
    59  ----
    60  [ - /3]
    61  [/1 - ]
    62  
    63  index-constraints vars=(int) index=(@1 not null)
    64  @1 < 2
    65  ----
    66  [ - /1]
    67  
    68  index-constraints vars=(int) index=(@1 desc not null)
    69  @1 < 2
    70  ----
    71  [/1 - ]
    72  
    73  index-constraints vars=(int) index=(@1 not null)
    74  @1 = 2
    75  ----
    76  [/2 - /2]
    77  
    78  index-constraints vars=(int) index=(@1 desc not null)
    79  @1 = 2
    80  ----
    81  [/2 - /2]
    82  
    83  index-constraints vars=(int) index=(@1)
    84  @1 != 2
    85  ----
    86  (/NULL - /1]
    87  [/3 - ]
    88  
    89  index-constraints vars=(int) index=(@1 desc)
    90  @1 != 2
    91  ----
    92  [ - /3]
    93  [/1 - /NULL)
    94  
    95  index-constraints vars=(int) index=(@1)
    96  @1 < 2
    97  ----
    98  (/NULL - /1]
    99  
   100  index-constraints vars=(int) index=(@1 desc)
   101  @1 < 2
   102  ----
   103  [/1 - /NULL)
   104  
   105  index-constraints vars=(int) index=(@1)
   106  @1 = 2
   107  ----
   108  [/2 - /2]
   109  
   110  index-constraints vars=(int) index=(@1 desc)
   111  @1 = 2
   112  ----
   113  [/2 - /2]
   114  
   115  index-constraints vars=(int) index=(@1)
   116  NULL
   117  ----
   118  
   119  index-constraints vars=(int) index=(@1)
   120  @1 > NULL
   121  ----
   122  
   123  index-constraints vars=(int) index=(@1)
   124  @1 < NULL
   125  ----
   126  
   127  index-constraints vars=(int) index=(@1)
   128  @1 >= NULL
   129  ----
   130  
   131  index-constraints vars=(int) index=(@1)
   132  @1 >= NULL
   133  ----
   134  
   135  index-constraints vars=(int) index=(@1)
   136  @1 = NULL
   137  ----
   138  
   139  index-constraints vars=(int) index=(@1)
   140  @1 != NULL
   141  ----
   142  
   143  index-constraints vars=(bool) index=(@1)
   144  @1
   145  ----
   146  [/true - /true]
   147  
   148  index-constraints vars=(bool) index=(@1)
   149  NOT @1
   150  ----
   151  [/false - /false]
   152  
   153  index-constraints vars=(bool) index=(@1)
   154  @1 != true
   155  ----
   156  (/NULL - /false]
   157  
   158  index-constraints vars=(bool) index=(@1)
   159  @1 != false
   160  ----
   161  [/true - ]
   162  
   163  index-constraints vars=(bool) index=(@1)
   164  @1 IS TRUE
   165  ----
   166  [/true - /true]
   167  
   168  index-constraints vars=(bool) index=(@1)
   169  @1 IS FALSE
   170  ----
   171  [/false - /false]
   172  
   173  index-constraints vars=(bool) index=(@1)
   174  @1 IS NOT TRUE
   175  ----
   176  [ - /false]
   177  
   178  index-constraints vars=(bool) index=(@1)
   179  @1 IS NOT FALSE
   180  ----
   181  [ - /false)
   182  [/true - ]
   183  
   184  index-constraints vars=(int) index=(@1)
   185  @1 IS NOT DISTINCT FROM 5
   186  ----
   187  [/5 - /5]
   188  
   189  index-constraints vars=(int) index=(@1)
   190  @1 IS DISTINCT FROM 5
   191  ----
   192  [ - /4]
   193  [/6 - ]
   194  
   195  index-constraints vars=(bool) index=(@1 desc)
   196  @1 != true
   197  ----
   198  [/false - /NULL)
   199  
   200  index-constraints vars=(bool) index=(@1 desc)
   201  @1 != false
   202  ----
   203  [ - /true]
   204  
   205  index-constraints vars=(bool) index=(@1 desc)
   206  @1 IS TRUE
   207  ----
   208  [/true - /true]
   209  
   210  index-constraints vars=(bool) index=(@1 desc)
   211  @1 IS FALSE
   212  ----
   213  [/false - /false]
   214  
   215  index-constraints vars=(bool) index=(@1 desc)
   216  @1 IS NOT TRUE
   217  ----
   218  [/false - ]
   219  
   220  index-constraints vars=(bool) index=(@1 desc)
   221  @1 IS NOT FALSE
   222  ----
   223  [ - /true]
   224  (/false - ]
   225  
   226  index-constraints vars=(int) index=(@1 desc)
   227  @1 IS NOT DISTINCT FROM 5
   228  ----
   229  [/5 - /5]
   230  
   231  index-constraints vars=(int) index=(@1)
   232  @1 = -1
   233  ----
   234  [/-1 - /-1]
   235  
   236  index-constraints vars=(decimal) index=(@1)
   237  @1 = -2.0
   238  ----
   239  [/-2.0 - /-2.0]
   240  
   241  index-constraints vars=(int) index=(@1 desc)
   242  @1 IS DISTINCT FROM 5
   243  ----
   244  [ - /6]
   245  [/4 - ]
   246  
   247  index-constraints vars=(bool) index=(@1 not null)
   248  @1 IS NOT TRUE
   249  ----
   250  [ - /false]
   251  
   252  index-constraints vars=(bool) index=(@1 not null)
   253  @1 IS NOT FALSE
   254  ----
   255  [/true - ]
   256  
   257  index-constraints vars=(bool) index=(@1 desc not null)
   258  @1 IS NOT TRUE
   259  ----
   260  [/false - ]
   261  
   262  index-constraints vars=(bool) index=(@1 desc not null)
   263  @1 IS NOT FALSE
   264  ----
   265  [ - /true]