Auto-naming fails when trying to create a number of tables with the same row count

Bug #884235 reported by Patrick Crews
6
This bug affects 1 person
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_int_autoinc; engine: ; rows: 10 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table10_int_autoinc; engine: ; rows: 10 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table50_int_autoinc; engine: ; rows: 50 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table50_int_autoinc; engine: ; rows: 50 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table75_int_autoinc; engine: ; rows: 75 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table75_int_autoinc; engine: ; rows: 75 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .
# 2011-10-31T10:12:43 # Creating MySQL table: .table100_int_autoinc; engine: ; rows: 100 .

Revision history for this message
Roel Van de Paar (roel11) wrote :

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/...>

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.