fixed bug where updte with no result would not auto_commit and locked table