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:

 

VER-31829

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?

 

Thanks,

 

  --Sharon

 

Comments

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

     

     

    -Regards, 

     Sruthi

Leave a Comment

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