[jira] [Assigned] (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
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden reassigned DERBY-5370: - Assignee: Brett Bergquist (was: Rick Hillegas) Assigning this issue to Brett who contributed the patch. Actually it was a collaboration as Rick Wrote the test > 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 >Assignee: 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. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (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
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden reassigned DERBY-5370: - Assignee: Rick Hillegas > 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 >Assignee: Rick Hillegas > 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. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
