randgen team mailing list archive

[Patrick Crews <884235@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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 .

** Affects: randgen
     Importance: Undecided
         Status: New

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