[jira] [Created] (TRAFODION-1120) LP Bug: 1439316 - Internal error when creating view with sequence

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-1120:
-------------------------------------

             Summary: LP Bug: 1439316 - Internal error when creating view with sequence
                 Key: TRAFODION-1120
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1120
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Paul Low
            Assignee: Cliff Gray
            Priority: Critical
             Fix For: 2.0-incubating


Sequence object is not found and an internal error is returned.

Security is enabled.  Log in as a regular user, not DB__ROOT user.
User creates schema, table, and sequence.
User creates view with sequence, but error is returned:

SQL>create view myview as select seqnum(myseq) as a from mytable;

*** ERROR[1389] Object MYSEQ does not exist in Trafodion.
*** ERROR[4082] Object TRAFODION.SCH002.MYSEQ does not exist or is inaccessible.
*** ERROR[1001] An internal error occurred in module ../sqlcomp/CmpSeabaseDDLview.cpp on line 405.  DETAILS(Bad NATable pointer in gather view privileges).


See log below:

SQL>create schema sch002;

--- SQL operation complete.

SQL>set schema sch002;

--- SQL operation complete.

SQL>create table mytable (a int, b int);

--- SQL operation complete.

SQL>create sequence myseq;

--- SQL operation complete.

SQL>create view myview as select seqnum(myseq) as a from mytable;

*** ERROR[1389] Object MYSEQ does not exist in Trafodion. 
*** ERROR[4082] Object TRAFODION.SCH002.MYSEQ does not exist or is inaccessible. 
*** ERROR[1001] An internal error occurred in module ../sqlcomp/CmpSeabaseDDLview.cpp on line 405.  DETAILS(Bad NATable pointer in gather view privileges).

SQL>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)