ah. so thats a difference. ticket 1350 is added, we'll see what
the MS-SQL crew has to say.
On Mar 24, 2009, at 6:37 PM, davidlmontgomery wrote:
>
> Oops, I messed up the 0.4.8 data as I was
> cutting and pasting.
>
> Corrected, actual data sent by 0.4.8:
>
> Query: set implicit_transactions on
> RPC Name: sp_datatype_info
> Query: INSERT INTO sa_test (data, time) VALUES ('bingo',
> '2009-03-24 15:08:12')
> Query: IF @@TRANCOUNT > 0 COMMIT TRAN
> Query: SELECT COUNT(*) FROM sa_test WHERE data='bingo'
> Query: IF @@TRANCOUNT > 0 ROLLBACK TRAN
>
> So, no BEGIN TRANSACTION (or SET
> IMPLICIT_TRANSACTIONS OFF).
>
> On Mar 24, 3:31 pm, davidlmontgomery <[email protected]>
> wrote:
>> 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
-~----------~----~----~----~------~----~------~--~---
