[jira] [Closed] (TRAFODION-1113) LP Bug: 1438896 - Internal error during create or replace view

["Roberta Marton (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Roberta Marton closed TRAFODION-1113.
-------------------------------------
       Resolution: Fixed
    Fix Version/s:     (was: 2.0-incubating)
                   1.1 (pre-incubation)

Fixed 

> 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: 1.1 (pre-incubation)
>
>
> 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)