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

     1  # IN and NOT IN expressions.
     2  
     3  eval
     4  1 NOT IN (2, 3, 4)
     5  ----
     6  true
     7  
     8  eval
     9  1+1 IN (2, 3, 4)
    10  ----
    11  true
    12  
    13  eval
    14  2.2 IN (2.1, 2.2, 2.3)
    15  ----
    16  true
    17  
    18  eval
    19  2.0 IN (2.1, 2.2, 2.3)
    20  ----
    21  false
    22  
    23  eval
    24  'a0' IN ('a'||0::char, 'b'||1::char, 'c'||2::char)
    25  ----
    26  true
    27  
    28  eval
    29  '2012-09-21'::date IN ('2012-09-21'::date)
    30  ----
    31  true
    32  
    33  eval
    34  '12:00:00'::time IN ('12:00:00'::time)
    35  ----
    36  true
    37  
    38  eval
    39  '2010-09-28 12:00:00.1'::timestamp IN ('2010-09-28 12:00:00.1'::timestamp)
    40  ----
    41  true
    42  
    43  eval
    44  '34h'::interval IN ('34h'::interval)
    45  ----
    46  true
    47  
    48  eval
    49  (1, 2) IN ((0+1, 1+1), (3, 4), (5, 6))
    50  ----
    51  true
    52  
    53  eval
    54  (1, 2) IN ((2, 1), (3, 4))
    55  ----
    56  false
    57  
    58  eval
    59  1 IN (1, 2, NULL)
    60  ----
    61  true
    62  
    63  eval
    64  NULL IN (1, 2, NULL)
    65  ----
    66  NULL
    67  
    68  eval
    69  (1, 2) IN ((NULL, 2), (1, NULL), (1, 2))
    70  ----
    71  true
    72  
    73  eval
    74  (1, 2) IN ((1, NULL), (NULL, 2))
    75  ----
    76  NULL
    77  
    78  eval
    79  (1, NULL) IN ((1, NULL), (NULL, 2), (3, 4))
    80  ----
    81  NULL
    82  
    83  eval
    84  (1, NULL) IN ((NULL, 2), (3, 4))
    85  ----
    86  NULL
    87  
    88  eval
    89  (1, NULL) IN ((3, 4))
    90  ----
    91  false
    92  
    93  eval
    94  (NULL, 2) IN ((1, NULL), (NULL, 2), (3, 4))
    95  ----
    96  NULL
    97  
    98  eval
    99  (NULL, 2) IN ((1, NULL), (3, 4))
   100  ----
   101  NULL
   102  
   103  eval
   104  (NULL, 2) IN ((3, 4))
   105  ----
   106  false
   107  
   108  eval
   109  (NULL, NULL) IN ((NULL, NULL), (1, NULL), (NULL, 2), (3, 4))
   110  ----
   111  NULL
   112  
   113  eval
   114  (NULL, NULL) IN ((1, NULL), (NULL, 2), (3, 4))
   115  ----
   116  NULL
   117  
   118  eval
   119  (NULL, NULL) IN ((NULL, 2), (3, 4))
   120  ----
   121  NULL
   122  
   123  eval
   124  (NULL, NULL) IN ((3, 4))
   125  ----
   126  NULL
   127  
   128  eval
   129  NULL IN ()
   130  ----
   131  false
   132  
   133  eval
   134  1 IN ()
   135  ----
   136  false