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:14:27 UTC
[jira] [Created] (TRAFODION-165) LP Bug: 1270031 - Update
statistics sees errors with certain schema name
Alice Chen created TRAFODION-165:
------------------------------------
Summary: LP Bug: 1270031 - Update statistics sees errors with certain schema name
Key: TRAFODION-165
URL: https://issues.apache.org/jira/browse/TRAFODION-165
Project: Apache Trafodion
Issue Type: Bug
Components: sql-general
Reporter: Weishiun Tsai
Assignee: Hans Zeller
Priority: Critical
Update statistics sees errors on a 10-row table with index. The strange thing is that it only happens when the table is created using certain schema name. In the following example, the first part shows that the commands ran fine when the schema name was trafodion.mytest. The second part shows that the same sequence of commands encountered error 9200/8411/8839/8609 at the update statistics statement when the schema name was trafodion.arkcase_arkt0025.
The build is the beta build trafodion-ci-release-trafodion_beta-20140115-v36803_release.tar running on a workstation.
-bash-4.1$ sqlci
Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
>>set schema trafodion.mytest;
--- SQL operation complete.
>>
>>create table t (pic_x_a PIC X(3) not null not droppable, pic_x_b PIC X(1) not null not droppable, pic_x_c PIC X(2) not null not droppable, PRIMARY KEY(pic_x_c, pic_x_b, pic_x_a) not droppable);
--- SQL operation complete.
>>create index ta ON t ( pic_x_a );
--- SQL operation complete.
>>insert into t values ('jo','Z','jo'),('al','Q','al'),('P','P','P'),('B','A','ed'),('jo','C','ek'),('JO','D','em'),('al','E','bo'),(' al','F','di'),('al ','F','al'),(' al','F','al');
--- 10 row(s) inserted.
>>update statistics for table t on every column;
--- SQL operation complete.
>>
>>drop table t cascade;
--- SQL operation complete.
>>
>>set schema trafodion.arkcase_arkt0025;
--- SQL operation complete.
>>
>>create table t (pic_x_a PIC X(3) not null not droppable, pic_x_b PIC X(1) not null not droppable, pic_x_c PIC X(2) not null not droppable, PRIMARY KEY(pic_x_c, pic_x_b, pic_x_a) not droppable);
--- SQL operation complete.
>>create index ta ON t ( pic_x_a );
--- SQL operation complete.
>>insert into t values ('jo','Z','jo'),('al','Q','al'),('P','P','P'),('B','A','ed'),('jo','C','ek'),('JO','D','em'),('al','E','bo'),(' al','F','di'),('al ','F','al'),(' al','F','al');
--- 10 row(s) inserted.
>>update statistics for table t on every column;
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.ARKCASE_ARKT0025.T encountered an error (8411) from statement HSinsertHistint::flush().
*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:4599332999182373.267 to Target Type:LARGEINT(REC_BIN64_SIGNED).
*** ERROR[8839] Transaction was aborted.
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.ARKCASE_ARKT0025.T encountered an error (8411) from statement FLUSH_STATISTICS.
*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:4599332999182373.267 to Target Type:LARGEINT(REC_BIN64_SIGNED).
*** ERROR[8839] Transaction was aborted.
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.ARKCASE_ARKT0025.T encountered an error (8609) from statement Process_Query.
*** ERROR[8609] Waited rollback performed without starting a transaction.
--- SQL operation failed with errors.
>>
>>drop table t cascade;
--- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)