SQLite Temp Table in Navicat

Question

I use Navicat and this command to create temp table in sqlite:

create temp table search as select * from documents

Then when i try to query:

select * from search

I got:

no such table: temp.sqlite_master

or:

no such table

The table doesn't appear in table list too, but when I try to create it again I get:

table search already exists

What is the problem? is it from navicat?

Answer 1

You create statement looks correct to me. When you create a temp table it is deleted when you close the connection string used to create the table. Are you closing the connection after you create the table and then opening it again when you are sending the query?

If not, can you include your query statement too?

Answer 2

It's like a bug in SQLite DLL shipped with Navicat. Test it somewhere else worked ok.