[
https://issues.apache.org/jira/browse/TRAFODION-2367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-2367.
---------------------------------------------
Resolution: Fixed
> Fix documentation issues with Explain
> -------------------------------------
>
> Key: TRAFODION-2367
> URL: https://issues.apache.org/jira/browse/TRAFODION-2367
> Project: Apache Trafodion
> Issue Type: Bug
> Components: documentation, sql-cmp
> Affects Versions: 2.1-incubating
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Minor
>
> Because of an oddity in the parser, it is possible to use some non-reserved
> keywords as statement names in PREPARE and EXECUTE statements, but not in
> EXPLAIN. Though one can still use the statement name in EXPLAIN if the
> delimited identifier format is used. For example:
> prepare c from select count(*) from t1;
> explain options 'f' c; <--- fails with a syntax error; C is a non-reserved
> keyword
> explain options 'f' "C"; <--- works fine
> execute c; <--- works fine
> This oddity needs to be documented. (It would be nice too if it could be
> fixed, or at least reduced in frequency.)
> Also, Trafodion supports explain + query text, but the manual does not
> document this.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
