Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5922

NPE in simple select with procedure subquery

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 14.0, 13.1.1
    • None
    • Query Engine
    • None
    • DV Sprint 61
    • 0.5

      A query in the form of:

      SELECT (call proc())

      is resulting in an npe:

      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)

      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.

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - 4 hours
                  4h
                  Remaining:
                  Time Spent - 1 hour, 30 minutes Remaining Estimate - 2 hours, 30 minutes
                  2h 30m
                  Logged:
                  Time Spent - 1 hour, 30 minutes Remaining Estimate - 2 hours, 30 minutes
                  1h 30m