github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/row (about) 1 # Row 2 3 eval 4 ROW() 5 ---- 6 () 7 8 # Row (tuple) comparisons. 9 10 eval 11 ROW(1) = ROW(1) 12 ---- 13 true 14 15 eval 16 ROW(1, true) = (1, NOT false) 17 ---- 18 true 19 20 eval 21 (1, 'a') = (1, 'a') 22 ---- 23 true 24 25 eval 26 (1, 'a' || 1::char) = (1, 'a1') 27 ---- 28 true 29 30 eval 31 (1+1, (2+2, (3+3))) = (2, (4, (6))) 32 ---- 33 true 34 35 eval 36 (1, 'a') != (1, 'a') 37 ---- 38 false 39 40 eval 41 (1, 'a') != (1, 'b') 42 ---- 43 true 44 45 eval 46 (1, 2, 3) = (1, 2, 3) 47 ---- 48 true 49 50 eval 51 (1, 2, 3) != (1, 2, 3) 52 ---- 53 false 54 55 eval 56 (1, 2, 3) > (1, 2, 3) 57 ---- 58 false 59 60 eval 61 (1, 2, 3) >= (1, 2, 3) 62 ---- 63 true 64 65 eval 66 (1, 2, 3) < (1, 2, 3) 67 ---- 68 false 69 70 eval 71 (1, 2, 3) <= (1, 2, 3) 72 ---- 73 true 74 75 eval 76 (1, 2, 3) = (1, 2, 4) 77 ---- 78 false 79 80 eval 81 (1, 2, 3) != (1, 2, 4) 82 ---- 83 true 84 85 eval 86 (1, 2, 3) > (1, 2, 4) 87 ---- 88 false 89 90 eval 91 (1, 2, 3) >= (1, 2, 4) 92 ---- 93 false 94 95 eval 96 (1, 2, 4) = (1, 2, 3) 97 ---- 98 false 99 100 eval 101 (1, 2, 4) != (1, 2, 3) 102 ---- 103 true 104 105 eval 106 (1, 2, 4) > (1, 2, 3) 107 ---- 108 true 109 110 eval 111 (1, 2, 4) >= (1, 2, 3) 112 ---- 113 true 114 115 # Row (tuple) comparisons with NULLs. 116 117 eval 118 (1, 2, 3) = (1, NULL, 3) 119 ---- 120 NULL 121 122 eval 123 (1, 2, 3) != (1, NULL, 3) 124 ---- 125 NULL 126 127 eval 128 (1, 2, 3) > (1, NULL, 3) 129 ---- 130 NULL 131 132 eval 133 (1, 2, 3) >= (1, NULL, 3) 134 ---- 135 NULL 136 137 eval 138 (1, 2, 3) = (0, NULL, 3) 139 ---- 140 false 141 142 eval 143 (1, 2, 3) != (0, NULL, 3) 144 ---- 145 true 146 147 eval 148 (1, 2, 3) > (0, NULL, 3) 149 ---- 150 true 151 152 eval 153 (1, 2, 3) >= (0, NULL, 3) 154 ---- 155 true 156 157 eval 158 (1, 2, 3) = (2, NULL, 3) 159 ---- 160 false 161 162 eval 163 (1, 2, 3) != (2, NULL, 3) 164 ---- 165 true 166 167 eval 168 (1, 2, 3) > (2, NULL, 3) 169 ---- 170 false 171 172 eval 173 (1, 2, 3) >= (2, NULL, 3) 174 ---- 175 false 176 177 eval 178 (1, 2, 3) = (1, NULL, 4) 179 ---- 180 false 181 182 eval 183 (1, 2, 3) != (1, NULL, 4) 184 ---- 185 true 186 187 eval 188 (1, 2, 3) > (1, NULL, 4) 189 ---- 190 NULL 191 192 eval 193 (1, 2, 3) >= (1, NULL, 4) 194 ---- 195 NULL 196 197 eval 198 (1, NULL, 3) = (1, 2, 3) 199 ---- 200 NULL 201 202 eval 203 (1, NULL, 3) != (1, 2, 3) 204 ---- 205 NULL 206 207 eval 208 (1, NULL, 3) > (1, 2, 3) 209 ---- 210 NULL 211 212 eval 213 (1, NULL, 3) >= (1, 2, 3) 214 ---- 215 NULL 216 217 eval 218 (1, NULL, 3) = (0, 2, 3) 219 ---- 220 false 221 222 eval 223 (1, NULL, 3) != (0, 2, 3) 224 ---- 225 true 226 227 eval 228 (1, NULL, 3) > (0, 2, 3) 229 ---- 230 true 231 232 eval 233 (1, NULL, 3) >= (0, 2, 3) 234 ---- 235 true 236 237 eval 238 (1, NULL, 3) = (2, 2, 3) 239 ---- 240 false 241 242 eval 243 (1, NULL, 3) != (2, 2, 3) 244 ---- 245 true 246 247 eval 248 (1, NULL, 3) > (2, 2, 3) 249 ---- 250 false 251 252 eval 253 (1, NULL, 3) >= (2, 2, 3) 254 ---- 255 false 256 257 eval 258 (1, NULL, 3) = (1, 2, 4) 259 ---- 260 false 261 262 eval 263 (1, NULL, 3) != (1, 2, 4) 264 ---- 265 true 266 267 eval 268 (1, NULL, 3) > (1, 2, 4) 269 ---- 270 NULL 271 272 eval 273 (1, NULL, 3) >= (1, 2, 4) 274 ---- 275 NULL 276 277 # Tuple equality is equivalent to conjunctive equality. 278 279 eval 280 (1, 2, 3) = (1, 2, 3) 281 ---- 282 true 283 284 eval 285 1 = 1 AND 2 = 2 AND 3 = 3 286 ---- 287 true 288 289 eval 290 (1, 2, 3) = (2, 2, 3) 291 ---- 292 false 293 294 eval 295 1 = 2 AND 2 = 2 AND 3 = 3 296 ---- 297 false 298 299 eval 300 (1, 2, 4) = (1, 2, 3) 301 ---- 302 false 303 304 eval 305 1 = 1 AND 2 = 2 AND 4 = 3 306 ---- 307 false 308 309 eval 310 (NULL, 2, 3) = (1, 2, 3) 311 ---- 312 NULL 313 314 eval 315 NULL = 1 AND 2 = 2 AND 3 = 3 316 ---- 317 NULL 318 319 eval 320 (NULL, 2, 3) = (NULL, 2, 3) 321 ---- 322 NULL 323 324 eval 325 NULL = NULL AND 2 = 2 AND 3 = 3 326 ---- 327 NULL 328 329 eval 330 (NULL, 2, 3) = (NULL, 3, 3) 331 ---- 332 false 333 334 eval 335 NULL = NULL AND 2 = 3 AND 3 = 3 336 ---- 337 false 338 339 eval 340 (NULL, 2, 3) = (1, 2, NULL) 341 ---- 342 NULL 343 344 eval 345 NULL = 1 AND 2 = 2 AND 3 = NULL 346 ---- 347 NULL