randgen team mailing list archive

[Roel Van de Paar <794858@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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?

** Affects: randgen
     Importance: Undecided
         Status: New

-- 
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