[
https://issues.apache.org/jira/browse/TRAFODION-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-2223.
---------------------------------------------
Resolution: Fixed
Fix Version/s: 2.1-incubating
> 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
> Fix For: 2.1-incubating
>
>
> 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)
