You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Hans Zeller (JIRA)" <ji...@apache.org> on 2015/12/23 20:38:46 UTC
[jira] [Closed] (TRAFODION-1721) SHOWDDL shows descending DIVISION
BY columns as ascending
[ https://issues.apache.org/jira/browse/TRAFODION-1721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller closed TRAFODION-1721.
----------------------------------
> SHOWDDL shows descending DIVISION BY columns as ascending
> ---------------------------------------------------------
>
> Key: TRAFODION-1721
> URL: https://issues.apache.org/jira/browse/TRAFODION-1721
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 1.2-incubating
> Environment: any
> Reporter: Hans Zeller
> Assignee: Hans Zeller
> Fix For: 2.0-incubating
>
>
> Here is a test case:
> create table t_desc_div(a int not null,
> b int not null,
> primary key (a desc, b))
> division by (cast(a/100 as integer not null) desc);
> create table t_desc_div_like like t_desc_div;
> showddl t_desc_div;
> showddl t_desc_div_like;
> select keyseq_number, column_name, column_number, ordering
> from "_MD_".objects o join "_MD_".keys k on o.object_uid = k.object_uid
> where o.object_name = 'T_DESC_DIV'
> order by 1;
> select keyseq_number, column_name, column_number, ordering
> from "_MD_".objects o join "_MD_".keys k on o.object_uid = k.object_uid
> where o.object_name = 'T_DESC_DIV_LIKE'
> order by 1;
> SHOWDDL doesn't show the "DESC" in the division by in either table. The metadata query shows a descending divisioning column for the first query, but an ascending divisioning column for the second query. This is because CREATE TABLE LIKE relies on a flavor of SHOWDDL.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)