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 "Aaron Digulla (JIRA)" <ji...@apache.org> on 2009/03/04 15:59:56 UTC
[jira] Commented: (DERBY-4074) Allow UPDATE TABLE SET (col1,col2) =
(SELECT a,b FROM ...) syntax
[ https://issues.apache.org/jira/browse/DERBY-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12678753#action_12678753 ]
Aaron Digulla commented on DERBY-4074:
--------------------------------------
Okay guys, I've been able to work around most of my test cases but now, I've run into a case where I have about 50 columns. Can someone tell me if this is planned for 10.5 or whether it makes sense for me to try to implement this one?
> Allow UPDATE TABLE SET (col1,col2) = (SELECT a,b FROM ...) syntax
> -----------------------------------------------------------------
>
> Key: DERBY-4074
> URL: https://issues.apache.org/jira/browse/DERBY-4074
> Project: Derby
> Issue Type: New Feature
> Reporter: Aaron Digulla
>
> Please extend the UPDATE statement to allow this syntax:
> UPDATE table SET (col1,col2) = (SELECT a,b FROM othertable)
> This is especially useful when I need to group in the SELECT.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
Re: [jira] Commented: (DERBY-4074) Allow UPDATE TABLE SET (col1,col2)
= (SELECT a,b FROM ...) syntax
Posted by Myrna van Lunteren <m....@gmail.com>.
On Wed, Mar 4, 2009 at 6:59 AM, Aaron Digulla (JIRA) <ji...@apache.org> wrote:
> Aaron Digulla commented on DERBY-4074:
> --------------------------------------
>
> Okay guys, I've been able to work around most of my test cases but now, I've run into a case where I have about 50 columns. Can someone tell me if this is planned for 10.5 or whether it makes sense for me to try to implement this one?
>
>> Allow UPDATE TABLE SET (col1,col2) = (SELECT a,b FROM ...) syntax
Hi Aaron,
No one's said they'd like to work on it yet, so it's not on the roll
for 10.5 at the moment.
I plan to create the 10.5 branch in 12 days - which means cut-off
point for new functionality - and I suspect it would be a stretch for
you to get this implemented before then; just the paperwork - we'd
request you to file an ICLA - would take a couple of days.
However, there have already been ideas bantered around for a release
after 10.5, it would be wonderful if you could implement this for that
release.
To get started, see:
http://wiki.apache.org/db-derby/ForNewDevelopers
And:
http://wiki.apache.org/db-derby/DerbyContributorChecklist
Regards,
Myrna