David Wayne Birdsall created TRAFODION-2367:
-----------------------------------------------
Summary: 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)
