Internal error during create or replace view
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
High
|
Roberta Marton |
Bug Description
Error returned:
SQL>create or replace view a02view2(a,b) as select col1,c1 from a02tab2, a02tab3 where col2=b1;
*** ERROR[1001] An internal error occurred in module ../sqlcomp/
Internal error is returned when using 'create or replace view'.
User creates view, then wants to replace that view with a different one. Internal error is returned.
See log below:
SQL>create schema schema1;
--- SQL operation complete.
SQL>set schema schema1;
--- SQL operation complete.
SQL>create table a02tab1(a int not null primary key, b int ,constraint tab1check check(b>0));
--- SQL operation complete.
SQL>create table a02tab2(col1 int, col2 int )no partition;
--- SQL operation complete.
SQL>create table a02tab3(a1 int,b1 int ,c1 varchar(10))no partition;
--- SQL operation complete.
SQL>create view a02view1 as select * from a02tab2;
--- SQL operation complete.
SQL>create view a02view2 as select * from a02tab2;
--- SQL operation complete.
SQL>create or replace view a02view2(a,b) as select col1,c1 from a02tab2, a02tab3 where col2=b1;
*** ERROR[1001] An internal error occurred in module ../sqlcomp/
SQL>drop schema schema1 cascade;
--- SQL operation complete.
Changed in trafodion: | |
assignee: | nobody → Roberta Marton (roberta-marton) |
Changed in trafodion: | |
status: | New → In Progress |
Changed in trafodion: | |
assignee: | Roberta Marton (roberta-marton) → Cliff Gray (cliff-gray) |
Changed in trafodion: | |
assignee: | Cliff Gray (cliff-gray) → Roberta Marton (roberta-marton) |
Changed in trafodion: | |
milestone: | none → r1.1 |
Not found errors can be returned, so the error check was change to look for
STATUS_ERROR only.