Can't get START TRANSACTION/COMMIT to work

[Patrick Chun]

I am using MySQL 4.1.12 with the NDB engine for clustering. I tried using the START TRANSACTION / COMMIT to insert into my database:

START TRANSACTION;

various INSERTs into tables...

COMMIT;

In order to simulate an application or OS crash, I intentionally made sure that one of the INSERTs will fail. I was hoping to see that none of the modifications within the above START TRANSACTION / COMMIT are done to my tables, however, I found that some of the tables ARE changed!

I have used the same kind of statements with Postgres and they had worked for 5 years.

In my.cnf, I have nothing much in it:
[mysqld]
skip-innodb
skip-bdb
skip-isam

skip-grant-tables
skip-name-resolve
skip-host-cache

sql-mode=ANSI

ndbcluster
default-table-type=NDBCLUSTER
ndb-connectstring=localhost
---------------------end my.cnf file --------------

Any suggestions would be greatly appreciated.

Thanks,
Patrick