Are SQLite joins associated with temporary tables in shared cache mode?

If two SQLite connections are open in the same database in shared cache mode, will the temporary table created in one connection be visible in the other?

+4
source share
1 answer

I think they should not be visible, but you can see for yourself: Challenge

SELECT * FROM SQLITE_TEMP_MASTER 

from several processes (one with and without a temporary table created) and compare the results.

+3
source

Source: https://habr.com/ru/post/1337101/


All Articles