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)