[jira] [Created] (DRILL-3287) Changing session level parameter back to the default value does not change it

["Victoria Markman (JIRA)" <ji...@apache.org>]

Victoria Markman created DRILL-3287:
---------------------------------------

             Summary: Changing session level parameter back to the default value does not change it
                 Key: DRILL-3287
                 URL: https://issues.apache.org/jira/browse/DRILL-3287
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Victoria Markman


Initial state:
{code}
0: jdbc:drill:schema=dfs> select * from sys.options where status like '%CHANGED%';
+-----------------------------------+----------+---------+----------+----------+-------------+-----------+------------+
|               name                |   kind   |  type   |  status  | num_val  | string_val  | bool_val  | float_val  |
+-----------------------------------+----------+---------+----------+----------+-------------+-----------+------------+
| planner.enable_decimal_data_type  | BOOLEAN  | SYSTEM  | CHANGED  | null     | null        | true      | null       |
+-----------------------------------+----------+---------+----------+----------+-------------+-----------+------------+
1 row selected (0.247 seconds)
{code}

I changed session parameter:

{code}
0: jdbc:drill:schema=dfs> alter session set `planner.enable_hashjoin` = false;
+-------+-----------------------------------+
|  ok   |              summary              |
+-------+-----------------------------------+
| true  | planner.enable_hashjoin updated.  |
+-------+-----------------------------------+
1 row selected (0.1 seconds)
{code}

So far, so good: it appears on changed options list: 
{code}
0: jdbc:drill:schema=dfs> select * from sys.options where status like '%CHANGED%';
+-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
|               name                |   kind   |   type   |  status  | num_val  | string_val  | bool_val  | float_val  |
+-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
| planner.enable_decimal_data_type  | BOOLEAN  | SYSTEM   | CHANGED  | null     | null        | true      | null       |
| planner.enable_hashjoin           | BOOLEAN  | SESSION  | CHANGED  | null     | null        | false     | null       |
+-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
2 rows selected (0.133 seconds)
{code}

I changed session parameter back to it's default value:
{code}
0: jdbc:drill:schema=dfs> alter session set `planner.enable_hashjoin` = true;
+-------+-----------------------------------+
|  ok   |              summary              |
+-------+-----------------------------------+
| true  | planner.enable_hashjoin updated.  |
+-------+-----------------------------------+
1 row selected (0.096 seconds)
{code}

{color:red} It still appears on changed list, even though it has default value:{color}
{code}
0: jdbc:drill:schema=dfs> select * from sys.options where status like '%CHANGED%';
+-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
|               name                |   kind   |   type   |  status  | num_val  | string_val  | bool_val  | float_val  |
+-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
| planner.enable_decimal_data_type  | BOOLEAN  | SYSTEM   | CHANGED  | null     | null        | true      | null       |
| planner.enable_hashjoin           | BOOLEAN  | SESSION  | CHANGED  | null     | null        | true      | null       |
+-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
2 rows selected (0.124 seconds)
{code}



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