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 06:54:46 UTC
[jira] [Resolved] (TRAFODION-356) LP Bug: 1327402 - update
statistics for volatile table returns ERROR[4082]
[ https://issues.apache.org/jira/browse/TRAFODION-356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah resolved TRAFODION-356.
--------------------------------------
Resolution: Duplicate
> LP Bug: 1327402 - update statistics for volatile table returns ERROR[4082]
> --------------------------------------------------------------------------
>
> Key: TRAFODION-356
> URL: https://issues.apache.org/jira/browse/TRAFODION-356
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Julie Thai
> Assignee: Barry Fritchman
>
> Update statistics for volatile table returns ERROR[4082].
> updstats appears to assume schema is seabase.
> Encountered on RC1_0603.
> Trafodion Conversational Interface 0.8.0
> (c) Copyright 2014 Hewlett-Packard Development Company, LP.
> >>get schemas;
> Schemas in Catalog TRAFODION
> ============================
> SEABASE
> _MD_
> --- SQL operation complete.
> >>create schema testsch;
> --- SQL operation complete.
> >>set schema testsch;
> --- SQL operation complete.
> >>create table f00(a int, b int);
> --- SQL operation complete.
> >>create volatile table f00 (c int);
> --- SQL operation complete.
> >>insert into f00 values (1);
> --- 1 row(s) inserted.
> >>insert into f00 values (2,2);
> *** ERROR[4023] The degree of each row value constructor (2) must equal the degree of the target table column list (1).
> *** ERROR[8822] The statement was not prepared.
> >>insert into testsch.f00 values (3,3);
> --- 1 row(s) inserted.
> >>show session;
> ----------------------------------
> Current Environment
> ----------------------------------
> CURRENT DIRECTORY /opt/home/thaiju/datalake_64_1
> LIST_COUNT 4294967295
> LOG FILE
> MESSAGEFILE /opt/home/thaiju/datalake_64_1/export/bin64/mxcierrors.cat
> TERMINAL CHARSET ISO88591
> MESSAGEFILE LANG US English
> MESSAGEFILE VRSN {2014-06-03 16:46 LINUX:RHEL-MAPR5/jenkins}
> SQL USER NAME DB__ROOT
> SQL USER ID 33333
> SQL CATALOG TRAFODION
> SQL SCHEMA TESTSCH
> TRANSACTION ID
> TRANSACTION STATE not in progress
> WARNINGS on
> >>drop table f00;
> --- SQL operation complete.
> >>insert into f00 values (4);
> *** ERROR[4023] The degree of each row value constructor (1) must equal the degree of the target table column list (2).
> *** ERROR[8822] The statement was not prepared.
> >>drop table testsch.f00;
> --- SQL operation complete.
> >>create volatile table f00 ( c int);
> --- SQL operation complete.
> >>insert into f00 values (1);
> --- 1 row(s) inserted.
> >>insert into f00 values (10), (100), (1000);
> --- 3 row(s) inserted.
> >>update statistics for table f00 on every column;
> *** ERROR[4082] Object TRAFODION.TESTSCH.F00 does not exist or is inaccessible.
> *** ERROR[4082] Object TRAFODION.TESTSCH.F00 does not exist or is inaccessible.
> *** ERROR[4082] Object TRAFODION.TESTSCH.F00 does not exist or is inaccessible.
> --- SQL operation failed with errors.
> To reproduce in sqlci/trafci, issue:
> create volatile table f00 (c int);
> insert into f00 values (1), (10), (100), (1000);
> update statistics for table f00 on every column;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)