Re: [sqlite] Question about sqlite TEMP table

[D. Richard Hipp]

On Fri, 2005-07-22 at 19:44 -0300, Ming Qiang Lin wrote:
> It says that temp table is visible to the process it created, but how
> about in this same process,  I join a temp table with non-temp table?.
> Since I am having Exception says: "no such table" when I do the join.
> 

The text is wrong and has now been corrected.
See http://www.sqlite.org/cvstrac/chngview?cn=2559

TEMP tables in SQLite work like they do in every other
SQL database engine.
-- 
D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] Question about sqlite TEMP table

[Ming Qiang Lin]

Hi All,

Following is the sqlite CREATE TABLE definition:

If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and
"TABLE" then the table that is created is only visible to the process
that opened the database and is automatically deleted when the
database is closed.  Any indices created on a temporary table are also
temporary.  Temporary tables and indices are stored in a separate file
distinct from the main database file.

 If a  is specified, then the table is created in  the
named database. It is an error to specify both a  and
the TEMP keyword, unless the  is "temp". If no database
name is specified, and the TEMP keyword is not present, the table is
created in the main database.


It says that temp table is visible to the process it created, but how
about in this same process,  I join a temp table with non-temp table?.
Since I am having Exception says: "no such table" when I do the join.

Please help!

Thank you in advance.


Mica