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

["Zhiyong Liu (JIRA)" <ji...@apache.org>]

Zhiyong Liu created DRILL-2371:
----------------------------------

             Summary: 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


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)