[TRAFODION-1121] LP Bug: 1439319 - Internal error when dropping view with sequence

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.1 (pre-incubation)
• Component/s: sql-security
• External issue URL: https://bugs.launchpad.net/bugs/1439319
• Assignee: Cliff Gray
• Reporter: Paul Low
• Created: 22/Jul/15 18:19
• Updated: 31/Aug/15 04:36
• Resolved: 31/Aug/15 04:36

Description

Internal error: assertion failure is returned.

Security is enabled. Log in as DB_ROOT user. Regular non-DB_ROOT user will not be able to create such a view due to an error. (See Bug #1439316)
User creates schema, table, and sequence.
User creates view with sequence.
User drops view, but error is returned and drop schema also fails:

SQL>create schema sch11;

— SQL operation complete.

SQL>set schema sch11;

— 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;

— SQL operation complete.

SQL>drop view myview;

• • • ERROR[2006] Internal error: assertion failure (objectRefd.objectType == COM_BASE_TABLE_OBJECT_LIT || objectRefd.objectType == COM_USER_DEFINED_ROUTINE_OBJECT_LIT || objectRefd.objectType == COM_VIEW_OBJECT_LIT) in file at line -99999.
    • ERROR[8839] Transaction was aborted.

SQL>drop schema sch11 cascade;

• • • ERROR[1069] Schema TRAFODION.SCH11 could not be dropped.

SQL>