This little simple script doesn't work!
CREATE TEMPORARY TABLE TempTable ( ID int, Name char(100) ) TYPE=HEAP;
INSERT INTO TempTable VALUES( 1, "Foo bar" );
SELECT * FROM TempTable;
It returnes NOTHING!!! The temporary table is created - if I try to run the first query again an error message states that the table exists... but I can't get any rows in return when I run SELECT * FROM TempTable;
Why????
CREATE TEMPORARY TABLE TempTable ( ID int, Name char(100) ) TYPE=HEAP;
INSERT INTO TempTable VALUES( 1, "Foo bar" );
SELECT * FROM TempTable;
It returnes NOTHING!!! The temporary table is created - if I try to run the first query again an error message states that the table exists... but I can't get any rows in return when I run SELECT * FROM TempTable;
Why????