forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commita7cfd65
committed
Fixes:
Select queries with an isnull or notnull clause, like "select * wheresomefield isnull", crash the backend if the table has at least one index.If the indices are deleted the queries work again. Also the explaincommand fail in the same way.The is caused by a bug in subroutine of the optimizer which doesn't checknull values in the clauses.Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>1 parent3704b99 commita7cfd65
2 files changed
+9
-9
lines changedLines changed: 8 additions & 6 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
493 | 493 |
| |
494 | 494 |
| |
495 | 495 |
| |
496 |
| - | |
| 496 | + | |
497 | 497 |
| |
498 | 498 |
| |
499 | 499 |
| |
| |||
507 | 507 |
| |
508 | 508 |
| |
509 | 509 |
| |
510 |
| - | |
| 510 | + | |
511 | 511 |
| |
512 | 512 |
| |
513 | 513 |
| |
| |||
535 | 535 |
| |
536 | 536 |
| |
537 | 537 |
| |
538 |
| - | |
| 538 | + | |
| 539 | + | |
539 | 540 |
| |
540 | 541 |
| |
541 | 542 |
| |
542 |
| - | |
543 |
| - | |
| 543 | + | |
| 544 | + | |
| 545 | + | |
544 | 546 |
| |
545 | 547 |
| |
546 | 548 |
| |
|
Lines changed: 1 addition & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
7 | 7 |
| |
8 | 8 |
| |
9 | 9 |
| |
10 |
| - | |
| 10 | + | |
11 | 11 |
| |
12 | 12 |
| |
13 | 13 |
| |
| |||
198 | 198 |
| |
199 | 199 |
| |
200 | 200 |
| |
201 |
| - | |
202 |
| - | |
203 | 201 |
| |
204 | 202 |
| |
205 | 203 |
| |
|
0 commit comments
Comments
(0)