Bug #5552 Drop View fails
Submitted: 13 Sep 2004 22:25 Modified: 29 Oct 2004 23:25
Reporter: Alistair Maclean Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.0.7 Beta OS:Windows (Windows 2000 Pro)
Assigned to: Michael G. Zinner CPU Architecture:Any

[13 Sep 2004 22:25] Alistair Maclean
Description:
Using MySQL 5.0.1 snapshot as DB.

Create a View in the Query Browser 
Check it exists
Right click on name of 'table' in Schemata
Select Drop
Get error. 
View still present.

How to repeat:
Create a View 
From some existing table use
    CREATE VIEW testview AS SELECT * FROM existingtable

See it exists
     SELECT * FROM textview

Drop it through the GUI 
right click on the Schemata
Get a menu ( Edit Table, Create New Table, Drop Table, Refresh Schemata List)
Select Drop Table
Get Dialog saying "am I sure" click OK
Get dialog error "Error While Executing Query"
"DROP TABLE 'databasename'.'testview'"
"MySQL Error Nr. 1051"
"Unknown table 'testview'"

OK button pressed,

View still exists

Suggested fix:
GUI needs some sense of what has been right clicked on. The syntax for dropping Views is slight different to tables (DROP VIEW, not DROP TABLE) so needs to build query appropriate to underlying type.
[14 Sep 2004 16:27] Michael G. Zinner
At the moment, QB and MA only support the features from MySQL 4.1. We are working to integrate the new 5.0.1 features as soon as possible. But since it is likely that some of these features are going to change it is a litte bit tricky. Still expect the missing 5.0.1 features in on of the next releases.
[29 Oct 2004 23:25] Michael G. Zinner
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html