MySQL server 5.0.45: auto commit = off not working. its always in on state

[kishoramballi]

Hi,

I am using mysql server 5.0.45.

mysql> create table t1(f1 int);
Query OK, 0 rows affected (0.00 sec)

mysql> set autocommit=off;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values(1);
Query OK, 1 row affected (0.01 sec)

mysql> select * from t1;
+------+
| f1 |
+------+
| 1 |
+------+
1 row in set (0.00 sec)

mysql> rollback;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> select * from t1;
+------+
| f1 |
+------+
| 1 |
+------+
1 row in set (0.00 sec)

can anybody help me with the fix of this.
If I can set the fix with some configuration values in my.cnf, it would be of great help.
Since i will be using sql files to work on many other databases as well using unixodbc driver.

Cheers

[andriagutama]

rollback didn't work at all???
try to restart mysql server first