[
https://issues.apache.org/jira/browse/TRAFODION-1439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-1439 started by Hans Zeller.
----------------------------------------------
> DIVISION BY does not work with delimited column identifiers
> -----------------------------------------------------------
>
> Key: TRAFODION-1439
> URL: https://issues.apache.org/jira/browse/TRAFODION-1439
> Project: Apache Trafodion
> Issue Type: Bug
> Affects Versions: 1.1 (pre-incubation)
> Environment: any
> Reporter: Hans Zeller
> Assignee: Hans Zeller
> Fix For: 2.0-incubating
>
>
> This is a problem found by Suresh.
> When using a delimited identifier in a DIVISION BY clause, it is possible to
> create the table, but subsequent operations on the table return a syntax
> error. Here is an example:
> create table tdivd("a" int not null primary key,
> b int)
> division by (cast("a"/4 as int not null));
> >>select * from tdivd;
> *** ERROR[4001] Column A is not found. Tables in scope: TRAFODION.SCH.TDIVD.
> Default schema: TRAFODION.SCH.
> The problem is that the unparse() function that's used internally is not
> applying the delimiters. This happened when I changed the item expression
> type from a regular base column to the "named NATYpe to Item" expression.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
