Internal error when creating view with sequence
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.
*** ERROR[1001] An internal error occurred in module ../sqlcomp/
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.
*** ERROR[1001] An internal error occurred in module ../sqlcomp/
SQL>
Changed in trafodion: | |
assignee: | nobody → Cliff Gray (cliff-gray) |
Changed in trafodion: | |
milestone: | none → r1.2 |
DB__ROOT user is able to create the view, but encounters an error during delete (see Bug #1439319)