ERROR[9200] and ERROR[1230] during update stats in private schema
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Released
|
Medium
|
Roberta Marton |
Bug Description
User creates private schema and table. Update stats on the table returns an error. There is a second error that returns saying the object owner must be the schema owner, but the user is the schema owner.
SQL>connect USERNAME1/PASSWORD1
Connected to Trafodion
SQL>create schema schema801;
--- SQL operation complete.
SQL>set schema schema801;
--- SQL operation complete.
SQL>create table tab8(a int not null primary key,b int)no partition;
--- SQL operation complete.
SQL>update statistics for table tab8 on every column;
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.
*** ERROR[1230] Object owner must be the schema owner in private schemas.
SQL>showstats for table tab8 on every column;
*** ERROR[1] The message id: problem_
*** ERROR[1] The message id: header_
*** ERROR[1] The message id: problem_
*** ERROR[1] The message id: header_
SQL>
Changed in trafodion: | |
milestone: | none → r1.1 |
Changed in trafodion: | |
assignee: | Cliff Gray (cliff-gray) → Roberta Marton (roberta-marton) |
Changed in trafodion: | |
status: | New → Fix Committed |
Changed in trafodion: | |
status: | Fix Committed → Fix Released |