Analyze_statistics Auto-commit

It's always been that analyze_statistics() auto-commits.  I've confirmed that this is also still true in 7.1.  


The release notes from 7.0.2-1 have this change in them:



Catalog Engine

The ANALYZE_STATISTICS function incorrectly issued a commit. This issue has been resolved.


Could someone clarifiy what this change was since it analyze_statistics() still auto-commits in 7.1?







  • SruthiASruthiA Vertica Employee Administrator

    Thanks for mentioning about it.  It should be ANALYZE_CONSTRAINTS(). I will open a defect and get it changed in the Release Notes.   analyze_statistics() still auto-commits.





Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file