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

ASF GitHub Bot commented on TRAFODION-2223:
-------------------------------------------

GitHub user DaveBirdsall opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/719

    [TRAFODION-2223] Improve error reporting on bad incremental WHERE clause

    When an invalid WHERE clause was given on an incremental UPDATE STATISTICS 
command, the error raised was misleading. This has been fixed. As part of this 
change, a new error message, 9219, was added; the Messages Guide has been 
updated.
    
    The prototype code for incremental UPDATE STATISTICS contained an 
alternative syntax, termed the "simple" syntax. A CQD controlled which syntax 
was in force. This alternative syntax and its associated CQD have been removed.
    
    Some error messages that are no longer used have been deleted.
    
    Incremental update statistics includes several warning conditions that are 
uninteresting to the average user. They detail whether incremental update 
statistics simply adjusted existing histograms or computed new ones from the 
sample data. There is no practical difference from a user perspective, so it 
seems wise from a human factors point of view to turn these off. However, if 
update statistics logging is on, the warnings will be raised as this may be of 
interest to a developer or support person.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion2223

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/719.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #719
    
----
commit 25077b5a340d23e6949ef3f976b142b13e63cdf1
Author: Dave Birdsall <dbirds...@apache.org>
Date:   2016-09-21T19:01:12Z

    [TRAFODION-2223] Improve error reporting on bad incremental WHERE clause

----


> 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