Re: Atomic operations?

On Wed, 19 Mar 2008, Dave Cramer wrote:

>
> On 18-Mar-08, at 7:18 PM, Oliver Jowett wrote:
>
>> Actually it's fine the implicit transaction created by the server to
>> support autocommit wraps both queries in a single transaction and does not
>> commit/rollback until the end of the second query.
>>
> Yeah, using v3 protocol this is presented as one prepare/execute. Thanks for
> catching that.

For the record, v2 sends both statements in a single query message
grouping them in the same transaction.  v3 sends a prepare and execute for
each statement (as required by the extended query protocol), but the
transaction is demarcated by the Sync message and there's only one of
those.

Kris Jurka