You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/14 02:36:45 UTC
[jira] [Commented] (TRAFODION-168) LP Bug: 1272068 - [first N]
query becomes case-insensitive on an upshifted primary key column
[ https://issues.apache.org/jira/browse/TRAFODION-168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696232#comment-14696232 ]
Atanu Mishra commented on TRAFODION-168:
----------------------------------------
Weishiun Tsai (wei-shiun-tsai) wrote on 2014-05-27: #1
Verified on the datalake v40963 build. This problem has been fixed:
>>create table t (c char(2) upshift NOT NULL, primary key (c));
--- SQL operation complete.
>>insert into t values ('aa');
--- 1 row(s) inserted.
>>select * from t where c = 'aa';
--- 0 row(s) selected.
>>select [first 1] * from t where c = 'aa';
--- 0 row(s) selected.
>>drop table t;
--- SQL operation complete.
>>create table t (c char(2) upshift);
--- SQL operation complete.
>>insert into t values ('aa');
--- 1 row(s) inserted.
>>select * from t where c = 'aa';
--- 0 row(s) selected.
>>select [first 1] * from t where c = 'aa';
--- 0 row(s) selected.
Changed in trafodion:
status: In Progress → Fix Released
> LP Bug: 1272068 - [first N] query becomes case-insensitive on an upshifted primary key column
> ---------------------------------------------------------------------------------------------
>
> Key: TRAFODION-168
> URL: https://issues.apache.org/jira/browse/TRAFODION-168
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Assignee: Anoop Sharma
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> When a [first N] query has a predicate on an upshifted primary key, the query becomes case-insensitive. As shown in the first part of the output, the query select * from t where c = ‘aa’ returns 0 row, while the same query with [first 1] returns 1 row. In the second part of the output, both queries return correct 0 row when the column is not a primary key anymore.
> This is seen on the beta build trafodion-ci-release-trafodion_beta-20140117-v36857_release.tar installed on a workstation.
> >>create table t (c char(2) upshift NOT NULL, primary key (c));
> --- SQL operation complete.
> >>insert into t values ('aa');
> --- 1 row(s) inserted.
> >>select * from t where c = 'aa';
> --- 0 row(s) selected.
> >>select [first 1] * from t where c = 'aa';
> C
> --
> AA
> --- 1 row(s) selected.
> >>drop table t;
> --- SQL operation complete.
> >>create table t (c char(2) upshift);
> --- SQL operation complete.
> >>insert into t values ('aa');
> --- 1 row(s) inserted.
> >>select * from t where c = 'aa';
> --- 0 row(s) selected.
> >>select [first 1] * from t where c = 'aa';
> --- 0 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)