You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/06/06 16:56:21 UTC
[jira] [Commented] (TRAFODION-2004) Statistics on volatile tables
is not supported
[ https://issues.apache.org/jira/browse/TRAFODION-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15316757#comment-15316757 ]
ASF GitHub Bot commented on TRAFODION-2004:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/509
> Statistics on volatile tables is not supported
> ----------------------------------------------
>
> Key: TRAFODION-2004
> URL: https://issues.apache.org/jira/browse/TRAFODION-2004
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.0-incubating, 1.3-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> The Trafodion SQL Reference Manual on wiki: http://trafodion.apache.org/docs/sql_reference/Trafodion_SQL_Reference_Manual.pdf, Page 119, 'Considerations for CREATE VOLATILE TABLE' explicitly says the following:
> "Statistics are not automatically updated for volatile tables. If you need statistics, you must explicitly run UPDATE STATISTICS."
> However, as shown in the following example, update statistics does not work for volatile tables.
> >>create schema mytest;
> --- SQL operation complete.
> >>set schema mytest;
> --- SQL operation complete.
> >>
> >>create volatile table mytable (a int);
> --- SQL operation complete.
> >>insert into mytable values (1);
> --- 1 row(s) inserted.
> >>select * from mytable;
> A
> -----------
> 1
> --- 1 row(s) selected.
> >>update statistics for table mytable on every column;
> *** ERROR[4082] Object TRAFODION.MYTEST.MYTABLE does not exist or is inaccessible.
> *** ERROR[4082] Object TRAFODION.MYTEST.MYTABLE does not exist or is inaccessible.
> *** ERROR[4082] Object TRAFODION.MYTEST.MYTABLE does not exist or is inaccessible.
> --- SQL operation failed with errors.
> >>
> >>drop volatile table mytable cascade;
> --- SQL operation complete.
> >>drop schema mytest cascade;
> --- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)