MySQL Bugs: #23007: Access violation as result of deleting a view referenced by other view

Bug #23007	Access violation as result of deleting a view referenced by other view
Submitted:	5 Oct 2006 12:26	Modified:	16 Oct 2006 14:37
Reporter:	Heinz Schweitzer (Gold Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.4RC	OS:	Windows (XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
Access violation as result of deleting a view referenced by other view

MySQL Administrator 1.2.4RC
MySQL-Server-Information
--------------------------------------------------------------------------------
Mit MySQL-Serverinstanz verbunden
  Benutzername:            root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Serverinformation
  MySQL-Version:           MySQL 5.0.24a-community-nt via TCP/IP
  Netzwerkname:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Clientinformation
  Version:                 MySQL Client Version 5.0.11
  Netzwerkname:            xxxxxxxxxxx
  IP:                      xxxxxxxxxxx
  Betriebssystem:          Windows XP
  Hardware:                Intel(R) Pentium(R) M processor 1600MHz, 512 MB RAM

How to repeat:

NOTE: Try this with a newly created schema because you have to drop it.

Open MySQL Administrator 1.2.4RC (German)
Create a new schema like 't1'
Select schema 't1'

In the right pane activate the 'Schema-Tabellen' tab
Just create a table 't1' with one field like in screenshot v1

Now activate the 'Views' tab
In there create two views as given below

CREATE OR REPLACE VIEW `t1`.`v1` AS SELECT * from t1
CREATE OR REPLACE VIEW `t1`.`v2` AS SELECT * from v1

See screen shot v2
NOTE: v2 must reference v1

Now deletet view 'v1' confirm deletion, and then say 'Aktualisieren'.
View tab will be blank now.

Activate the 'Schema-Tabellen' tab and you will see something like in 
screen shot v3. Doubleclick on v2 and you will get the Access Violation .

v1

Attachment: v1.jpg (image/jpeg, text), 91.18 KiB.

v2

Attachment: shot_2.jpg (image/jpeg, text), 70.42 KiB.

v3

Attachment: shot_3.jpg (image/jpeg, text), 126.97 KiB.

You can also delete the table t1
will yield the same result.

Thank you for the bug report. Verified on English version, too.

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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html