Bug #36678 StorageEngine not getting replaced as defined in .opt file during test execution

• Submitted: 12 May 2008 22:26
• Modified: 11 Nov 2008 11:47
• Reporter: Hema Sridharan
• Status: Won't fix
• Category: Tests: Engine
• Severity: S3 (Non-critical)
• Version: mysql-6.0-backup
• OS: Linux
• Assigned to: Anurag Shekhar
• CPU Architecture: Any

[12 May 2008 22:26] Hema Sridharan

Description:
The storage engine that is defined in the .opt file is not used as default in the MTR test execution and instead gets replaced by Myisam storage engine.

How to repeat:
1)I create test file backup_objectsf_innodb.test which creates tests to ensure that object stored function is backed up and  restored properly.
2)I create an option file backup_objectsf_innodb.opt and define innodb storage engine in the .opt file like  --default-storage-engine=innodb.
3)When I run the test ./mtr backup_objectsf_innodb.test 
my test gets executed for myisam as my default storage engine though I define innodb as my storage engine in option file.

[14 May 2008 4:44] Hema Sridharan

backup_objectsf_innodb.test

Attachment: backup_objectsf_innodb.test.txt (text/plain), 7.30 KiB.

[14 May 2008 4:45] Hema Sridharan

Verified as described.

[14 May 2008 4:45] Hema Sridharan

backup_objectsf_innodb.opt

Attachment: backup_objectsf_innodb.opt.txt (text/plain), 31 bytes.

[17 Jun 2008 11:31] Anurag Shekhar

>> 2)I create an option file backup_objectsf_innodb.opt and define innodb storage engine in
>>the .opt file like  --default-storage-engine=innodb.

the option file name should be t/backup_objectsf_innodb-master.opt (http://dev.mysql.com/doc/mysqltest/en/tutorial-server-options.html)

I am assuming the wrong file name in the description is a typo and in actual run the file name was backup_objectsf_innodb-master.opt.

[11 Nov 2008 11:47] Anurag Shekhar

option file should be backup_objectsf_innodb-master.opt 
and not backup_objectsf_innodb.opt