[teiid-users] query plan changes

[Steven Hawkins]

Hello all,

Currently we have OPTION SHOWPLAN PLANONLY DEBUG to control planning and execution.  The drawbacks are that this introduces three reserved words (SHOWPLAN, PLANONLY, DEBUG) and it's only applicable to the top level user query.

The proposed replacement makes use of https://jira.jboss.org/jira/browse/TEIID-906, which added basic support for a set statement:

SET SHOWPLAN [ON|DEBUG|OFF]
SET NOEXEC [ON|OFF] - general replacement for PLANONLY, will not execute the command if ON

I would also like to remove most of the logic surrounding the org.teiid.client.plan.PlanNode class.  The visitors, display helpers, etc.  Since we don't publish a meaningful schema for the xml form(s) or document the property keys we might as well assume that we're the primary consumers and forgo the flexibility.  

Any thoughts?  

Steve