[jira] [Updated] (DRILL-2371) quoted and unquoted boolean values in BOOT options have strange behavior

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau updated DRILL-2371:
----------------------------------
    Fix Version/s: Future

> quoted and unquoted boolean values in BOOT options have strange behavior
> ------------------------------------------------------------------------
>
>                 Key: DRILL-2371
>                 URL: https://issues.apache.org/jira/browse/DRILL-2371
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Metadata
>            Reporter: Zhiyong Liu
>            Assignee: Steven Phillips
>            Priority: Minor
>             Fix For: Future
>
>
> git.commit.id.abbrev=a84f7b9
> In drill-override.conf, specify
>             "http" : {
>                 "port" : 8047,
>                 "enabled" : true
>             }
> and don't quote the boolean value.
> 0: jdbc:drill:> select * from sys.options where name = 'drill.exec.http.enabled' order by name;
> +------------+------------+------------+------------+------------+------------+------------+
> |    name    |    kind    |    type    |  num_val   | string_val |  bool_val  | float_val  |
> +------------+------------+------------+------------+------------+------------+------------+
> | drill.exec.http.enabled | BOOLEAN    | BOOT       | null       | null       | true       | null       |
> +------------+------------+------------+------------+------------+------------+------------+
> The query correctly returns the boolean value as 'bool_val' and the type set to 'BOOLEAN'.
> Check http://<hostname>:8047 to make sure that it works.
> Now, change the block to the following:
>             "http" : {
>                 "port" : 8047,
>                 "enabled" : "true"
>             }
> restart drill and query:
> 0: jdbc:drill:> select * from sys.options where name = 'drill.exec.http.enabled' order by name;
> +------------+------------+------------+------------+------------+------------+------------+
> |    name    |    kind    |    type    |  num_val   | string_val |  bool_val  | float_val  |
> +------------+------------+------------+------------+------------+------------+------------+
> | drill.exec.http.enabled | null       | BOOT       | null       | "true"     | null       | null       |
> +------------+------------+------------+------------+------------+------------+------------+
> Note that type is now null and the "boolean" value is now string_val.
> Check http://<hostname>:8047 to observe that it works.
> It may be more consistent if we either handle the second case the same way as the first one in query result set, or fail in the second case.



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