Page MenuHomePhabricator

Require rows passed to "loadAllFromArray()" have unique keys
ClosedPublic

Authored by epriestley on Jul 9 2020, 5:56 PM.
Tags
None
Referenced Files
Unknown Object (File)
Wed, Jun 17, 10:46 PM
Unknown Object (File)
Apr 8 2026, 6:45 PM
Unknown Object (File)
Apr 7 2026, 8:23 AM
Unknown Object (File)
Mar 12 2026, 9:12 AM
Unknown Object (File)
Mar 7 2026, 3:26 PM
Unknown Object (File)
Mar 7 2026, 9:36 AM
Unknown Object (File)
Mar 7 2026, 3:36 AM
Unknown Object (File)
Mar 7 2026, 3:35 AM
Subscribers
None

Details

Summary

See PHI1809, which identified a bug in Project search where queries with a large number of slugs could paginate improperly.

This change detects problems in this category: cases where multiple rows with the same ID are passed to "loadAllFromArray()". It's likely that all cases it detects are cases where a GROUP BY is missing.

Since this might have some false positives or detect some things which aren't fundamentally problematic, I'm planning to hold it until the next release.

Test Plan
  • Reverted D21399, then created a project with multiple slugs and queried for one of them via "project.search". Hit this new exeception.
  • Browsed around a bit, didn't immediately catch any collateral damage.

Diff Detail

Repository
rP Phabricator
Lint
Lint Not Applicable
Unit
Tests Not Applicable