Bug #3383 Tables deleted when refreshing with tempory tables
Submitted: 4 Apr 2004 0:55 Modified: 5 Apr 2004 17:05
Reporter: Aaron Judd
Status: Can't repeat
Category:MySQLCC Severity:S2 (Serious)
Version:0.9.4.-beta OS:Linux (Linux (MDK 10))
Assigned to: Dean Ellis Target Version:

[4 Apr 2004 0:55] Aaron Judd 
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.
[5 Apr 2004 17:05] Dean Ellis 
I cannot repeat this.  What version of MySQL are you using?
[5 Apr 2004 17:25] Aaron Judd 
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.