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] [Commented] (DERBY-5370) The toSQL method of the org.apache.derby.vti.Restriction class does not output correct constants for VARCHAR, Timestamp, Date, Time, or CHAR FOR BIT DATA types
Date Tue, 23 Aug 2011 13:36:29 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13089463#comment-13089463
] 

Rick Hillegas commented on DERBY-5370:
--------------------------------------

Attaching derby-5370-02-aa-disableOnJSR169.diff. This patch disables the new test on JSR169
platforms. Committed to trunk at subversion revision 1160680.

The new test relies on a table function which extends org.apache.derby.vti.VTITemplate, an
implementation of the JDBC 3.0 ResultSet. JDBC 3.0 ResultSets pull in classes which do not
exist on the small JSR169 platform, resulting in ClassNotFoundExceptions during method resolution.

Kathey noticed that the new test case fails on weme. She posted her findings in this derby-dev
thread: http://old.nabble.com/weme-failures-with-a-sane-build-to32316105.html#a32316105

Touches the following file:

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


> The toSQL method of the org.apache.derby.vti.Restriction class does not output correct
constants for VARCHAR, Timestamp, Date, Time, or CHAR FOR BIT DATA types
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5370
>                 URL: https://issues.apache.org/jira/browse/DERBY-5370
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.8.1.2
>            Reporter: Brett Bergquist
>         Attachments: derby-5370-01-aa-withTest.diff, derby-5370.diff
>
>
> The toSQL method of the org.apache.derby.vti.Restriction class does not output correct
constants for VARCHAR, Timestamp, Date, Time, or CHAR FOR BIT DATA types.  This method is
useful for building the WHERE clause when implementing a Restricted Table Function.  The result
of calling the toSQL method with restrictions on columns of these types does not produce valid
SQL constants.  For example with a VARCHAR column being restricted the single quote characters
are not placed round the string constant.

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

        

Mime
View raw message