SQLite Forum

SQLite isolation clarification needed
Login
Hi, I'm trying to better understand SQLite isolation guarantees. I'm reading https://sqlite.org/isolation.html and my understanding that transactions from the same connection should see each other updates, even uncommitted ones.

I've made a small Go program trying to exhibit this behaviour — I'm expecting that TX 2 will see uncommitted update from TX 1, but it does not:
https://gist.github.com/andreyst/30322c7df8af6f4969445ab85f7dcc74

Can you help me understand what am I missing?