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

_int_gist.c

Blame
    • Tom Lane's avatar
      fdf2dbda
      Fix assorted corner-case bugs in contrib/intarray. · fdf2dbda
      Tom Lane authored
      The array containment operators now behave per mathematical expectation
      for empty arrays (ie, an empty array is contained in anything).
      Both these operators and the query_int operators now work as expected in
      GiST and GIN index searches, rather than having corner cases where the
      index searches gave different answers.
      
      Also, fix unexpected failures where the operators would claim that an array
      contained nulls, when in fact there was no longer any null present (similar
      to bug #5784).  The restriction to not have nulls is still there, as
      removing it would take a lot of added code complexity and probably slow
      things down significantly.
      
      Also, remove the arbitrary restriction to 1-D arrays; unlike the other
      restriction, this was buying us nothing performance-wise.
      
      Assorted cosmetic improvements and marginal performance improvements, too.
      fdf2dbda
      History
      Fix assorted corner-case bugs in contrib/intarray.
      Tom Lane authored
      The array containment operators now behave per mathematical expectation
      for empty arrays (ie, an empty array is contained in anything).
      Both these operators and the query_int operators now work as expected in
      GiST and GIN index searches, rather than having corner cases where the
      index searches gave different answers.
      
      Also, fix unexpected failures where the operators would claim that an array
      contained nulls, when in fact there was no longer any null present (similar
      to bug #5784).  The restriction to not have nulls is still there, as
      removing it would take a lot of added code complexity and probably slow
      things down significantly.
      
      Also, remove the arbitrary restriction to 1-D arrays; unlike the other
      restriction, this was buying us nothing performance-wise.
      
      Assorted cosmetic improvements and marginal performance improvements, too.