Bug #19282 Empty string
Submitted: 22 Apr 2006 20:21 Modified: 26 Jul 2006 18:17
Reporter: M Wensink Email Updates:
Status: Closed Impact on me:
Category:Connector / J Severity:S1 (Critical)
Version:Latest snapshot OS:Windows (w2k)
Assigned to: CPU Architecture:Any

[22 Apr 2006 20:21] M Wensink
Query results in empty string in some cases.

How to repeat:
I can't isolate the problem from my application

Suggested fix:
Removing line 797

this.wasNullFlag = true;

from the file ResultSet.java solves my problem.

This line seems erroneous to me. Is that correct?
[22 Apr 2006 20:37] Mark Matthews
Please state _exactly_ what snapshot you're using (basically the filename). If you could show some logic of your code, that would help as well, as we haven't experienced this issue ourselves.
[22 Apr 2006 23:16] Marten Wensink
The snapshot is mysql-connector-java-3.1-nightly-20060422.zip

It's difficult to give some logic of the code because it's part of a large web application. The SQL query concerning is constructed dynamically and looks like this:

SELECT * FROM user_tbl WHERE User_logName = 'name' AND User_instID = 0

User_logName has type varchar(16).

In the result set the password has a NULL-value.

I hope this will help you any further.


[24 Apr 2006 17:09] Marten Wensink
Dear Mark,

I indeed think that line 979 in file ResultSet.java is incorrect. I compared this file with the corresponding file in version 5 of the implementation of JConnector. In version 5 line 979 (this.wasNullFlag = true;) is not present, but instead contains the line 807 this.wasNullFlag = false;

I hope this will help.

Regards Marten
[24 Apr 2006 23:41] Mark Matthews
Can you give some context, line 979 in ResultSet.java in my sources (nor in my download of mysql-connector-java-3.1-nightly-20060422.zip) doesn't line up with an access to wasNullFlag.

What method specifically do you see the point where this needs to be changed?
[25 Apr 2006 10:06] Marten Wensink
I'm sorry, I made a type error in my last comment.
I mean line 797 in ResultSet.java
[26 Apr 2006 1:00] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

[26 Apr 2006 1:03] Mark Matthews
Fix will be in snapshots available in the April 27th build (just missed today's build).

Thanks for the bug report!