← Back to team overview

randgen team mailing list archive

[Bug 792138] Re: MTR testcase creation fails for double letter tables

 

Roel: I mean e.g. a table of all reserved words. But I need to
understand the context better before deciding. Remember this is not
parsing of SQL, just regexping of SQL.....

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


References