[TRAFODION-2223] INC UPD STATS: an invalid WHERE predicate results in an internal error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1-incubating
• Component/s: sql-cmp
• Environment: Probably all
• Assignee: Dave Birdsall
• Reporter: Dave Birdsall
• Created: 14/Sep/16 18:16
• Updated: 15/Sep/18 07:32
• Resolved: 22/Sep/16 22:22

Description

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.
>>

Issue Links

• links to: GitHub Pull Request #719