[jira] [Commented] (DRILL-2288) ResultSetMetaData not set for zero-row results (DatabaseMetaData.getColumns(...)) [ScanBatch problem]

["Sudheesh Katkam (JIRA)" <ji...@apache.org>]

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

Sudheesh Katkam commented on DRILL-2288:
----------------------------------------

Here's another test case:

Create an empty hive table. And then:
{code}
0: jdbc:drill:> select * from hive.nation;
+--+
|  |
+--+
+--+
No rows selected (0.789 seconds)
{code}
However,
{code}
0: jdbc:drill:> SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'nation' AND TABLE_SCHEMA = 'hive.default';
+--------------+--------------------+
| COLUMN_NAME  |     DATA_TYPE      |
+--------------+--------------------+
| n_nationkey  | INTEGER            |
| n_name       | CHARACTER VARYING  |
| n_regionkey  | INTEGER            |
| n_comment    | CHARACTER VARYING  |
+--------------+--------------------+
4 rows selected (10.363 seconds)
{code}

> ResultSetMetaData not set for zero-row results (DatabaseMetaData.getColumns(...)) [ScanBatch problem]
> -----------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-2288
>                 URL: https://issues.apache.org/jira/browse/DRILL-2288
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Information Schema
>            Reporter: Daniel Barclay (Drill)
>            Assignee: Daniel Barclay (Drill)
>             Fix For: 1.3.0
>
>         Attachments: Drill2288NoResultSetMetadataWhenZeroRowsTest.java
>
>
> The ResultSetMetaData object from getMetadata() of a ResultSet is not set up (getColumnCount() returns zero, and trying to access any other metadata throws IndexOutOfBoundsException) for a result set with zero rows, at least for one from DatabaseMetaData.getColumns(...).



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