randgen team mailing list archive

["John H. Embretsen" <794858@xxxxxxxxxxxxxxxxxx>]

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.

** Bug watch added: MySQL Bug System #53538
   http://bugs.mysql.com/bug.php?id=53538

-- 
You received this bug notification because you are a member of Random
Query Generator Team, which is subscribed to Random Query Generator.
https://bugs.launchpad.net/bugs/794858

Title:
  MTR testcase creation fails for views

Status in SQL Generator for testing SQL servers (MySQL, JavaDB, PostgreSQL):
  New

Bug description:
  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?

To manage notifications about this bug go to:
https://bugs.launchpad.net/randgen/+bug/794858/+subscriptions