Rollback is not take effect on MySQL 5.0.18

[Truong Tan Son]

Dear Sir,

On RedHat Enterprise 4, and MySQL 5.0.18, I did :

mysql> set autocommit=0;

mysql> savepoint abc;

mysql> insert  ....something....

mysql> rollback to save point abc;

Query OK, 0 rows affected, 1 warning (0.00 sec)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

RollBack is NOT take effect. But on WindowsXP, it is GOOD.


What is wrong ?


Thanks you and best regards,
--