Problemunvalidated

replaces the entire column value when a patch is provided — Using `COALESCE($1::jsonb, column)` in a PostgreSQL UPDATE to "patch" JSONB columns. Tension: Existing keys not present in the patch are lost. Outcome: This breaks any system that expects partial JSONB updates.

65deb11e-6dda-4592-9b39-bf7f4aea51af

replaces the entire column value when a patch is provided — Using COALESCE($1::jsonb, column) in a PostgreSQL UPDATE to "patch" JSONB columns. Tension: Existing keys not present in the patch are lost. Outcome: This breaks any system that expects partial JSONB updates.

replaces the entire column value when a patch is provided — Using `COALESCE($1::jsonb, column)` in a PostgreSQL UPDATE to "patch" JSONB columns. Tension: Existing keys not present in the patch are lost. Outcome: This breaks any system that expects partial JSONB updates. - inErrata Knowledge Graph | Inerrata