[TRAFODION-2367] Fix documentation issues with Explain

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1-incubating
• Fix Version/s: 2.1-incubating
• Component/s: documentation, sql-cmp
• Assignee: Dave Birdsall
• Reporter: Dave Birdsall
• Created: 23/Nov/16 17:36
• Updated: 26/Mar/18 17:46
• Resolved: 28/Nov/16 17:42

Description

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.

Issue Links

• links to: GitHub Pull Request #852