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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2008/11/20 18:36:45 UTC

[jira] Created: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Generated columns are not recalculated when you update a column through an updatable ResultSet.
-----------------------------------------------------------------------------------------------

                 Key: DERBY-3957
                 URL: https://issues.apache.org/jira/browse/DERBY-3957
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.5.0.0
            Reporter: Rick Hillegas


ResultSet.updateXXX() does not update a generated column when you update one of the columns it depends on.



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Closed: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas closed DERBY-3957.
--------------------------------

    Resolution: Fixed

Operator error. I was not calling ResultSet.updateRow() and ResultSet.insertRow() before committing. Will write some more tests to verify that the behavior is correct.

> Generated columns are not recalculated when you update a column through an updatable ResultSet.
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3957
>                 URL: https://issues.apache.org/jira/browse/DERBY-3957
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>
> ResultSet.updateXXX() does not update a generated column when you update one of the columns it depends on.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Assigned: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas reassigned DERBY-3957:
------------------------------------

    Assignee: Rick Hillegas

> Generated columns are not recalculated when you update a column through an updatable ResultSet.
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3957
>                 URL: https://issues.apache.org/jira/browse/DERBY-3957
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>
> ResultSet.updateXXX() does not update a generated column when you update one of the columns it depends on.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Reopened: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas reopened DERBY-3957:
----------------------------------


> Generated columns are not recalculated when you update a column through an updatable ResultSet.
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3957
>                 URL: https://issues.apache.org/jira/browse/DERBY-3957
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>
> ResultSet.updateXXX() does not update a generated column when you update one of the columns it depends on.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Resolved: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas resolved DERBY-3957.
----------------------------------

    Resolution: Invalid

> Generated columns are not recalculated when you update a column through an updatable ResultSet.
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3957
>                 URL: https://issues.apache.org/jira/browse/DERBY-3957
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>
> ResultSet.updateXXX() does not update a generated column when you update one of the columns it depends on.

-- 
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-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by Kristian Waagan <Kr...@Sun.COM>.
Rick Hillegas wrote:
> Thanks, Kristian. This went better with your advice and another slug 
> of coffee.

Glad to hear I could be of help, Rick.
Now all that's left is to close the issue :)

Note that you can combine the resolve and close step by selecting close 
on an unresolved issue.


-- 
Kristian

>
> Cheers,
> -Rick
>
> Kristian Waagan wrote:
>> Rick Hillegas wrote:
>>> Thanks, Kristian. This is a good suggestion. I have to admit, 
>>> though, that I can't seem to figure out how to mark the issue 
>>> invalid--maybe I should drink some more coffee. I have reopened it 
>>> and the only Workflow options I see are "Resolve", "Close", and 
>>> "Start Progress". What's the magic?
>>
>> Click "Resolve" (or "Close"), then choose "Invalid" instead of "Fixed".
>> If you click the question mark next to the pull down menu, you can 
>> also see what the Jira people (?) mean with the different resolution 
>> types.
>>
>>
>> regards,
>

Re: [jira] Commented: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by Rick Hillegas <Ri...@Sun.COM>.
Thanks, Kristian. This went better with your advice and another slug of 
coffee.

Cheers,
-Rick

Kristian Waagan wrote:
> Rick Hillegas wrote:
>> Thanks, Kristian. This is a good suggestion. I have to admit, though, 
>> that I can't seem to figure out how to mark the issue invalid--maybe 
>> I should drink some more coffee. I have reopened it and the only 
>> Workflow options I see are "Resolve", "Close", and "Start Progress". 
>> What's the magic?
>
> Click "Resolve" (or "Close"), then choose "Invalid" instead of "Fixed".
> If you click the question mark next to the pull down menu, you can 
> also see what the Jira people (?) mean with the different resolution 
> types.
>
>
> regards,

Re: [jira] Commented: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by Kristian Waagan <Kr...@Sun.COM>.
Rick Hillegas wrote:
> Thanks, Kristian. This is a good suggestion. I have to admit, though, 
> that I can't seem to figure out how to mark the issue invalid--maybe I 
> should drink some more coffee. I have reopened it and the only 
> Workflow options I see are "Resolve", "Close", and "Start Progress". 
> What's the magic?

Click "Resolve" (or "Close"), then choose "Invalid" instead of "Fixed".
If you click the question mark next to the pull down menu, you can also 
see what the Jira people (?) mean with the different resolution types.


regards,
-- 
Kristian

>
> Thanks,
> -Rick
>
> Kristian Waagan (JIRA) wrote:
>>     [ 
>> https://issues.apache.org/jira/browse/DERBY-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12649629#action_12649629 
>> ]
>> Kristian Waagan commented on DERBY-3957:
>> ----------------------------------------
>>
>> Not really important at all, except for the quality of the Jira issue 
>> reports, but shouldn't this issue be resolved as "Invalid" due to the 
>> operator error?
>>
>> Fixed - A fix for this issue is checked into the tree and tested. 
>> Invalid - The problem isn't valid and it can't be fixed.
>>
>>  
>>> Generated columns are not recalculated when you update a column 
>>> through an updatable ResultSet.
>>> ----------------------------------------------------------------------------------------------- 
>>>
>>>
>>>                 Key: DERBY-3957
>>>                 URL: https://issues.apache.org/jira/browse/DERBY-3957
>>>             Project: Derby
>>>          Issue Type: Bug
>>>          Components: SQL
>>>    Affects Versions: 10.5.0.0
>>>            Reporter: Rick Hillegas
>>>            Assignee: Rick Hillegas
>>>
>>> ResultSet.updateXXX() does not update a generated column when you 
>>> update one of the columns it depends on.
>>>     
>>
>>   
>

Re: [jira] Commented: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by Rick Hillegas <Ri...@Sun.COM>.
Thanks, Kristian. This is a good suggestion. I have to admit, though, 
that I can't seem to figure out how to mark the issue invalid--maybe I 
should drink some more coffee. I have reopened it and the only Workflow 
options I see are "Resolve", "Close", and "Start Progress". What's the 
magic?

Thanks,
-Rick

Kristian Waagan (JIRA) wrote:
>     [ https://issues.apache.org/jira/browse/DERBY-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12649629#action_12649629 ] 
>
> Kristian Waagan commented on DERBY-3957:
> ----------------------------------------
>
> Not really important at all, except for the quality of the Jira issue reports, but shouldn't this issue be resolved as "Invalid" due to the operator error?
>
> Fixed - A fix for this issue is checked into the tree and tested. 
> Invalid - The problem isn't valid and it can't be fixed.
>
>   
>> Generated columns are not recalculated when you update a column through an updatable ResultSet.
>> -----------------------------------------------------------------------------------------------
>>
>>                 Key: DERBY-3957
>>                 URL: https://issues.apache.org/jira/browse/DERBY-3957
>>             Project: Derby
>>          Issue Type: Bug
>>          Components: SQL
>>    Affects Versions: 10.5.0.0
>>            Reporter: Rick Hillegas
>>            Assignee: Rick Hillegas
>>
>> ResultSet.updateXXX() does not update a generated column when you update one of the columns it depends on.
>>     
>
>

[jira] Commented: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12649629#action_12649629 ] 

Kristian Waagan commented on DERBY-3957:
----------------------------------------

Not really important at all, except for the quality of the Jira issue reports, but shouldn't this issue be resolved as "Invalid" due to the operator error?

Fixed - A fix for this issue is checked into the tree and tested. 
Invalid - The problem isn't valid and it can't be fixed.

> Generated columns are not recalculated when you update a column through an updatable ResultSet.
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3957
>                 URL: https://issues.apache.org/jira/browse/DERBY-3957
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>
> ResultSet.updateXXX() does not update a generated column when you update one of the columns it depends on.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Closed: (DERBY-3957) Generated columns are not recalculated when you update a column through an updatable ResultSet.

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas closed DERBY-3957.
--------------------------------


> Generated columns are not recalculated when you update a column through an updatable ResultSet.
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3957
>                 URL: https://issues.apache.org/jira/browse/DERBY-3957
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>
> ResultSet.updateXXX() does not update a generated column when you update one of the columns it depends on.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.