Bug #18916 Deletes View
Submitted: 9 Apr 2006 9:15 Modified: 23 Oct 2006 9:11
Reporter: blair Inglis Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:mysql Ver 14.12 Distrib 5.0.18, for pc- OS:Linux (Debian Kernel 2.6.12)
Assigned to: CPU Architecture:Any

[9 Apr 2006 9:15] blair Inglis 
Description:
MySQL Administrator 1.1.9 (Windows 2000 Pro SP4)

When editing a view if you
1) Cancel out
2) Switch to another part of mysql administrator
3) Close the program
It deletes the view unrecoverable

How to repeat:
Create a view such as "select gallery.id as galleryid,images.filename, gallery_pics.picid, gallery.detail from gallery,gallery_users,gallery_pics,images where ((gallery_pics.galleryid=gallery.id) and (gallery_users.galleryid=gallery.id) and (images.id=gallery_pics.picid)) order by detail asc;"

then edit it, then press cancel

Suggested fix:
make the program not delete the view when it query's it
[10 Apr 2006 6:50] MySQL Verification Team 
Hi,

I followed your instructions but my views don't get deleted.  Can you confirm by enabling the general query log to see exactly what SQL statements are being sent from MySQL Administrator to the server?
[23 Oct 2006 9:11] Sveta Smirnova 
Duplicate of Bug #23523