[DERBY-171] Need Correlation ID in UPDATE/DELETE statements

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.2.1
• Fix Version/s: 10.2.1.6
• Component/s: SQL
• Environment: Windows XP SP1 Professional
• Assignee: Richard N. Hillegas
• Reporter: George Baklarz
• Created: 11/Mar/05 01:39
• Updated: 20/Mar/07 21:53
• Resolved: 11/Aug/05 10:13

Description

You currently can't use a correlation ID in an UPDATE/DELETE statement. This makes it cumbersome to do the following:

UPDATE EMPLOYEE_BONUS
SET BONUS = (SELECT SUM(BONUSES.BONUS) FROM BONUSES WHERE
EMPLOYEE_BONUS.EMPL_ID = BONUSES.EMPL_ID);

The use of a correlation ID makes this easier to code.

UPDATE EMPLOYEE E
SET BONUS = (SELECT SUM(B.BONUS) FROM BONUSES B WHERE B.EMPL_ID = E.EMPL_ID);

This is particularly important if you get carried away with long SCHEMA and TABLE names!

Issue Links

• blocks: DERBY-156 Delete with alias on column fails