[jira] [Updated] (TRAFODION-1721) SHOWDDL shows descending DIVISION BY columns as ascending

["Hans Zeller (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hans Zeller updated TRAFODION-1721:
-----------------------------------
    Summary: SHOWDDL shows descending DIVISION BY columns as ascending  (was: SHOWDDL shows descencing DIVISION BY columns as ascending)

> 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
>
> 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)