MySQL Bugs: #3383: Tables deleted when refreshing with tempory tables

Bug #3383	Tables deleted when refreshing with tempory tables
Submitted:	3 Apr 2004 22:55	Modified:	5 Apr 2004 15:05
Reporter:	Aaron Judd	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQLCC	Severity:	S2 (Serious)
Version:	0.9.4.-beta	OS:	Linux (Linux (MDK 10))
Assigned to:	Dean Ellis	CPU Architecture:	Any

Description:
MysqlCC deleting underlying tables when temporary tables are created with same name.

Note: This is a MDK mysqlcc-0.9.4-1mdk.i586.rpm. It's possible the bug is there.. I was not able to test on source install.

How to repeat:
1. Have table 'items'
2. In software accessing mysql: "CREATE TEMPORARY TABLE IF NOT EXISTS items
	SELECT * from items where site_id=14"
3. In software query items, proper results are shown (shows temp results copied table of items, not the REAL table of items)
4. In MySqlCC goto table listing, click refresh, ITEMS disappears.
5. real table ITEMS is now deleted, only way to restore to recreate.

I cannot repeat this.  What version of MySQL are you using?

Using MySQL 4.0.16.

Now I am not positive it's an issue with the CC. If I run the query to create the temp table from with CC, the behaviour is as expected. I retain the original table in the table listing and the results are based on the temp table. This behaviour is only now repeatable if I create the temp table in software then refresh. I am still able to access the real table, until I do the table refresh.