We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Analyze_statistics Auto-commit — Vertica Forum

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