Suresh Subbiah created TRAFODION-1799: -----------------------------------------
Summary: create index failed with ERROR[3047] Key: TRAFODION-1799 URL: https://issues.apache.org/jira/browse/TRAFODION-1799 Project: Apache Trafodion Issue Type: Bug Components: sql-cmp Affects Versions: 1.2-incubating Reporter: Suresh Subbiah Assignee: Suresh Subbiah Fix For: 2.0-incubating set schema sch ; CREATE TABLE TRAFODION.SCH.TEST1 ( L_ORDERKEY INT DEFAULT NULL SERIALIZED , L_SHIPDATE TIMESTAMP(6) NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED ) PRIMARY KEY (L_SHIPDATE ASC) SALT USING 4 PARTITIONS ; create index l_order_idx on test1 (L_ORDERKEY ); fails with *** ERROR[3047] The timestamp '<min>' is not valid. *** WARNING[2053] Optimizer pass two assertion failure (itemExpr != NULL) in file ../optimizer/EncodedKeyValue.cpp at line 214. Attempting to recover and produce a plan. *** ERROR[3047] The timestamp '<min>' is not valid. *** ERROR[8822] The statement was not prepared. -- This message was sent by Atlassian JIRA (v6.3.4#6332)