Bug #5195 Prepared statement does not return matching row
Submitted: 25 Aug 2004 0:55 Modified: 2 Sep 2004 16:07
Reporter: Dean Ellis Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Severity:S1 (Critical)
Version:4.1.4 OS:
Assigned to: Dean Ellis CPU Architecture:Any

[25 Aug 2004 0:55] Dean Ellis 
Description:
Prepared statement sometimes mangles packets, resulting in failure to find an existing row in the database.  Behavior was seen with both a Connector/J test case on Windows and a C API test on Linux.

How to repeat:
Test cases supplied previously.

Suggested fix:
n/a
[25 Aug 2004 1:39] Dean Ellis 
The problem currently seems to be related to the passing of a negative integer (first parameter in the test cases).  Changing the table data and parameter to use a positive integer gives correct results.

Attaching another test case which shows the problem with a negative parameter.
[2 Sep 2004 16:07] Dean Ellis 
Problem was isolated to Connector/J, and should be fixed as of the 02 Sep 2004 nightly build.  Fix will be included in the next Connector/J 3.1 release.