github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/between (about)

     1  # Range conditions.
     2  
     3  eval
     4  0 BETWEEN 1 AND 3
     5  ----
     6  false
     7  
     8  eval
     9  1 BETWEEN 1 AND 3
    10  ----
    11  true
    12  
    13  eval
    14  2 BETWEEN 1 AND 3
    15  ----
    16  true
    17  
    18  eval
    19  2 BETWEEN 3 AND 1
    20  ----
    21  false
    22  
    23  eval
    24  3 BETWEEN 1 AND 3
    25  ----
    26  true
    27  
    28  eval
    29  4 BETWEEN 1 AND 3
    30  ----
    31  false
    32  
    33  eval
    34  0 BETWEEN ASYMMETRIC 1 AND 3
    35  ----
    36  false
    37  
    38  eval
    39  2 BETWEEN ASYMMETRIC 1 AND 3
    40  ----
    41  true
    42  
    43  eval
    44  0 NOT BETWEEN 1 AND 3
    45  ----
    46  true
    47  
    48  eval
    49  2 NOT BETWEEN 1 AND 3
    50  ----
    51  false
    52  
    53  eval
    54  2 NOT BETWEEN 3 AND 1
    55  ----
    56  true
    57  
    58  eval
    59  'foo' BETWEEN 'a' AND 'z'
    60  ----
    61  true
    62  
    63  eval
    64  0 BETWEEN SYMMETRIC 1 AND 3
    65  ----
    66  false
    67  
    68  eval
    69  1 BETWEEN SYMMETRIC 3 AND 1
    70  ----
    71  true
    72  
    73  eval
    74  1 BETWEEN SYMMETRIC 1 AND 3
    75  ----
    76  true
    77  
    78  eval
    79  2 BETWEEN SYMMETRIC 3 AND 1
    80  ----
    81  true
    82  
    83  eval
    84  2 BETWEEN SYMMETRIC 1 AND 3
    85  ----
    86  true
    87  
    88  eval
    89  3 BETWEEN SYMMETRIC 3 AND 1
    90  ----
    91  true
    92  
    93  eval
    94  3 BETWEEN SYMMETRIC 1 AND 3
    95  ----
    96  true
    97  
    98  eval
    99  4 BETWEEN SYMMETRIC 1 AND 3
   100  ----
   101  false
   102  
   103  eval
   104  2 NOT BETWEEN SYMMETRIC 1 AND 3
   105  ----
   106  false
   107  
   108  eval
   109  2 NOT BETWEEN SYMMETRIC 3 AND 1
   110  ----
   111  false
   112  
   113  eval
   114  0 NOT BETWEEN SYMMETRIC 1 AND 3
   115  ----
   116  true
   117  
   118  eval
   119  0 NOT BETWEEN SYMMETRIC 3 AND 1
   120  ----
   121  true