[teiid-issues] [JBoss JIRA] (TEIID-5929) NPE in RuleRaiseNull rule when using "insert into" command

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-5929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5929.
-----------------------------------
    Resolution: Done


The assumption in rule raise null with the first branch of a union was that the parent source node / project were related to an inline view, not project into.  An additional check was needed.

> NPE in RuleRaiseNull rule when using "insert into" command
> ----------------------------------------------------------
>
>                 Key: TEIID-5929
>                 URL: https://issues.redhat.com/browse/TEIID-5929
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 13.1
>            Reporter: Dmitrii Pogorelov
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 14.0, 13.1.1
>
>   Original Estimate: 4 hours
>  Remaining Estimate: 4 hours
>
> An NPE occurs when running the following query:
> {code:sql}
> insert into test_dwh_pg.test_mat_simplified select * from views.mat_test_view_simplified ;;
> {code}
> stacktrace:
> {code}
> 2020-04-07 12:07:58,375 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue26) tqwiPNv56nHR TEIID30019 Unexpected exception for request tqwiPNv56nHR.10: java.lang.NullPointerException                                                                                                                                                                                        at org.teiid.query.optimizer.relational.rules.RuleRaiseNull.raiseNullNode(RuleRaiseNull.java:174)                                                                                     at org.teiid.query.optimizer.relational.rules.RuleRaiseNull.execute(RuleRaiseNull.java:66)                                                                                            at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:1101)                                                                                   at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:235)                                                                                        at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:181)                                                                                                     at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:483)                                                                                                              at org.teiid.dqp.internal.process.Request.processRequest(Request.java:511)                                                                                                            at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:671)                                                                                                at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350)                                                                                                   at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:43)                                                                                                      at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:284)                                                                                                       at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:281)                                                                                                at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:124)                                                                               at org.teiid.dqp.internal.process.ThreadReuseExecutor$2.run(ThreadReuseExecutor.java:212)                                                                                             at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)                                                                                                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)                                                                                                    at java.lang.Thread.run(Thread.java:745) 
> {code}



--
This message was sent by Atlassian Jira
(v7.13.8#713008)