[ https://issues.apache.org/jira/browse/TRAFODION-229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14706305#comment-14706305 ]
Atanu Mishra commented on TRAFODION-229: ---------------------------------------- Anoop Sharma (anoop-sharma) on 2014-05-05 Changed in trafodion: status: In Progress → Fix Committed Weishiun Tsai (wei-shiun-tsai) wrote on 2014-05-09: #1 Verified on the datalake v40174 build. This problem has been fixed: >>Create table T3(F int default null, +> G smallint default null, +> H largeint not null not droppable primary key, +> I numeric(9,3) default null); --- SQL operation complete. >> >>create index num_idx on T3(I); --- SQL operation complete. >> >>insert into T3 values(2, 1,1,1); --- 1 row(s) inserted. >> >>drop table T3 cascade; --- SQL operation complete. >> >>Create table T3(F int not null not droppable , +> G smallint not null not droppable , +> H largeint not null not droppable , +> I numeric(9,3) default null, +> primary key (F,G,H) ); --- SQL operation complete. >> >>create index num_idx on T3(I); --- SQL operation complete. >> >>insert into T3 values(2, 1,1,1); --- 1 row(s) inserted. >> insert into T3 values(4, 2,2,1); --- 1 row(s) inserted. Changed in trafodion: status: Fix Committed → Fix Released > LP Bug: 1308695 - Indexes caused insert to assert in > ../optimizer/BindRelExpr.cpp > --------------------------------------------------------------------------------- > > Key: TRAFODION-229 > URL: https://issues.apache.org/jira/browse/TRAFODION-229 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Reporter: Weishiun Tsai > Assignee: Anoop Sharma > Priority: Critical > > When a table is dropped and recreated with the same name, if indexes were > created for the tables, the insert on the second table returns an internal > error: > *** ERROR[2006] Internal error: assertion failure (tgtcols.entries() == > baseColRefs().entries()) in file ../optimizer/BindRelExpr.cpp at line 11964. > [2014-04-16 11:27:30] > This is seen on the beta v39140 build, both on a workstation, and on the > cluster installation. > Here is the script to reproduce this problem. Following it are 2 execution > outputs. The 1st output shows the errors. The 2nd output shows that the > insert runs fine if the indexes were not created. > ================================================================================================== > Create table T3(F int default null, > G smallint default null, > H largeint not null not droppable primary key, > I numeric(9,3) default null); > create index num_idx on T3(I); > insert into T3 values(2, 1,1,1); > drop table T3 cascade; > Create table T3(F int not null not droppable , > G smallint not null not droppable , > H largeint not null not droppable , > I numeric(9,3) default null, > primary key (F,G,H) ); > create index num_idx on T3(I); > insert into T3 values(2, 1,1,1); > insert into T3 values(4, 2,2,1); > ================================================================================================== > SQL>Create table T3(F int default null, > +>G smallint default null, > +>H largeint not null not droppable primary key, > +>I numeric(9,3) default null); > --- SQL operation complete. > SQL>create index num_idx on T3(I); > --- SQL operation complete. > SQL>insert into T3 values(2, 1,1,1); > --- 1 row(s) inserted. > SQL>drop table T3 cascade; > --- SQL operation complete. > SQL>Create table T3(F int not null not droppable , > +>G smallint not null not droppable , > +>H largeint not null not droppable , > +>I numeric(9,3) default null, > +>primary key (F,G,H) ); > --- SQL operation complete. > SQL>create index num_idx on T3(I); > --- SQL operation complete. > SQL>insert into T3 values(2, 1,1,1); > *** ERROR[2006] Internal error: assertion failure (tgtcols.entries() == > baseColRefs().entries()) in file ../optimizer/BindRelExpr.cpp at line 11964. > [2014-04-16 11:27:30] > SQL>insert into T3 values(4, 2,2,1); > *** ERROR[2006] Internal error: assertion failure (tgtcols.entries() == > baseColRefs().entries()) in file ../optimizer/BindRelExpr.cpp at line 11964. > [2014-04-16 11:27:30] > ================================================================================================== > SQL>Create table T3(F int default null, > +>G smallint default null, > +>H largeint not null not droppable primary key, > +>I numeric(9,3) default null); > --- SQL operation complete. > SQL>-- create index num_idx on T3(I); > SQL>insert into T3 values(2, 1,1,1); > --- 1 row(s) inserted. > SQL>drop table T3 cascade; > --- SQL operation complete. > SQL>Create table T3(F int not null not droppable , > +>G smallint not null not droppable , > +>H largeint not null not droppable , > +>I numeric(9,3) default null, > +>primary key (F,G,H) ); > --- SQL operation complete. > SQL>-- create index num_idx on T3(I); > SQL>insert into T3 values(2, 1,1,1); > --- 1 row(s) inserted. > SQL>insert into T3 values(4, 2,2,1); > --- 1 row(s) inserted. -- This message was sent by Atlassian JIRA (v6.3.4#6332)