Michael Vaughan Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.
Jan 06, 2016; 12:51
Michael Vaughan
Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.
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?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jan 18
shawn l.green Re: Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.
Jan 18, 2016; 15:55
shawn l.green
Re: Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!