Alice Chen created TRAFODION-1279:
-------------------------------------
Summary: LP Bug: 1465901 - Assertion failure during SELECT on a table where a column was dropped and re-added
Key: TRAFODION-1279
URL: https://issues.apache.org/jira/browse/TRAFODION-1279
Project: Apache Trafodion
Issue Type: Bug
Components: sql-general
Reporter: Atanu Mishra
Assignee: Suresh Subbiah
Priority: Critical
Fix For: 2.0-incubating
The query is
>>SELECT a.* from T_RELATIONSHIP a, T_OBJECTTYPE b WHERE b.OBJECTCODE = 'worker.hire' AND (a.FROMOBJECTTYPEID = b.ID OR a.TOOBJECTTYPEID = b.id) ORDER BY a.OPPORTUNITYRELEVANCY DESC;
*** ERROR[2006] Internal error: assertion failure () in file ../common/BaseTypes.cpp at line 118.
*** ERROR[8822] The statement was not prepared.
The column OPPORTUNITYRELEVANCY in T_RELATiONSHIP was dropped and recreated with different type
>>showddl T_RELATIONSHIP;
CREATE TABLE TRAFODION.E_META.T_RELATIONSHIP
(
ID INT UNSIGNED GENERATED BY DEFAULT AS
IDENTITY ( START WITH 1 INCREMENT BY 1 MAXVALUE 4294967295 MINVALUE 1
CACHE 25 NO CYCLE INT UNSIGNED ) NOT NULL NOT DROPPABLE
, TYPECODE VARCHAR(20) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, FROMOBJECTTYPEID INT UNSIGNED NO DEFAULT NOT NULL NOT
DROPPABLE
, TOOBJECTTYPEID INT UNSIGNED NO DEFAULT NOT NULL NOT
DROPPABLE
, OPPORTUNITYEXPIRATIONDURATION VARCHAR(100) CHARACTER SET ISO88591
COLLATE DEFAULT DEFAULT NULL /* added col */
, OPPORTUNITYRELEVANCY SMALLINT DEFAULT NULL /* added col */
, RELATEDPRIORITY SMALLINT DEFAULT NULL /* added col */
, PRIMARY KEY (ID ASC)
)
;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)