You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/31 07:36:52 UTC
[jira] [Closed] (TRAFODION-818) LP Bug: 1401330 - ERROR[9200] and
ERROR[1230] during update stats in private schema
[ https://issues.apache.org/jira/browse/TRAFODION-818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-818.
------------------------------------
Resolution: Fixed
Close issues in JIRA to reflect status in LaunchPad
> 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)