Open transaction timeout setting does not end transaction properly.
说明
Open transaction timeout setting does not end transaction properly. If the user sets the Open transaction timeout to 5 seconds, even after 5 seconds, the transaction time for the query will continue to increase. Users have to cancel the running query manually.
Steps to replicate
1. In the Editor, type in 2 queries example: select * from sys.dba_objects and select * from dual
2. In Tools | Options | Editor | General > limit number of rows to initially fetch in data tab to something small like 40 since customer only wants to view 40.
3. Execute F9 or even F5 select * from sys.dba_objects Issue - at the bottom of the TDA window to the right of the AutoCommit icons there is a timing that shows the transaction running. The transaction time will continue to increase.
4. Go to Tools | Options | Database | Timeouts -- set the Open transaction timeout to 5, 10 or even 30 seconds but it has no effect.
解决办法
WORKAROUND: User will have to manually cancel the transaction by clicking on the Cancel X icon on the toolbar.
STATUS: Waiting for fix in a future release of Toad for Data Analysts.
