[jira] [Created] (NIFI-1412) JdbcCommon.createSchema() throws exception when no columns are present

["Matt Burgess (JIRA)" <ji...@apache.org>]

Matt Burgess created NIFI-1412:
----------------------------------

             Summary: JdbcCommon.createSchema() throws exception when no columns are present
                 Key: NIFI-1412
                 URL: https://issues.apache.org/jira/browse/NIFI-1412
             Project: Apache NiFi
          Issue Type: Bug
            Reporter: Matt Burgess


The discovery of the bug in NIFI-1409 was a result of an exception being thrown when no columns were present in a result set returned by a query in the ExecuteSql processor.  While NIFI-1409 is concerned with handling all such exceptions, this case is for the aforementioned exception.

The problem seems to be in JdbcCommon.createSchema():
https://github.com/apache/nifi/blob/nifi-0.4.1/nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/util/JdbcCommon.java#L130
This line asks for the table name for the first column, and when there are no columns, a SQLException is thrown.

The Avro docs suggest that no fields are necessary for the schema to be valid, so if there are no columns in the result set, a schema with no fields should be returned, rather than an exception being thrown.



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