Auto-naming fails when trying to create a number of tables with the same row count
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Random Query Generator |
New
|
Undecided
|
Unassigned |
Bug Description
When trying to create a number of tables in a gendata file (with the same number of rows), earlier tables will be overwritten by later versions of the table due to the randgen naming conventions.
Not sure if this is something that *definitely* needs fixing, but it should be documented (ie we need different row counts or specified names). However, this limitation can be problematic if one is trying to create a large test bed (without a lot of tedium)
This gendata input:
$tables = {
rows => [10, 10, 50, 50, 75, 75, 100, 100 , 100 , 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100 ],
partitions => [ undef ]
};
Results in this:
# 2011-10-31T10:12:43 # Creating MySQL table: .table10_
# 2011-10-31T10:12:43 # Creating MySQL table: .table10_
# 2011-10-31T10:12:43 # Creating MySQL table: .table50_
# 2011-10-31T10:12:43 # Creating MySQL table: .table50_
# 2011-10-31T10:12:43 # Creating MySQL table: .table75_
# 2011-10-31T10:12:43 # Creating MySQL table: .table75_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_
One area where this "functionality" may be handy is where table creations fail on the first attempt due to some invalid syntax.
Maybe we could do something like
IF LAST CREATE TABLE FAILED <do not modify name> ELSE <add suffix _1/_2/...>