Hi guys,

I got a problem when I trying to drop a global temporary table in my database, I got following errors:

sql>drop table tmp.test;
42S02!DROP TABLE: no such table 'test'

I got the same error as above when I trying to execute a "select" query on that table, It's so weird, cause the table "test" was been there:

sql>\d
TABLE tmp.test

The even more weird things happened when I execute following command:

sql>create global temporary table tmp.test(id int);
operation successful (1.888ms)
sql>\d
TABLE tmp.test
sql>\d test
table tmp.test is not unique, corrupt catalog?
sql>\d
TABLE tmp.test
sql>drop table tmp.test
more>;
operation successful (1.470ms)
sql>\d
TABLE tmp.test

Please pay attention on this line "table tmp.test is not unique, corrupt catalog?".

Do anybody can help me out of here?

Thanks,

Tony