[ 
https://issues.apache.org/jira/browse/DERBY-3850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Knut Anders Hatlen updated DERBY-3850:
--------------------------------------

    Attachment: d3850-predicatesIntoViews.stat
                d3850-predicatesIntoViews.diff

It turns out that the workaround for bug 4821 in predicatesIntoViews.sql wasn't 
needed anymore. I removed the commit and the test finished in about 15 seconds, 
same as if it ran unchanged. When I reverted the fix for DERBY-3693, the 
modified test needed 4 minutes 15 seconds to finish.

Attaching a patch that removes the workaround from the test and from the canon.

> Remove unneeded workarounds for DERBY-177 and DERBY-3693
> --------------------------------------------------------
>
>                 Key: DERBY-3850
>                 URL: https://issues.apache.org/jira/browse/DERBY-3850
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL, Test
>    Affects Versions: 10.5.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>         Attachments: d3850-predicatesIntoViews.diff, 
> d3850-predicatesIntoViews.stat, d3850-test.diff, d3850-wait.diff, 
> d3850-wait.stat
>
>
> After the fix for DERBY-177 and DERBY-3693 was committed, these code 
> clean-ups could be performed:
>   - remove workaround for DERBY-177 in the tests (search for the string 
> "DERBY-177" to find them)
>   - remove logic to prevent waiting for table locks in 
> SPSDescriptor.updateSYSSTATEMENTS() since the new mechanism will prevent 
> waiting for all types of locks

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

Reply via email to