forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commita5652d3
committed
Restore correct btree preprocessing of "indexedcol IS NULL" conditions.
Such a condition is unsatisfiable in combination with any other type ofbtree-indexable condition (since we assume btree operators are alwaysstrict). 8.3 and 8.4 had an explicit test for this, which I removed incommit29c4ad9, mistakenly thinking thatthe case would be subsumed by the more general handling of IS (NOT) NULLadded in that patch. Put it back, and improve the comments about it, andadd a regression test case.Per bug #6079 from Renat Nasyrov, and analysis by Dean Rasheed.1 parentcd70dd6 commita5652d3
File tree
3 files changed
+71
-2
lines changed- src
- backend/access/nbtree
- test/regress
- expected
- sql
3 files changed
+71
-2
lines changedLines changed: 15 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
325 | 325 |
| |
326 | 326 |
| |
327 | 327 |
| |
328 |
| - | |
329 |
| - | |
| 328 | + | |
| 329 | + | |
| 330 | + | |
| 331 | + | |
| 332 | + | |
| 333 | + | |
| 334 | + | |
| 335 | + | |
330 | 336 |
| |
331 | 337 |
| |
332 | 338 |
| |
| |||
339 | 345 |
| |
340 | 346 |
| |
341 | 347 |
| |
| 348 | + | |
| 349 | + | |
| 350 | + | |
| 351 | + | |
| 352 | + | |
| 353 | + | |
| 354 | + | |
342 | 355 |
| |
343 | 356 |
| |
344 | 357 |
| |
|
Lines changed: 48 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1279 | 1279 |
| |
1280 | 1280 |
| |
1281 | 1281 |
| |
| 1282 | + | |
| 1283 | + | |
| 1284 | + | |
| 1285 | + | |
| 1286 | + | |
| 1287 | + | |
| 1288 | + | |
| 1289 | + | |
| 1290 | + | |
| 1291 | + | |
| 1292 | + | |
| 1293 | + | |
1282 | 1294 |
| |
1283 | 1295 |
| |
1284 | 1296 |
| |
| |||
1305 | 1317 |
| |
1306 | 1318 |
| |
1307 | 1319 |
| |
| 1320 | + | |
| 1321 | + | |
| 1322 | + | |
| 1323 | + | |
| 1324 | + | |
| 1325 | + | |
| 1326 | + | |
| 1327 | + | |
| 1328 | + | |
| 1329 | + | |
| 1330 | + | |
| 1331 | + | |
1308 | 1332 |
| |
1309 | 1333 |
| |
1310 | 1334 |
| |
| |||
1331 | 1355 |
| |
1332 | 1356 |
| |
1333 | 1357 |
| |
| 1358 | + | |
| 1359 | + | |
| 1360 | + | |
| 1361 | + | |
| 1362 | + | |
| 1363 | + | |
| 1364 | + | |
| 1365 | + | |
| 1366 | + | |
| 1367 | + | |
| 1368 | + | |
| 1369 | + | |
1334 | 1370 |
| |
1335 | 1371 |
| |
1336 | 1372 |
| |
| |||
1357 | 1393 |
| |
1358 | 1394 |
| |
1359 | 1395 |
| |
| 1396 | + | |
| 1397 | + | |
| 1398 | + | |
| 1399 | + | |
| 1400 | + | |
| 1401 | + | |
| 1402 | + | |
| 1403 | + | |
| 1404 | + | |
| 1405 | + | |
| 1406 | + | |
| 1407 | + | |
1360 | 1408 |
| |
1361 | 1409 |
| |
1362 | 1410 |
| |
|
Lines changed: 8 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
451 | 451 |
| |
452 | 452 |
| |
453 | 453 |
| |
| 454 | + | |
| 455 | + | |
454 | 456 |
| |
455 | 457 |
| |
456 | 458 |
| |
| |||
460 | 462 |
| |
461 | 463 |
| |
462 | 464 |
| |
| 465 | + | |
| 466 | + | |
463 | 467 |
| |
464 | 468 |
| |
465 | 469 |
| |
| |||
469 | 473 |
| |
470 | 474 |
| |
471 | 475 |
| |
| 476 | + | |
| 477 | + | |
472 | 478 |
| |
473 | 479 |
| |
474 | 480 |
| |
| |||
478 | 484 |
| |
479 | 485 |
| |
480 | 486 |
| |
| 487 | + | |
| 488 | + | |
481 | 489 |
| |
482 | 490 |
| |
483 | 491 |
| |
|
0 commit comments
Comments
(0)