• Andres Freund's avatar
    Check the relevant index element in ON CONFLICT unique index inference. · 159cff58
    Andres Freund authored
    ON CONFLICT unique index inference had a thinko that could affect cases
    where the user-supplied inference clause required that an attribute
    match a particular (user specified) collation and/or opclass.
    
    infer_collation_opclass_match() has to check for opclass and/or
    collation matches and that the attribute is in the list of attributes or
    expressions known to be in the definition of the index under
    consideration. The bug was that these two conditions weren't necessarily
    evaluated for the same index attribute.
    
    Author: Peter Geoghegan
    Discussion: CAM3SWZR4uug=WvmGk7UgsqHn2MkEzy9YU-+8jKGO4JPhesyeWg@mail.gmail.com
    Backpatch: 9.5, where ON CONFLICT was introduced
    159cff58
plancat.c 45.6 KB