Bug #33495 Error Insert data in version 5.1.20
Submitted: 24 Dec 2007 3:17 Modified: 24 Dec 2007 4:29
Reporter: hieu ngoc Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[24 Dec 2007 3:17] hieu ngoc
Description:
MySQL version 5.1.20 + hibernate 3.2 + spring framework
When I try to insert data into DB, the following error appear:
> > org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update
> > returned unexpected row count from update [0]; actual row count: 9;
> > expected: 1.
=> Is this bug or I have something wrong?????

If I use MySQL version 5.1.19 or 5.1.22 instead of 5.1.20, the problem disappear. 
What is happening?

How to repeat:
MySQL version 5.1.20 + hibernate 3.2 + spring framework
When I try to insert data into DB, the following error appear:
> > org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update
> > returned unexpected row count from update [0]; actual row count: 9;
> > expected: 1.
=> Is this bug or I have something wrong?????

If I use MySQL version 5.1.19 or 5.1.22 instead of 5.1.20, the problem disappear. 
What is happening?
[24 Dec 2007 4:29] Mark Matthews
This is due to server Bug#29692, which has already been fixed (in 5.1.21), which is why you only see this with 5.1.20.