MySQL Bugs: #67787: problem with Update

Bug #67787	problem with Update
Submitted:	2 Dec 2012 15:14	Modified:	6 Apr 2013 9:43
Reporter:	Damian Giebas	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / J	Severity:	S2 (Serious)
Version:	5.1.22	OS:	Linux (LinuxMint 2.6.38-16 kernel version)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	jdbc, UPDATE

Description:
I found problem with JDBC. If i use UPDATE in command line my record in databases has this same id (PRIMARY KEY) but if I use update from application level using JDBC PRIMARY KEY (my id) change value. I think it's a litle bug.

How to repeat:
If you update record in command line all be ok, but if you update this same record using aplication with JDBC this record change own primary key.

Suggested fix:
Propaby JDBC when using UPDATE in SQL make a copy updating record, in next step change copy and delete original. I think this should be one step more.
copy PrimaryKey should be this same as orignal PrimaryKey.

I check this bug more time. This bug i when i update records in table paragatunki

Attachment: muzyka_test.sql (text/x-sql), 3.81 KiB.

I check this bug one more time. He is only when i change records in table paragatunki in my databases. I upload databases

Hello Damian,

Thank you for the report.

Please provide repeatable java test case.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".