[ 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)