You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2015/10/05 19:47:26 UTC
[jira] [Commented] (TRAFODION-803) LP Bug: 1398896 - Odd output
when selecting a non-existent column
[ https://issues.apache.org/jira/browse/TRAFODION-803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14943725#comment-14943725 ]
David Wayne Birdsall commented on TRAFODION-803:
------------------------------------------------
I committed a fix for this before Trafodion went into Apache incubation. Don't have the details, but it was in May or June of 2015.
> LP Bug: 1398896 - Odd output when selecting a non-existent column
> -----------------------------------------------------------------
>
> Key: TRAFODION-803
> URL: https://issues.apache.org/jira/browse/TRAFODION-803
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Minor
>
> 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.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)