💾 Archived View for bbs.geminispace.org › s › programming › 5305 captured on 2024-05-10 at 11:26:08. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2024-03-21)
-=-=-=-=-=-=-
It's the first time I see something like this: a sqlite query that works from the shell, but not from my Go code (https://github.com/dimkr/tootik/pull/18/files#r1322548148). I switched from mattn/go-sqlite3 to modernc.org/sqlite (different sqlite bindings) and now the query works. If I update mattn/go-sqlite3 to the same sqlite version (to rule out the possibility of a bug fixed in sqlite 3.43.1), the problem stays. More ideas how to isolate the problem?
2023-09-14 · 8 months ago · 👍 alexlehm, norayr, DocEdelgas
🔭 DocEdelgas · 2023-09-19 at 19:21:
I haven't looked very far yet, but it seems to me that both sqlite queries are not completely identical. Just to make sure, did you try the modified query for the mattn/go-sqlite3 implementation?
😈 dimkr [OP] · 2023-09-20 at 12:14:
@DocEdelgas Yes, they're a bit different. Both queries return the expected results when I use modernc.org/sqlite or the sqlite shell, but unlike the original, the modified query returns zero rows only when I run it with mattn/go-sqlite3.