[TRAFODION-803] LP Bug: 1398896 - Odd output when selecting a non-existent column

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.2-incubating
• Component/s: sql-cmp
• External issue URL: https://bugs.launchpad.net/bugs/1398896
• Assignee: Dave Birdsall
• Reporter: Dave Birdsall
• Created: 22/Jul/15 18:18
• Updated: 21/Apr/16 22:38
• Resolved: 05/Oct/15 17:48

Description

When running from sqlci, the compiler emits some odd output when you select a column that doesn't exist in a Trafodion table. Here's an example:

>>create table temp (a integer not null, b integer, primary key (a));

— SQL operation complete.
>>select turkey from temp;
TURKEY ( -99 -99) ( -99 -99) ( -99 -99)
TURKEY ( -99 -99) ( -99 -99) ( -99 -99)

• • • ERROR[4001] Column TURKEY is not found. Tables in scope: TRAFODION.SCH.TEMP. Default schema: TRAFODION.SCH.

• • • ERROR[8822] The statement was not prepared.

>>