y, 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&#x
UTOCOMMIT=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
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
http://we
