Transactions dont work

[eluser]Unknown[/eluser]
It looks like this might be more of a problem with mysql.

running the following sql in phpmyadmin commits the query on the sql error. This is also likely the problem being shown in code igniter.

Code:

START TRANSACTION;
UPDATE TEST SET ID = 15;
create table fail;
ROLLBACK;