You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Marcel Büsch (JIRA)" <ji...@apache.org> on 2009/04/22 11:13:47 UTC
[jira] Created: (DERBY-4178) Multiple columns update provide update
values from select statement
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.
[jira] Updated: (DERBY-4178) Multiple columns update provide update
values from select statement
Posted by "Marcel Büsch (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Marcel Büsch updated DERBY-4178:
--------------------------------
Attachment: DerbyMultipleColumnsUpdateTest.java
A litle programm showing the case
> 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.
[jira] Resolved: (DERBY-4178) Multiple columns update provide
update values from select statement
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (DERBY-4178) Multiple columns update provide
update values from select statement
Posted by "Marcel Büsch (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12701462#action_12701462 ]
Marcel Büsch commented on DERBY-4178:
-------------------------------------
Yes. Your right. I didn't find DERBY-4074 when I looked for it. I'm sorry about that.
> 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.