MTR testcase creation fails for views

[Roel Van de Paar]

Seen in an MTR testcase:

FROM vO_0 AS alias1

Result of MTR execution:

failed: 1146: Table 'test.vO_0' doesn't exist

In the original server data dir, the view is there:

mysql> show create view vO_0\G
*************************** 1. row ***************************
                View: vO_0
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vO_0` AS select `O`.`pk` AS `pk`,`O`.`col_int_key` AS `col_int_ke
y`,`O`.`col_varchar_1024_utf8_key` AS `col_varchar_1024_utf8_key`,`O`.`col_datetime` AS `col_datetime`,`O`.`col_datetime_key` AS `col_datetime_key`,`O`.`col_varchar_10_
latin1` AS `col_varchar_10_latin1`,`O`.`col_varchar_10_latin1_key` AS `col_varchar_10_latin1_key`,`O`.`col_varchar_1024_latin1_key` AS `col_varchar_1024_latin1_key`,`O`
.`col_date` AS `col_date`,`O`.`col_int` AS `col_int`,`O`.`col_varchar_10_utf8` AS `col_varchar_10_utf8`,`O`.`col_varchar_1024_latin1` AS `col_varchar_1024_latin1`,`O`.`
col_varchar_10_utf8_key` AS `col_varchar_10_utf8_key`,`O`.`col_date_key` AS `col_date_key`,`O`.`col_varchar_1024_utf8` AS `col_varchar_1024_utf8` from `O`
character_set_client: latin1
collation_connection: latin1_swedish_ci
1 row in set (0.01 sec)

Question: is this a duplicate of bug #792138 maybe? Or is it an issue related specifically to views?

[John H. Embretsen (johnemb)]

This is the same as http://bugs.mysql.com/bug.php?id=53538.
Philip suggested that a regexp fix and a Perl one-liner could fix part of the problem.

So far I have been using the workaround of using separate scripts in combination with mysqldump in order to get views' definitions, the definitions of their underlying tables, and the data therein.