Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

nodeIndexscan.c

  • Marc G. Fournier's avatar
    69c7f25b
    Fixes: · 69c7f25b
    Marc G. Fournier authored
    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.
    
    Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
    69c7f25b
    History
    Fixes:
    Marc G. Fournier authored
    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.
    
    Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>