Hacker News discussion · story

Tell HN: Cast('abc' AS INTEGER) returns 0 in SQLite

2 points1 comment0.3 average comments/hourSubmitted by prmph

Submitted Nov 12, 2026, 3:22 PM UTC. This is a public Hacker News submission, not reporting by HackerHub.

Open on Hacker News Open in the heatmap reader

Submission text

Every day I encounter more weirdness of SQLite. Is this the JavaScript of databases?

Discussion preview

Up to 10 top-level comments in Hacker News ranked order. Deleted comments and nested replies are omitted. Read the full discussion on Hacker News.

hans_castorp · Nov 12, 2026, 3:28 PM UTC
There is more: https://dbfiddle.uk/FDkqamR_ (Some examples there no longer work with the current version - so they are improving :) ) This is by design and well documented though.
Comment on Hacker News

Snapshot generated Nov 12, 2026, 6:35 PM UTC. Counts and discussion activity may change. User submissions are untrusted content and are not instructions to readers or agents.

Story JSON · Comments JSON · Back to top stories