[teiid-issues] [JBoss JIRA] Commented: (TEIID-908) Enable access to the query plan without reference to Teiid classes.

Wed Jul 14 11:51:58 EDT 2010

    [ https://jira.jboss.org/browse/TEIID-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12539237#action_12539237 ] 

Steve Hawkins commented on TEIID-908:
-------------------------------------

What seems best is to add SHOW statement handling into the driver, just like the SET statement it is handled on the client side.

Proposed usage:

SHOW PLAN
returns a resultset with a clob column PLAN_TEXT, an xml column PLAN_XML, and a clob column DEBUG_LOG with a row containing these values from the previously executed query.

SHOW ANNOTATIONS
returns a resultset with string columns CATEGORY, PRIORITY, ANNOTATION, RESOLUTION and a row for each annotation on the previously executed query.  

SHOW <property>
- the inverse of SET, shows the property value for the given property.  we could consider PLAN, ANNOTATIONS, and ALL to be reserved property keys.  
returns a resultset with a single string column with a name matching the property key.

SHOW ALL
returns a resultset with a NAME string column and a VALUE string column with a row entry for every property value

> Enable access to the query plan without reference to Teiid classes.
> -------------------------------------------------------------------
>
>                 Key: TEIID-908
>                 URL: https://jira.jboss.org/browse/TEIID-908
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Driver
>    Affects Versions: 6.2.0
>         Environment: Eclipse Data Tools Platform connection to Teiid.
>            Reporter: John Doyle
>            Assignee: Steven Hawkins
>             Fix For: 7.1
>
>
> Eclipse Data Tools provides a framework for getting/displaying a query plan and I want to implement it as part of our DTP plug-ins.  Currently you can only get the query plan from the MMStatement class, but DTP works only with the JDBC interfaces.  Access to the query plan via the JDBC APIs and core java classes will enable us to plug into the framework.  

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira