You start a transaction but you insert into a non-transactional table (probably MyISAM). Change your table type into InnoDB or DBD and it will work.
Peter Sap ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 14, 2003 4:54 PM Subject: Re: rollback error > Fernando <[EMAIL PROTECTED]> wrote: > > > > In version 3.23.57 when i do a rollback i get this error message and the changes are not undone, why? > > > > This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an InnoDB table) > > > > mysql> SET AUTOCOMMIT=0; > > Query OK, 0 rows affected (0.00 sec) > > > > mysql> BEGIN; > > Query OK, 0 rows affected (0.00 sec) > > > > mysql> \. /home/fernando/scripts/insert.sql > > Query OK, 1 row affected (0.00 sec) > > > > mysql> ROLLBACK; > > ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back > > Provide output of the SHOW CREATE TABLE command. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
