Internal error when creating view with sequence

Bug #1439316 reported by Paul Low
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Released
High
Cliff Gray

Bug Description

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>

Tags: sql-security
Revision history for this message
Paul Low (paul-low-x) wrote :

DB__ROOT user is able to create the view, but encounters an error during delete (see Bug #1439319)

Cliff Gray (cliff-gray)
Changed in trafodion:
assignee: nobody → Cliff Gray (cliff-gray)
Cliff Gray (cliff-gray)
Changed in trafodion:
milestone: none → r1.2
Revision history for this message
Cliff Gray (cliff-gray) wrote :

Problem was corrected in delivery 1742.

Changed in trafodion:
status: New → Fix Committed
Revision history for this message
Paul Low (paul-low-x) wrote :

Verified on build 20150613

Changed in trafodion:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.