I has problem with MySql transaction.

[jzany]

Mysql 4.0.15

set autocommit=0;
begin;
insert into ta values('1','2003-12-29','2');
commit;
rollback;

I have got an error.

Error 1196 : Warning: Some non-transactional changed tables couldn't be rolled back

[LordShryku]

You commit....then rollback. Makes no sense...

[jzany]

set autocommit=0;
begin;
insert into ta values('1','2003-12-29','2');
rollback;

I have got same error.