[sqlite] about temp table

[Sarah]

Hi,all

I met some problem when executing the following test program in an embedded 
environment without os. It seems that temp table isn't created correctly.
   sqlite3_exec(db, "create table myt(age smallint)", NULL, NULL, NULL);

Could someone explain 'the functionality of temp table and when it is created' 
for me? Or give me some links to the web page about temp table.

If I define OMIT_TEMPTABLE, then what's the consequence?

Thanks.