[jira] [Created] (TRAFODION-168) LP Bug: 1272068 - [first N] query becomes case-insensitive on an upshifted primary key column

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-168:
------------------------------------

             Summary: 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


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)