[
https://issues.apache.org/jira/browse/DERBY-6037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Unai Vivi updated DERBY-6037:
-----------------------------
Description:
ResultSet.wasNull() returns false after a ResultSet.getString("COLUMNNAME") on
a null VARCHAR field.
E.g.
<pre>
ResultSet rs = null;
//[...]
rs = s.executeQuery("select EXAMPLE_PK,BLAHBLAH,COLUMN from MYTABLE
order by EXAMPLE_PK desc");
while (rs.next())
{
//[...]
String myStr = rs.getString("COLUMN");//all rows have SQL null
for field COLUMN
if (rs.wasNull())
{//never gets here
//[...]
}
//[...]
</pre>
was:
ResultSet.wasNull() returns false after a ResultSet.getString("COLUMNNAME") on
a null VARCHAR field.
E.g.
<pre>
ResultSet rs = null;
//[...]
rs = s.executeQuery("select EXAMPLE_PK,BLAHBLAH,COLUMN from MYTABLE
order by EXAMPLE_PK desc");
while (rs.next())
{
//[...]
String myStr = rs.getString("COLUMN");//all rows have SQL null
for field COLUMN
if (rs.wasNull())
{//never gets here
[...]
}
//[...]
</pre>
> ResultSet.wasNull() returns false for null VARCHAR columns
> ----------------------------------------------------------
>
> Key: DERBY-6037
> URL: https://issues.apache.org/jira/browse/DERBY-6037
> Project: Derby
> Issue Type: Bug
> Components: JDBC, SQL
> Affects Versions: 10.8.1.2, 10.9.1.0
> Environment: Java 7u7
> Reporter: Unai Vivi
>
> ResultSet.wasNull() returns false after a ResultSet.getString("COLUMNNAME")
> on a null VARCHAR field.
> E.g.
> <pre>
> ResultSet rs = null;
> //[...]
> rs = s.executeQuery("select EXAMPLE_PK,BLAHBLAH,COLUMN from
> MYTABLE order by EXAMPLE_PK desc");
> while (rs.next())
> {
> //[...]
> String myStr = rs.getString("COLUMN");//all rows have SQL
> null for field COLUMN
> if (rs.wasNull())
> {//never gets here
> //[...]
> }
> //[...]
> </pre>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
