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:48:27 UTC
[jira] [Resolved] (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:all-tabpanel ]
David Wayne Birdsall resolved TRAFODION-803.
--------------------------------------------
Resolution: Fixed
> 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
> Fix For: 1.2-incubating
>
>
> 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)