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)