[jira] [Created] (DRILL-7673) View set query fails with NPE for non-existing option

["Vova Vysotskyi (Jira)" <ji...@apache.org>]

Vova Vysotskyi created DRILL-7673:
-------------------------------------

             Summary: View set query fails with NPE for non-existing option
                 Key: DRILL-7673
                 URL: https://issues.apache.org/jira/browse/DRILL-7673
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.17.0
            Reporter: Vova Vysotskyi
            Assignee: Vova Vysotskyi
             Fix For: 1.18.0


The following query fails with NPE:
{code:sql}
set `non-existing option`
{code}

Stack trace:
{noformat}
Caused by: java.lang.NullPointerException: null
	at org.apache.drill.exec.planner.sql.handlers.SetOptionHandler.getPlan(SetOptionHandler.java:66)
	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:283)
	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:163)
	at org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:140)
	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:93)
	at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:592)
	at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:277)
	... 3 common frames omitted
{noformat}

Also, the result of the command returns option name with the same case as it was specified in the query:
{noformat}
set `metastore.ENABLED`;
+-------------------+-------+
|       name        | value |
+-------------------+-------+
| metastore.ENABLED | false |
+-------------------+-------+
{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)