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