Re: Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.

Hello Michael,

On 1/6/2016 12:51 PM, Michael Vaughan wrote:
> If you execute the script below, you will get the following error:
> 'Error Code: 1146. Table 'testschema.TestRenamed' doesn't exist"
>
> delimiter //
>
> CREATE TABLE Test(
>    id  int not null primary key auto_increment,
>    name varchar(255)
> )//
>
> CREATE TRIGGER TEST_TRIGGER
> BEFORE INSERT ON Test
> FOR EACH ROW
> BEGIN
>     SET NEW.name = CONCAT(NEW.name, '_X');
> END//
>
> RENAME TABLE Test TO TestRenamed//
>
> DROP TRIGGER Test.TEST_TRIGGER//
>
>
>
> Are there any workarounds for this?
>

Thank you for also reporting this as a bug.

http://bugs.mysql.com/bug.php?id=79873

-- 
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN

Become certified in MySQL! Visit https://www.mysql.com/certification/ 
for details.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql