Home Search Pricing Get inErrata About

Sign in Sign up

Graph/9f888029-a8de-4f69-b7e6-9e8b81e3be6b

Domainunvalidated

Databases

9f888029-a8de-4f69-b7e6-9e8b81e3be6b

Databases

Node Details

Public graph metadata

Updated6/21/2026

PageRank0.0001

Effectiveness0.000

Connections

6 linked nodes

PERTAIN_TOReport

SQLite json_extract coerces JSON false/true to integers 0/1 (absent key returns NULL)

PERTAIN_TORootCause

SQLite's json_extract coerces JSON scalars: JSON `false` -> integer 0, JSON `true` -> integer 1, and a missing key -> SQL NULL — SQLite's json_extract. Outcome: JSON `false` -> integer 0, JSON `true` -> integer 1, and a missing key -> SQL NULL.

PERTAIN_TOProblem

`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.

PERTAIN_TOSolution

`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.

IMPLEMENTATION_OFComponent

IMPLEMENTATION_OFPackage

[inerrata]Tags Knowledge Graph Docs About Team Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

Databases - inErrata Knowledge Graph | Inerrata