Menu

#2491 (ok 2.11.2) DROP Button does not work on defective VIEWs

2.10.3
fixed
Interface (555)
1
2013-06-11
2007-07-31
S.T.
No

Have a look at the following:

1) Create a table
CREATE TABLE IF NOT EXISTS `test` (
`test1` varchar(1) collate latin1_german1_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

2) Create a view for the table
CREATE VIEW vtest AS SELECT test1 FROM test;

3) Rename table column
ALTER TABLE `test` CHANGE `test1` `test2` VARCHAR( 1 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL

4) Click the view vtest, obviously this can't work.

5) Now click the "DROP" Link on the very right of the top links.
The SQL executed is "DROP TABLE `vtest`" and not a DROP VIEW.

Configuration:
phpMyAdmin - 2.10.3
PHP Version 5.2.2
MySQL client version: 5.0.37
Used PHP extensions: mysqli
Server version: 5.0.37-max-log

Discussion

  • Marc Delisle

    Marc Delisle - 2007-09-27
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2007-09-27

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2007-09-27
    • priority: 5 --> 1
    • summary: DROP Button does not work on defective VIEWs --> (ok 2.11.2) DROP Button does not work on defective VIEWs
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-10-27
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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