db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5369) Restricted Table Function support should pass NOT EQUAL restrictions to initScan
Date Tue, 23 Aug 2011 19:20:29 GMT

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

Rick Hillegas updated DERBY-5369:
---------------------------------

    Attachment: derby-5369-01-aa-inequalityOperator.diff

Attaching derby-5369-01-aa-inequalityOperator.diff. This adds a test case to Brett's patch
and touches up the javadoc for RestrictedVTI. Committed at subversion revision 1160858.

Touches the following file:

---------------

M      java/engine/org/apache/derby/impl/sql/compile/FromVTI.java
M      java/engine/org/apache/derby/vti/Restriction.java

Brett's original patch.

---------------

M      java/engine/org/apache/derby/vti/RestrictedVTI.java

Touched up the javadoc to say that != is a supported operator.

---------------

M      java/testing/org/apache/derbyTesting/functionTests/tests/lang/RestrictedVTITest.java

Test case for the != operator.


> Restricted Table Function support should pass NOT EQUAL restrictions to initScan
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-5369
>                 URL: https://issues.apache.org/jira/browse/DERBY-5369
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.8.1.2
>            Reporter: Brett Bergquist
>              Labels: features
>         Attachments: derby-5369-01-aa-inequalityOperator.diff, derby-5369.diff
>
>
> Restricted Table Function support should pass NOT EQUAL restrictions to initScan.  Currently
any "!=" or "<>" constraints on the SQL used in the WHERE clause of a SELECT on a Restricted
Table Funtion are not passed to the initScan method.  These can be useful depending on how
the Restricted Table Function is implemented.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message