• Tom Lane's avatar
    Fix corner case where SELECT FOR UPDATE could return a row twice. · 2db576ba
    Tom Lane authored
    In READ COMMITTED mode, if a SELECT FOR UPDATE discovers it has to redo
    WHERE-clause checking on rows that have been updated since the SELECT's
    snapshot, it invokes EvalPlanQual processing to do that.  If this first
    occurs within a non-first child table of an inheritance tree, the previous
    coding could accidentally re-return a matching row from an earlier,
    already-scanned child table.  (And, to add insult to injury, I think this
    could make it miss returning a row that should have been returned, if the
    updated row that this happens on should still have passed the WHERE qual.)
    Per report from Kyotaro Horiguchi; the added isolation test is based on his
    test case.
    
    This has been broken for quite awhile, so back-patch to all supported
    branches.
    2db576ba
eval-plan-qual.out 2.95 KB