Update Multiple Columns SQL
---------------------------
Key: DERBY-4099
URL: https://issues.apache.org/jira/browse/DERBY-4099
Project: Derby
Issue Type: Bug
Components: SQL
Reporter: Meenakshi Sundar Sitaraman
Priority: Critical
When I try to execute the following query
update table_name set n1=5, average=(n1+n2)/2 where ....
The new value of n1 (viz. 5 in this case) is not used when calculating the
average. While the new value of n1 is used in MySQL, the old value is used in
Derby.
Appreciate your support in resolving this issue.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
