You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/05 22:30:26 UTC
[jira] [Updated] (TRAFODION-1279) LP Bug: 1465901 - Assertion
failure during SELECT on a table where a column was dropped and re-added
[ https://issues.apache.org/jira/browse/TRAFODION-1279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah updated TRAFODION-1279:
--------------------------------------
Attachment: addcol.txt
> 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
>
> Attachments: addcol.txt
>
>
> 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)