random temporary table name not random enough

Bug #617526 reported by Andrew Hutchings
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Invalid
Low
Andrew Hutchings
Dexter
Invalid
Low
Andrew Hutchings

Bug Description

Using the problem in bug #617517:

drizzle> create table t1 (a int primary key, b varchar(255));
Query OK, 0 rows affected (0.08 sec)

drizzle> alter table t1 engine=blackhole;
Query OK, 0 rows affected (0.14 sec)
Records: 0 Duplicates: 0 Warnings: 0

drizzle> create table t2 (a int primary key, b varchar(255));
Query OK, 0 rows affected (0.07 sec)

drizzle> alter table t2 engine=blackhole;
ERROR 1050 (42S01): Table 'temporary.#sql-a36_14' already exists

Changed in drizzle:
assignee: nobody → Andrew Hutchings (thelinuxjedi)
Changed in drizzle:
importance: Undecided → Low
Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

2 simultaneous alter table commands in one thread should not be possible. This will only occur due to another bug or stale files. Marking invalid.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.