Review 10.4 Merged

65599[BUGFIX] PlainDataResolver misses DeletedRestriction

Christian Kuhn CR +2 V +2 Hard +212 −52 updated 09/07/20, 14:40

Commit message

The PlainDataResolver is used to find overlay id's of live
id's in workspace context. One usage is the ReferenceIndex.

In scenarios 'modify content, discard content, modify again'
with relations, the PlainDataResolver sometimes fetches rows
that have been set to deleted (discarded) already together
with the rows that should be fetched. Depending on the order
of the result rows - which depends on the DBMS - wrong overlay
rows are calculated sometimes.

The patch adds a database DeletedRestriction at 3 of 4 places
in the PlainDataResolver to only fetch correct rows. The last
place triggers another side-effect that needs to be tackled
with another patch and is commented as @todo for now.

The tests add missing sys_refindex rows to the 6 tests that
failed on postgres before. Additionally, for some other
IRRE/CSV workspace tests, the sys_refindex changes slightly
and is more correct now.

Review

  • Code review CR +2 Done
    • Anja Leichsenring +2
    • Oli Bartsch +1
  • Verified V +2 Done
    • Anja Leichsenring +2
    • Oli Bartsch +1
    • TYPO3com +1 CI

Issues 1

Files 19

Review log 45

  1. Christian Kuhn commented on patch set 1 09/07/20, 13:54

    Cherry Picked from branch master.
  2. TYPO3com voted on patch set 1 V +1 09/07/20, 14:17 Completed build in 21m 29s on Mon, 7 Sep, 02:17 PM Test Summary: 74190 passed Find logs and detail information at https://bamboo.typo3.com/browse/CORE-GTC104-354

  3. Oli Bartsch voted on patch set 1 V +1 CR +1 09/07/20, 14:32

  4. Anja Leichsenring voted on patch set 1 V +2 CR +2 09/07/20, 14:40

  5. Anja Leichsenring merged patch set 2 09/07/20, 14:40