MTR testcase creation fails for double letter tables
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Random Query Generator |
New
|
High
|
Unassigned |
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.
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).
Changed in randgen: | |
importance: | Undecided → High |
This is due to the regexp on line 58 in lib/GenTest/ Simplifier/ Tables. pm . It should be easy for bernt to extend it to cover double-letter tables. Note however that the regexp must make sure that the 2 letters are identical, otherwise it will match other keywords such as "ON"