db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Büsch (JIRA) <j...@apache.org>
Subject [jira] Created: (DERBY-4178) Multiple columns update provide update values from select statement
Date Wed, 22 Apr 2009 09:13:47 GMT
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


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.


Mime
View raw message