Assertion failure during SELECT on a table where a column was dropped and re-added

Bug #1465901 reported by Atanu Mishra on 2015-06-17
6
This bug affects 1 person
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.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)
  )
;

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers