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:19:12 UTC
[jira] [Created] (TRAFODION-960) LP Bug: 1415248 - Update stats
does not work for a volatile table
Alice Chen created TRAFODION-960:
------------------------------------
Summary: 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: Anoop Sharma
Priority: Critical
Fix For: 2.0-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)