[jira] [Created] (TRAFODION-884) LP Bug: 1409941 - select * from table(explain(null,null)) no longer works

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-884:
------------------------------------

             Summary: LP Bug: 1409941 - select * from table(explain(null,null)) no longer works
                 Key: TRAFODION-884
                 URL: https://issues.apache.org/jira/browse/TRAFODION-884
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Hans Zeller
            Assignee: Anoop Sharma


The EXPLAIN table-valued function should return the EXPLAIN of the most recently prepared statement with this syntax:

select * from table(explain(null, null))

However, right now this returns nothing:

>>prepare s from values(1);

--- SQL command prepared.
>>select * from table(explain(null,null));

--- 0 row(s) selected.
>>

Another problem, noted by Suresh: This statement should return an EXPLAIN of all the prepared statements, but this one also returns zero rows:

select * from table(explain(null, '%'))

It does work with a prefix followed by a percent:

select * from table(explain(null, 'S%'))

When I look at method ExExplainTcb::getNextExplainTree(), I see that the code does not return anything for a NULL value passed in as the statement name, yet this used to work in the past. Has this logic changed?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)