Assertion failure during SELECT on a table where a column was dropped and re-added
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
High
|
Suresh Subbiah |
Bug Description
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.OPPORTUNITYRE
*** ERROR[2006] Internal error: assertion failure () in file ../common/
*** ERROR[8822] The statement was not prepared.
The column OPPORTUNITYRELE
>>showddl T_RELATIONSHIP;
CREATE TABLE TRAFODION.
(
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
, OPPORTUNITYEXPI
COLLATE DEFAULT DEFAULT NULL /* added col */
, OPPORTUNITYRELE
, RELATEDPRIORITY SMALLINT DEFAULT NULL /* added col */
, PRIMARY KEY (ID ASC)
)
;