[TORQUE-222] Change unlock table behaviour in MSSQL

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0-beta1
• Component/s: Runtime
• Assignee: Thomas Fox
• Reporter: Thomas Fox
• Created: 29/Aug/12 03:31
• Updated: 24/Sep/12 07:06
• Resolved: 29/Aug/12 03:43

Description

Cunnently, the MSSQL implementation of unlockTable issues a commit, which actually releases all locks on all tables. It also has a few problems:

• if the user wanted a rollback instead of a commit, it will not be possible because a commit has already been issued previously
• if the connection is in autocommit mode, unlock will throw an error.

The unlock table implementation in MSSQL should be changed to do nothing.