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 <davidlmontgom...@gmail.com> > wrote: >> On Mar 24, 2:40 pm, "Michael Bayer" <mike...@zzzcomputing.com> 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 sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---