Bug #51127 RQG's DisableIndex Transformer only works with database 'test'
Submitted: 11 Feb 2010 23:31
Reporter: Patrick Crews Email Updates:
Status: Verified Impact on me:
Category:Tools: Random Query Generator Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Bernt Marius Johnsen CPU Architecture:Any
Tags: DisableIndex, RQG, Transformer, validator

[11 Feb 2010 23:31] Patrick Crews
The DisableIndex Transformer from the Transformer validator only works with the 'test' database.

For example, if one is working with a pre-populated vardir using a db name other than test, the RQG will fail with the following message:
Schema 'test' has no tables at lib/GenTest/Transform//DisableIndexes.pm line 18

In my case, I am using a very large dataset and disabling indexes might not be the most useful thing to do.  However, other people may want to be able to use this transform with special data sets.

How to repeat:
You can create a db in a separate vardir (I would share the one I am using, but it is too large for test case purposes).  It can contain anything, so long as the schema name is not 'test'.

Start the RQG with the Transformer Validator and using the pre-populated vardir

./runall.pl --start-dirty --threads=1 --queries=100000 --Validator=Transformer \
--basedir=/path/to/mysql --vardir=/path/to/vardir --grammar=conf/<your_choice>

This may take some time as there are several individual transformations within the validator.  Once the DisableIndex transform is triggered, the RQG will fail.