Re: [Sqlalchemy-tickets] [sqlalchemy] #1350: SET IMPLICIT_TRANSACTIONS OFF breaks MSSQL when using
Brought to you by:
zzzeek
Menu
▾
▴
Re: [Sqlalchemy-tickets] [sqlalchemy] #1350: SET IMPLICIT_TRANSACTIONS OFF breaks MSSQL when using FreeTDS
|
From: sqlalchemy <mi...@zz...> - 2009-03-26 20:46:42
|
#1350: SET IMPLICIT_TRANSACTIONS OFF breaks MSSQL when using FreeTDS
-----------------------------------------+----------------------------------
Reporter: zzzeek | Owner: ram
Type: defect | Status: new
Priority: high | Milestone: 0.5.xx
Component: mssql | Severity: major - 1-3 hours
Resolution: | Keywords:
Status_field: needs questions answered |
-----------------------------------------+----------------------------------
Comment (by empty):
That code was added to fix savepoint support. One of the problems with
MSSQL with Implicit Transactions is that it only gets turned on once a DML
statement gets executed. Unfortunately issuing a savepoint doesn't turn
on
the implicit transaction. Therefore we were in a situation where there
was
no begin transaction, but there was a savepoint issued.
Thread of discussion here
[http://groups.google.com/group/sqlalchemy/browse_thread/thread/21ae6f7ed2686319#]
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1350#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python |