MySql Strange Problem :)

[mmallad]

My Query gets successfully executed.
But I dont see inserted record.
When I insert records from mysql prompt than it shows that PRIMARY KEY which was set to AUTO_INCREMENT has been incremented. Thats means the query from Qt was success but the record does not show up.
I have checked everything. I have passed all values in correct order.

[qxoz]

Can you show query?
and some code.

[mmallad]

I have used transaction and did not committed it. When I did that it worked.
But the thing is why mysql incremented the ID field when transaction is not committed.
Is this Bug or something Can You Help qxoz :)

[qxoz]

I think it's ok, because it reserve the "id" for a writing data after committing. If not reserve, after committing there can be written two records with identical id.