[
https://issues.apache.org/jira/browse/TRAFODION-127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-127.
----------------------------------
Resolution: Fixed
Fix Version/s: 1.0 (pre-incubation)
> LP Bug: 1233425 - UPSHIFT keyword has no effect on a CHAR column
> ----------------------------------------------------------------
>
> Key: TRAFODION-127
> URL: https://issues.apache.org/jira/browse/TRAFODION-127
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Weishiun Tsai
> Assignee: Anoop Sharma
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> The UPSHIFT keyword has no effect on a char column, as shown in the following
> example:
> >>cqd mode_seabase 'on';
> --- SQL operation complete.
> >>set schema seabase.phoenix;
> --- SQL operation complete.
> >>create table t (a int not null not droppable primary key, b char(10)
> >>upshift);
> --- SQL operation complete.
> >>insert into t values (1, 'Alpha'),(2, 'ALPHA');
> --- 2 row(s) inserted.
> >>select * from t;
> A B
> ----------- ----------
> 1 Alpha
> 2 ALPHA
> --- 2 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
