[
https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13078316#comment-13078316
]
Rick Hillegas commented on DERBY-5370:
--------------------------------------
Thanks for that quick response, Brett. In case you haven't stumbled across this
material yet, a good place to start is
http://wiki.apache.org/db-derby/DerbyTesting . RestrictedVTITest is a JUnit
test so the material on JUnit testing is particularly relevant.
> 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.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
