You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:18:18 UTC
[jira] [Created] (TRAFODION-818) LP Bug: 1401330 - ERROR[9200] and
ERROR[1230] during update stats in private schema
Alice Chen created TRAFODION-818:
------------------------------------
Summary: LP Bug: 1401330 - ERROR[9200] and ERROR[1230] during update stats in private schema
Key: TRAFODION-818
URL: https://issues.apache.org/jira/browse/TRAFODION-818
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Paul Low
Assignee: Roberta Marton
Fix For: 1.1 (pre-incubation)
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.SCHEMA801.TAB8 encountered an error (1230) from statement Create SeaBase histograms table.
*** 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_with_server_read
*** ERROR[1] The message id: header_not_long_enough
*** ERROR[1] The message id: problem_with_server_read
*** ERROR[1] The message id: header_not_long_enough
SQL>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)