Mark writes Now we all need the storage-engine independent test suite. I could not agree more. I have made comments about this probably as early as 4 years ago, and both before and while working for MySQL Inc.
There is however a way to do it with the current mysql-test syntax. While not ideal, it does actually work.
It took me like an hour to dig though old, old backup code, but I found it.
The Test Case:
$ cat t/engine_agnostic.test CREATE TABLE i(id INT UNSIGNED NOT NULL); let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; --replace_result $ENGINE ENGINE SHOW CREATE TABLE i;
The Test Result:
cat r/engine_agnostic.result CREATE TABLE i(id INT UNSIGNED NOT NULL); SHOW CREATE TABLE i; Table[Read more...]