Return-Path: 
 <dev-return-11044-apmail-drill-dev-archive=drill.apache.org@drill.apache.org>
X-Original-To: apmail-drill-dev-archive@www.apache.org
Delivered-To: apmail-drill-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 1A13717695
	for <apmail-drill-dev-archive@www.apache.org>;
 Tue,  3 Mar 2015 23:50:13 +0000 (UTC)
Received: (qmail 14094 invoked by uid 500); 3 Mar 2015 23:50:04 -0000
Delivered-To: apmail-drill-dev-archive@drill.apache.org
Received: (qmail 14032 invoked by uid 500); 3 Mar 2015 23:50:04 -0000
Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@drill.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@drill.apache.org>
List-Post: <mailto:dev@drill.apache.org>
List-Id: <dev.drill.apache.org>
Reply-To: dev@drill.apache.org
Delivered-To: mailing list dev@drill.apache.org
Received: (qmail 13984 invoked by uid 99); 3 Mar 2015 23:50:04 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Mar 2015 23:50:04 +0000
Date: Tue, 3 Mar 2015 23:50:04 +0000 (UTC)
From: "Zhiyong Liu (JIRA)" <jira@apache.org>
To: dev@drill.apache.org
Message-ID: <JIRA.12779235.1425426583000.69856.1425426604756@Atlassian.JIRA>
In-Reply-To: <JIRA.12779235.1425426583000@Atlassian.JIRA>
References: <JIRA.12779235.1425426583000@Atlassian.JIRA>
 <JIRA.12779235.1425426583085@arcas>
Subject: [jira] [Created] (DRILL-2371) quoted and unquoted boolean values in
 BOOT options have strange behavior
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394

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)