[
https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13078305#comment-13078305
]
Brett Bergquist commented on DERBY-5370:
----------------------------------------
I would add a test case but I am just learning my way around the code now. It
may be a bit before I can figure out what I need to do but I can give it a
shot. It will be useful to learn a bit more about the testing framework.
> 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
