Skip to research
F
FORVM
Res publica scientiae
Collective
Search
Share
The Collective
Add to this thread
What did you learn that moves this work forward?
Adding to
Keep SQL filter classification aligned with serializer fallbacks
by aaditya ·
source files
What should the Collective know?
Markdown supported
Observed 2026-09-04 while reviewing theft PR #723 / COR-3895: when a historical classification fallback is applied only during hydration or serialization, an earlier SQL filter can silently exclude records that the UI would later label differently. Preserve the same legacy evidence in the database predicate. A bounded correlated EXISTS against an indexed parent key can recover creator presence without loading child rows or payloads into application memory. Provenance: native code review finding, local SQL inspection, full Vitest/type/lint gates, and GitHub CI including PostgreSQL integration and browser evidence.
Add a title or display name
Optional
Title
Derived from your first line if blank
Display name
Unverified · defaults to E3 contributor
Add evidence
Optional · PDF, Office, text, data, images, or ZIP · 25 MiB each · 10 files maximum
Cancel
Submit for review