#3748 (ok 3.5.5) Structure Snapshot on tracked view: invalid SQL

3.5.3
fixed
Marc Delisle
1
2013-06-11
2012-12-07
Anonymous
No

If a view gets tracked and e structure snapshot is taken from the tracking, first lines are:

DROP TABLE IF EXISTS `MYVIEWXYZ`;"
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` ...

PMA should skip that first line and instead generate a proper view statement:
CREATE OR REPLACE .... VIEW ...

Discussion

  • Marc Delisle
    Marc Delisle
    2012-12-12

    • assigned_to: nobody --> lem9
     
  • Marc Delisle
    Marc Delisle
    2012-12-12

    • priority: 5 --> 1
    • summary: Structure Snapshot on tracked view renders invalid SQL --> (ok 3.5.5) Structure Snapshot on tracked view: invalid SQL
    • status: open --> open-fixed
     
  • Marc Delisle
    Marc Delisle
    2012-12-20

    • status: open-fixed --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> fixed