Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1113

LP Bug: 1438896 - Internal error during create or replace view

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1 (pre-incubation)
    • Component/s: sql-security
    • Labels:
      None

      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/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.

        Attachments

          Activity

            People

            • Assignee:
              rmarton Roberta Marton
              Reporter:
              paul.low Paul Low
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: