Subject Re: [firebird-support] Exchange two column values in a single statement...
Author Dmitry Yemanov
Svein Erling Tysvaer wrote:
> I'm surprised that things are evaluated left to right and that a and b
> have changing values. Intuitively, without looking at any SQL standard
> or thinking too deeply, I'd rather expect
> update t1 set a = b, b = a
> to swap the values of two fields and a and b to be 'static' - always
> referring to the old value of a or b - when on the right side of an
> assignment.
> Will the next FB version behave this way?

Yes, as your understanding is exactly standard compliant while the
current behaviour is definitely not.