diff options
author | Marc G. Fournier <scrappy@hub.org> | 1996-10-30 06:06:50 +0000 |
---|---|---|
committer | Marc G. Fournier <scrappy@hub.org> | 1996-10-30 06:06:50 +0000 |
commit | 025709640c48fa5906fa90dcf09f4ae711703ccb (patch) | |
tree | 87042961d8acfc9b4dd6800f8950e93412946459 /src/backend/tcop/postgres.c | |
parent | 65e5e59f8379ed367ed6100424bd34a569d099f3 (diff) |
More btree fixes from Massimo Dal Zotto <dz@cs.unitn.it>
Fixes:
I found another bug in btree index. Looking at the code it seems that NULL
keys are never used to build or scan a btree index (see the explain commands
in the example). However this is not the case when a null key is retrieved
in an outer loop of a join select and used in an index scan of an inner loop.
This bug causes at least three kinds of problems:
1) the backend crashes when it tries to compare a text string with a null.
2) it is not possible to find tuples with null keys in a join.
3) null is considered equal to 0 when the datum is passed by value, see
the last query.
Diffstat (limited to 'src/backend/tcop/postgres.c')
0 files changed, 0 insertions, 0 deletions