GitHub user DaveBirdsall opened a pull request:

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

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

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 <>
Date:   2016-09-21T19:01:12Z

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


If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at or file a JIRA ticket
with INFRA.

Reply via email to