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.


Dmitry