[jira] [Commented] (DRILL-2464) JDBC : ResultSet.wasNull always returns false for all datatypes

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14362579#comment-14362579 ] 

Daniel Barclay (Drill) commented on DRILL-2464:
-----------------------------------------------

> always returns false for all datatypes

Is that the case only for Parquet sources or also for other sources?

Could you try with something like:

- CREATE VIEW Test AS SELECT CAST( NULL AS INTEGER) FROM whatever_table
- SELECT FROM Test
- and then seeing if wasNull() works differently?




> JDBC : ResultSet.wasNull always returns false for all datatypes
> ---------------------------------------------------------------
>
>                 Key: DRILL-2464
>                 URL: https://issues.apache.org/jira/browse/DRILL-2464
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC
>            Reporter: Rahul Challapalli
>            Assignee: Daniel Barclay (Drill)
>         Attachments: fewtypes_null.parquet
>
>
> git.commit.id.abbrev=7b4c887
> I attached a parquet file which has nulls in it. 
> {code}
> while (rs.next()) {
>     rs.getLong(1);
>     if (rs.wasNull()) {
>        // DRILL does not come here even when the column value is null
>     }
> }
> {code}
> I am not entirely sure if this is a duplicate to DRILL-2136. But here I have seen this happen for all data types.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)