Bug #38449 If I try to create a temp table wich already exists, no error is reported
Submitted: 30 Jul 2008 8:57 Modified: 30 Jul 2008 19:42
Reporter: Federico Razzoli (OCA) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.12 OS:Any
Assigned to: CPU Architecture:Any

[30 Jul 2008 8:57] Federico Razzoli 
Description:
If I create a temporary table and then I try to re-create it (WITHOUT the "if not exists" clause") no error is reported.

How to repeat:
1. CREATE TEMPORARY TABLE newtable2 LIKE mytable

2. Perform another query, if you want

3. Again: CREATE TEMPORARY TABLE newtable2 LIKE mytable

Query executed in 0:00.0274
[30 Jul 2008 15:20] Valeriy Kravchuk 
If you do that in Resultset tab, this is a know problem. MySQL Query Browser uses new separate connection for each and every SQL statement in this case. Hence, second temporary table is created in another connection and does not conflict with previous one (that is gone already).
[30 Jul 2008 19:42] Federico Razzoli 
Yes, I do it in resultset tab.
[13 Mar 2014 13:36] Omer Barnir 
This bug is not scheduled to be fixed at this time.