Bug #59890 Change funcs_1 suite tests to make them engine independent
Submitted: 2 Feb 2011 10:58 Modified: 29 Jun 2011 13:32
Reporter: Vinay Fisrekar Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Tests Severity:S3 (Non-critical)
Version:All OS:Any
Assigned to: Vinay Fisrekar CPU Architecture:Any
Tags: funcs_1

[2 Feb 2011 10:58] Vinay Fisrekar 
Description:
As a part of "InnoDB Coverage" task , we want to change  9 tests files to make them engine independent.
Currently, these tests explicitly set engine type in test file. 

We are making changes such that result file remain will be same across engines. To achieve this we are using 
1) "--let $engine_type = `select @@storage_engine;`" instead of call like "let $engine_type       = MEMORY;" in test files.

With this change, engine type will depend upon default engine value. So when we pass --mysqld=--innodb or --mysqld=--myisam to MTR , it will run with respective engines.

2) --replace_result $engine_type <engine_type> , before create table so that do not get any specific engine type in result file.

How to repeat:
perl mysql-test-run.pl  --suite=suite/funcs_1 --force --suite-timeout=500 --max-test-fail=0 --retry-failure=0 --mysqld=--default-storage-engine=innodb --mysqld=--innodb is_basics_mixed is_column_privileges is_columns is_engines is_events is_table_constraints is_table_privileges is_user_privileges is_schema_privileges

perl mysql-test-run.pl  --suite=suite/funcs_1 --force --suite-timeout=500 --max-test-fail=0 --retry-failure=0 --mysqld=--default-storage-engine=myisam  is_basics_mixed is_column_privileges is_columns is_engines is_events is_table_constraints is_table_privileges is_user_privileges is_schema_privileges
[2 Feb 2011 11:01] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/130202

3572 Vinay Fisrekar	2011-02-02
      Bug#59890 : Change funcs_1 suite tests to make them engine independent
      Modified tests to make them engine independent and increase InnoDB coverage
[29 Jun 2011 13:32] Jon Stephens 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php