[jira] [Created] (TRAFODION-123) LP Bug: 1233323 - SELECT query returns error 8415 when DATE type is in primary key

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

Alice Chen created TRAFODION-123:
------------------------------------

             Summary: LP Bug: 1233323 - SELECT query returns error 8415 when DATE type is in primary key
                 Key: TRAFODION-123
                 URL: https://issues.apache.org/jira/browse/TRAFODION-123
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-general
            Reporter: Weishiun Tsai
            Assignee: Anoop Sharma
            Priority: Critical


When the DATE type is used as a primary key, the SELECT query returns error 8415, as shown in the following example.  Also shown in the example is that the same query runs fine if DATE is not a primary key.  A similar query without the WHERE clause also runs fine when DATE is a primary key.

>>cqd mode_seabase 'on';

--- SQL operation complete.
>>set schema seabase.phoenix;

--- SQL operation complete.

>>create table t (id int no default not null, date1 date no default not null) primary key (id);

--- SQL operation complete.
>>insert into t values (3, date '2013-01-01'), (2, date '2011-01-01'), (1, date '2012-01-01');

--- 3 row(s) inserted.

>>select id, date1 from t where id < 2;

ID           DATE1
-----------  ----------

          1  2012-01-01

--- 1 row(s) selected.
>>drop table t;

--- SQL operation complete.
>>create table t (id int no default not null, date1 date no default not null) primary key (id, date1);

--- SQL operation complete.
>>insert into t values (3, date '2013-01-01'), (2, date '2011-01-01'), (1, date '2012-01-01');

--- 3 row(s) inserted.
>>select id, date1 from t where id < 2;                                         
*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.

--- 0 row(s) selected.
>>select id, date1 from t;

ID           DATE1
-----------  ----------

          1  2012-01-01
          2  2011-01-01
          3  2013-01-01

--- 3 row(s) selected.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)