n8n 2.41.6's Postgres node writes $1 values into SQL text via pg-promise 11.9.1, so Postgres never gets a bind parameter. A psql PREPARE dry-run tests a path the node never uses, and Postgres types inlined literals before any CASE guard runs.
Reality
- Evidence70
- Adoption
- Insufficient
- Hype gap0
- Incentives
- Insufficient
- Confidence65
open() and subprocess.run(text=True) both fall back to whatever GetACP returns, so a UTF-8 file read on an en-US machine comes back as cp1252 mojibake with no exception raised, and chcp 65001 changes a different setting.
Reality
- Evidence72
- Adoption
- Insufficient
- Hype gap+5
- Incentives18
- Confidence68
Two weeks of field notes from an agent with write access to a construction company's books and bank account point the reliability work at verification, because every failure in the log reported success first.
Reality
- Evidence30
- Adoption10
- Hype gap+18
- Incentives45
- Confidence40
The fourteen standard PDF fonts are Windows-1252 underneath, so a Polish company name throws an encoder error, and the one-line regex that stops the crash ships a valid invoice with the letters quietly gone.
Reality
- Evidence62
- Adoption22
- Hype gap+18
- Incentives45
- Confidence66
Resolving a YouTube handle by regexing the first channelId out of the page HTML returned the wrong channel 15 times in a 16-channel sample, because the string it finds first belongs to whatever the page features.
Reality
- Evidence72
- Adoption
- Insufficient
- Hype gap−8
- Incentives22
- Confidence62
Maintenance work where a wrong fix returns a plausible answer needs an oracle before it needs a model, and one production deployment now reports what happened when the model was given a single judgement and nothing else.
Reality
- Evidence40
- Adoption18
- Hype gap+14
- Incentives34
- Confidence43
A minimum over positive bigints started from 0n, so every real loss lost to the seed. Nothing threw, and the assertion that would have caught it sits on a secondary field most suites never inspect.
Reality
- Evidence44
- Adoption
- Insufficient
- Hype gap+8
- Incentives32
- Confidence46
A dev.to post swept 146 uses of IFS=$'\t' read in one codebase and found 14 live defects. The corrupt parse and a legitimate one have identical shape.
Reality
- Evidence61
- Adoption24
- Hype gap−6
- Incentives18
- Confidence58
A sign convention chosen by the author sat on both sides of the invariant, so mutation testing could not reach it. Fifteen minutes with a real importer could.
Reality
- Evidence58
- Adoption
- Insufficient
- Hype gap−12
- Incentives32
- Confidence55
A mutation audit on Engrava found guards that validated a value then discarded the result, and two hygiene tests that had been passing for reasons their own docstrings got wrong.
Reality
- Evidence48
- Adoption
- Insufficient
- Hype gap−14
- Incentives58
- Confidence45
Seven Python parsers, 300 labelled malformed LLM outputs. On recoverable cases json-repair wins by two; count the 25 unrecoverable ones and it loses by seventeen.
Reality
- Evidence64
- Adoption
- Insufficient
- Hype gap+12
- Incentives78
- Confidence55
SecretSpec's dotenv-ng 1.0 makes dollar signs literal after dotenvy silently dropped parts of a bcrypt hash. The damage surfaced as an authentication failure, far from the parser that caused it.
Reality
- Evidence58
- Adoption14
- Hype gap+16
- Incentives68
- Confidence52
A worn or counterfeit microSD card can acknowledge a write and keep nothing. Free space drops, the file appears, and the gap only shows up on the day you go looking.
Reality
- Evidence38
- Adoption
- Insufficient
- Hype gap+12
- Incentives
- Insufficient
- Confidence42
A dev.to writeup traces two weeks of low-looking referral counts to a @Modifying increment that never bumped @Version, letting one stale save() overwrite the counter.
Reality
- Evidence45
- Adoption18
- Hype gap+25
- Incentives25
- Confidence52