update statistics for volatile table returns ERROR[4082]

Bug #1327402 reported by Julie Thai
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
New
Medium
Barry Fritchman

Bug Description

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;

Tags: sql-cmp
information type: Proprietary → Public
Changed in trafodion:
assignee: nobody → Barry Fritchman (barry-fritchman)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.