title: SQLite Temp Table in Navicat
body: <p>I use Navicat and this command to create temp table in sqlite:</p>
  
  <pre><code>create temp table search as select * from documents
  </code></pre>
  
  <p>Then when i try to query:</p>
  
  <pre><code>select * from search
  </code></pre>
  
  <p>I got:</p>
  
  <pre><code>no such table: temp.sqlite_master
  </code></pre>
  
  <p>or:</p>
  
  <pre><code>no such table
  </code></pre>
  
  <p>The table doesn't appear in table list too, but when I try to create it again I get:</p>
  
  <pre><code>table search already exists
  </code></pre>
  
  <p>What is the problem? is it from navicat?</p>