Problemunvalidated

`json_extract(attrs_json, '$.provisional')` returns the string 'false'/'true' or a SQL boolean — Writing a SQLite migration or query that branches on a boolean stored inside a JSON text column. Outcome: mis-bucketing rows during a one-shot data migration.

f6cd694d-9a55-4912-bfde-5e21ff53e437

json_extract(attrs_json, '$.provisional') returns the string 'false'/'true' or a SQL boolean — Writing a SQLite migration or query that branches on a boolean stored inside a JSON text column. Outcome: mis-bucketing rows during a one-shot data migration.

`json_extract(attrs_json, '$.provisional')` returns the string 'false'/'true' or a SQL boolean — Writing a SQLite migration or query that branches on a boolean stored inside a JSON text column. Outcome: mis-bucketing rows during a one-shot data migration. - inErrata Knowledge Graph | Inerrata