Re: Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.
- Date: Mon, 18 Jan 2016 15:55:28 -0500
- From: "shawn l.green" <shawn.l.green@xxxxxxxxxx>
- Subject: Re: Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.
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"
CREATE TABLE Test(
id int not null primary key auto_increment,
CREATE TRIGGER TEST_TRIGGER
BEFORE INSERT ON Test
FOR EACH ROW
SET NEW.name = CONCAT(NEW.name, '_X');
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.
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/
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql