[
https://issues.apache.org/jira/browse/TRAFODION-1721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15069058#comment-15069058
]
ASF GitHub Bot commented on TRAFODION-1721:
-------------------------------------------
GitHub user zellerh opened a pull request:
https://github.com/apache/incubator-trafodion/pull/240
[TRAFODION-1721] SHOWDDL fix for descending division by
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zellerh/incubator-trafodion bug/1721
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/240.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #240
----
commit 68ce84d276c31ceeec978dee10ffe79775b82113
Author: Hans Zeller <zellerh@edev05.esgyn.local>
Date: 2015-12-23T02:37:38Z
[TRAFODION-1721] SHOWDDL fix for descending division by
----
> SHOWDDL shows descencing 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)
