Alice Chen created TRAFODION-1113:
-------------------------------------
Summary: LP Bug: 1438896 - Internal error during create or replace
view
Key: TRAFODION-1113
URL: https://issues.apache.org/jira/browse/TRAFODION-1113
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Paul Low
Assignee: Roberta Marton
Priority: Critical
Fix For: 2.0-incubating
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/CmpSeabaseDDLview.cpp on line 718. DETAILS(Unable to retrieve
privileges for replaced view).
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/CmpSeabaseDDLview.cpp on line 718. DETAILS(Unable to retrieve
privileges for replaced view).
SQL>drop schema schema1 cascade;
--- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
