randgen team mailing list archive

[Roel Van de Paar <884235@xxxxxxxxxxxxxxxxxx>]

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

-- 
You received this bug notification because you are a member of Random
Query Generator Team, which is subscribed to Random Query Generator.
https://bugs.launchpad.net/bugs/884235

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

Status in SQL Generator for testing SQL servers (MySQL, JavaDB, PostgreSQL):
  New

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 .

To manage notifications about this bug go to:
https://bugs.launchpad.net/randgen/+bug/884235/+subscriptions