Subject | Strange behavior with update |
---|---|
Author | c_pradelli |
Post date | 2003-04-29T15:29:15Z |
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
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