randgen team mailing list archive

[Roel Van de Paar <792138@xxxxxxxxxxxxxxxxxx>]

It would be easy to change the regex to list all combinations of AA-ZZ
and AAA-ZZZ, but this would indeed not cover things like views
(v<something>/view<something>) which I believe are not included in MTR
testcases today either. As such, Bernt's idea may work better in the
long run.

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

Title:
  MTR testcase creation fails for double letter tables

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

Bug description:
  MTR testcases are created automatically when using RQG w/
  transformers. This fails when the table names have double (uppercase?)
  names. The table definitions and data inserts are simply missing.

  For instance, in an MTR testcase which has this query:

  SELECT MAX
  ( alias2.col_int )
   AS field1 , alias1.pk AS field2
  FROM LL AS alias1 JOIN PP AS alias2 ON alias1.col_varchar_10_latin1_key = alias2.col_varchar_10_latin1_key
  GROUP BY field2
  ORDER BY field1 ;

  It does not include the table, nor the data, for LL or PP.

  I another example, it was using a one letter table name and dual
  letter table name ('MM'). The single letter table name defintion (and
  data) was included (and renamed to "t1"), but the MM table defintion
  was not.

  So, it looks like whatever code is supposed to include table
  defintions and data, is missing to include table names/data for tables
  with a table name lenght of 2 (or possibly >=2).

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