# 3151 TemporaryTables Information Schema Table Not Reflecting CREATE and DROP Statements Accurately

---

I just ran into some strange behavior related to temporary tables.

The behavior can be reproduced in the Manager:

1. create an in memory database --CREATE DATABASE "Mem" IN MEMORY
2. create a temporary table in the memory database

CREATE temporary TABLE "Temp" (....)

3. check if the newly created table exists

select * from mem.information.temporarytables
where name='Temp'

the result set lists the new table

4. drop the temporary table

drop TABLE "Temp"

5. check if the table exists

select * from mem.information.temporarytables where name='Temp'

the table is gone but the result set still lists the dropped table

6. restart the session

7. check the existence of "Temp"

select * from mem.information.temporarytables where name='Temp'

the result set is as expected null

8. create the temporary table as before

CREATE temporary TABLE "Temp" (....)

9. check its existence again

select * from mem.information.temporarytables where name='Temp'

the table is there, but the result set remains null.

note: every execution is preceded by an "unprepare"