Bug #19860 Possible clearing of the wrong column with prepared statements
Submitted: 16 May 2006 18:26 Modified: 16 May 2006 21:16
Reporter: Peter Zaitsev (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / J Severity:S2 (Serious)
Version:3.1.12 (Connector/J) OS:Any (all)
Assigned to: CPU Architecture:Any

[16 May 2006 18:26] Peter Zaitsev 
Description:
Binding null value to String variable  causes additional char(1) column to also be set to null.

This happens only if prepared statements are used.

How to repeat:
Please see repeatable test case attached to issue 9644
[16 May 2006 21:16] Mark Matthews 
More than likely a dupe of BUG#19282 (already fixed in the source tree for some time). Please try testing with a nightly snapshot of 3.1 from http://downloads.mysql.com/snapshots.php#connector-j
[18 May 2006 19:44] Tonci Grgin 
Mark, you were right. Running with nightly snapshot of 3.1 from
http://downloads.mysql.com/snapshots.php#connector-j produces correct result (true then false). Running with std mysql-connector-java-3.1.12 produces wrong result (true then true).