[ 
https://issues.apache.org/jira/browse/TRAFODION-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15504373#comment-15504373
 ] 

David Wayne Birdsall commented on TRAFODION-2223:
-------------------------------------------------

While we are at it, there are some clean-ups we can do on the IUS code as well.

For example, there are several warning messages (9222-9230) which signal 
variations in code path in IUS processing. These would be better as logging 
messages rather than warnings.

For another example, there is a CQD USTAT_IUS_SIMPLE_SYNTAX that could be 
removed and the grammar logic simplified as a result.


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

Reply via email to