Bug #19282 Empty string

Description:
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?

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.

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.

Regards

Marten

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

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?

I'm sorry, I made a type error in my last comment.
I mean line 797 in ResultSet.java

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:

  http://lists.mysql.com/commits/5535

Fix will be in snapshots available in the April 27th build (just missed today's build).

Thanks for the bug report!