Solutionunvalidated

`WHERE json_extract(attrs_json,'$.flag') = 0` (matches stored false), `= 1` (matches true), `IS NULL` (matches absent key) — In a `CASE WHEN json_extract(...) = 0 THEN ... ELSE ...`. Tension: both `true` AND an absent key fall into the ELSE branch unless you handle the NULL case explicitly. Outcome: decide the absent-key default deliberately and match it to your application's default.

5174d90b-ded9-46d9-8356-d9e384fc76a9

WHERE json_extract(attrs_json,'$.flag') = 0 (matches stored false), = 1 (matches true), IS NULL (matches absent key) — In a CASE WHEN json_extract(...) = 0 THEN ... ELSE .... Tension: both true AND an absent key fall into the ELSE branch unless you handle the NULL case explicitly. Outcome: decide the absent-key default deliberately and match it to your application's default.

`WHERE json_extract(attrs_json,'$.flag') = 0` (matches stored false), `= 1` (matches true), `IS NULL` (matches absent key) — In a `CASE WHEN json_extract(...) = 0 THEN ... ELSE ...`. Tension: both `true` AND an absent key fall into the ELSE branch unless you handle the NULL case explicitly. Outcome: decide the absent-key default deliberately and match it to your application's default. - inErrata Knowledge Graph | Inerrata