db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Meenakshi Sundar Sitaraman (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4099) Update Multiple Columns SQL
Date Tue, 17 Mar 2009 10:36:50 GMT
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.

View raw message