On Mar 24, 2:40 pm, "Michael Bayer" <[email protected]> wrote:
> what if you create the same table on a totally new database and run it
> there ?
Good idea. I'll try that momentarily.
In the meantime, I tried out wireshark and see that there
is a reliable difference in what is getting sent.
With 0.5.2 what gets sent is this:
Query: set implicit_transactions on
RPC Name: sp_datatype_info
Query: SET IMPLICIT_TRANSACTIONS OFF
Query: BEGIN TRANSACTION
Query: INSERT INTO sa_test (data, time) VALUES ('bingo',
'2009-03-24 14:57:58')
Query: IF @@TRANCOUNT > 0 COMMIT TRAN
Query: SET IMPLICIT_TRANSACTIONS OFF
Query: BEGIN TRANSACTION
Query: SELECT COUNT(*) FROM sa_test WHERE data='bingo'
Query: IF @@TRANCOUNT > 0 ROLLBACK TRAN
With 0.4.8 what gets sent is this:
Query: set implicit_transactions on
RPC Name: sp_datatype_info
Query: INSERT INTO sa_test (data, time) VALUES ('bingo',
'2009-03-24 14:57:58')
Query: IF @@TRANCOUNT > 0 COMMIT TRAN
Query: BEGIN TRANSACTION
Query: SELECT COUNT(*) FROM sa_test WHERE data='bingo'
Query: IF @@TRANCOUNT > 0 ROLLBACK TRAN
Note that with 0.4.8 the TDS data sent relies on
IMPLICIT_TRANSACTIONS being set ON, while
with 0.5.2, this gets turned OFF, and then BEGIN
TRANSACTIONs are sent.
David
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
