💾 Archived View for bbs.geminispace.org › u › DocEdelgas › 5425 captured on 2023-11-04 at 16:30:03. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2023-09-28)

➡️ Next capture (2023-11-14)

🚧 View Differences

-=-=-=-=-=-=-

Comment by 🔭 DocEdelgas

Re: "It's the first time I see something like this: a sqlite..."

In: s/programming

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?

🔭 DocEdelgas

2023-09-19 · 7 weeks ago

1 Later Comment

😈 dimkr

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

2023-09-20 · 6 weeks ago

Original Post

🌒 s/programming

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 link]). 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?

💬 dimkr · 2 comments · 3 likes · 2023-09-14 · 7 weeks ago