[jira] [Created] (DRILL-1505) Updating Session Value Doesn't Reflect In 'sys.options' Query Output

["MUFEED USMAN (JIRA)" <ji...@apache.org>]

MUFEED USMAN created DRILL-1505:
-----------------------------------

             Summary: Updating Session Value Doesn't Reflect In 'sys.options' Query Output
                 Key: DRILL-1505
                 URL: https://issues.apache.org/jira/browse/DRILL-1505
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow
    Affects Versions: 0.5.0
            Reporter: MUFEED USMAN
            Priority: Critical


Even after updating the value for a session option, the value when queried reflects the default value. How to know what is the value for the current session?


[root@n69 bin]# ./sqlline -u jdbc:drill:zk=n69:5181,n72:5181,n73:5181 -n admin -p admin
sqlline version 1.1.6

0: jdbc:drill:zk=n69:5181,n72:5181,n73:5181> alter session set `exec.errors.verbose`=true;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | exec.errors.verbose updated. |
+------------+------------+
1 row selected (0.185 seconds)

0: jdbc:drill:zk=n69:5181,n72:5181,n73:5181> select * from sys.options where name = 'exec.errors.verbose';
+------------+------------+------------+------------+------------+------------+------------+
|    name    |    kind    |    type    |  num_val   | string_val |  bool_val  | float_val  |
+------------+------------+------------+------------+------------+------------+------------+
| exec.errors.verbose | BOOLEAN    | SYSTEM     | null       | null       | false      | null       |
+------------+------------+------------+------------+------------+------------+------------+
1 row selected (0.192 seconds)



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