[teiid-issues] [JBoss JIRA] (TEIID-5922) NPE in simple select with procedure subquery

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-5922?focusedWorklogId=12450666&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-12450666 ]

Steven Hawkins logged work on TEIID-5922:
-----------------------------------------

                Author: Steven Hawkins
            Created on: 24/Mar/20 2:55 PM
            Start Date: 24/Mar/20 2:55 PM
    Worklog Time Spent: 1 hour, 30 minutes 

Issue Time Tracking
-------------------

    Remaining Estimate: 2 hours, 30 minutes  (was: 4 hours)
            Time Spent: 1 hour, 30 minutes
            Worklog Id:     (was: 12450666)


> NPE in simple select with procedure subquery
> --------------------------------------------
>
>                 Key: TEIID-5922
>                 URL: https://issues.redhat.com/browse/TEIID-5922
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 14.0, 13.1.1
>
>   Original Estimate: 4 hours
>          Time Spent: 1 hour, 30 minutes
>  Remaining Estimate: 2 hours, 30 minutes
>
> A query in the form of:
> SELECT (call proc())
> is resulting in an npe:
> {code}
> java.lang.NullPointerException
> 	at org.teiid.query.optimizer.relational.rules.RulePlanSubqueries.planMergeJoin(RulePlanSubqueries.java:272)
> 	at org.teiid.query.optimizer.relational.rules.RulePlanSubqueries.processSubqueries(RulePlanSubqueries.java:232)
> 	at org.teiid.query.optimizer.relational.rules.RulePlanSubqueries.execute(RulePlanSubqueries.java:193)
> 	at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:1101)
> {code}
> Until relatively recently we disallowed queries from having subqueries if there was no from clause.  That change was checked against regular subqueries, but apparently not procedure subqueries.



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