You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2016/09/14 18:16:21 UTC
[jira] [Created] (TRAFODION-2223) INC UPD STATS: an invalid WHERE
predicate results in an internal error
David Wayne Birdsall created TRAFODION-2223:
-----------------------------------------------
Summary: INC UPD STATS: an invalid WHERE predicate results in an internal error
Key: TRAFODION-2223
URL: https://issues.apache.org/jira/browse/TRAFODION-2223
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Environment: Probably all
Reporter: David Wayne Birdsall
Assignee: David Wayne Birdsall
An invalid WHERE predicate on an incremental update statistics command results in an internal error. Here is an example from regression test compGeneral/TEST023. We should give a cleaner error here.
>>update statistics for table stest on existing columns incremental where 1;
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (15001) from statement HSCursor::prepareRowsetInternal().
*** ERROR[15001] A syntax error occurred at or before:
SELECT "C1", "C2", "C3", "_SALT_" FROM TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPL
E_53_1473872773_525053 WHERE 1 FOR READ UNCOMMITTED ACCESS;
^ (120 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (15001) from statement POPULATE_FROM_QUERY.
*** ERROR[15001] A syntax error occurred at or before:
SELECT "C1", "C2", "C3", "_SALT_" FROM TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPL
E_53_1473872773_525053 WHERE 1 FOR READ UNCOMMITTED ACCESS;
^ (120 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
--- SQL operation failed with errors.
>>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)