You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2016/05/31 18:10:12 UTC
[jira] [Assigned] (TRAFODION-960) LP Bug: 1415248 - Update stats
does not work for a volatile table
[ https://issues.apache.org/jira/browse/TRAFODION-960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anoop Sharma reassigned TRAFODION-960:
--------------------------------------
Assignee: David Wayne Birdsall (was: Anoop Sharma)
> LP Bug: 1415248 - Update stats does not work for a volatile table
> -----------------------------------------------------------------
>
> Key: TRAFODION-960
> URL: https://issues.apache.org/jira/browse/TRAFODION-960
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Weishiun Tsai
> Assignee: David Wayne Birdsall
> Priority: Critical
> Fix For: 2.1-incubating
>
>
> Update statistics currently does not work for a volatile table, as shown in the following example. It has trouble handling SB_HISTOGRAMS in a volatile schema and returns error 4082 right now.
> This is seen on the v1.0.0 rc2 build:
> ----------------------------------------------------------
> Here is the entire script to reproduce this problem:
> create schema mytest;
> set schema mytest;
> create volatile table myvtbl (c1 int, c2 int);
> insert into myvtbl values (1, 1);
> update statistics for table myvtbl on every column;
> drop schema mytest cascade;
> ----------------------------------------------------------
> Here is the execution output:
> >>set schema mytest;
> --- SQL operation complete.
> >>create volatile table myvtbl (c1 int, c2 int);
> --- SQL operation complete.
> >>insert into myvtbl values (1, 1);
> --- 1 row(s) inserted.
> >>update statistics for table myvtbl on every column;
> *** ERROR[9200] UPDATE STATISTICS for table TRAFODION.VOLATILE_SCHEMA_MXID110000100932122891606570214610000000002.MYVTBL encountered an error (4082) from statement .
> *** ERROR[4082] Object TRAFODION.VOLATILE_SCHEMA_MXID110000100932122891606570214610000000002.SB_HISTOGRAMS does not exist or is inaccessible.
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors.
> >>drop schema mytest cascade;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)