Subject Strange behavior with update
Author c_pradelli
Hello!

I don't know if this is working as designed.

if you execute and update:

UPDATE MYTABLE SET FIELD1=FIELD1+1, FIELD2=(FIELD2+10)/(FIELD1+1)

FIELD1=FIELD1+1 portion is done with the original value of FIELD1.

but

FIELD2=(FIELD2+10)/(FIELD1+1) portion is done with the new value of
FIELD1 (FIELD1+1)

is this ok?
shouldn't be all UPDATE sentence with the original values of the
fields?

Regards
Christian