[
https://issues.apache.org/jira/browse/DERBY-4178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen resolved DERBY-4178.
---------------------------------------
Resolution: Duplicate
I think this is the same issue as DERBY-4074 (Allow UPDATE TABLE SET
(col1,col2) = (SELECT a,b FROM ...) syntax).
> Multiple columns update provide update values from select statement
> -------------------------------------------------------------------
>
> Key: DERBY-4178
> URL: https://issues.apache.org/jira/browse/DERBY-4178
> Project: Derby
> Issue Type: Improvement
> Affects Versions: 10.5.1.1
> Reporter: Marcel Büsch
> Attachments: DerbyMultipleColumnsUpdateTest.java
>
>
> An update query like:
> update location_a a set (name, addr) = (select name, addr from location_b b
> where a.num = b.num) where num = ?
> does raise an sqlexception Syntax error
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
