db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject Need guidance in writing test for (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 Fri, 05 Aug 2011 23:24:10 GMT
Where in the testing packages should this type of test go.  The RestrictedVTI is tested as
part of "org.apache.derbyTesting.functionTests.tests.lang" but this really is an API test,
not a language test.  So where would the appropriate place be?
________________________________________
From: Brett Bergquist (JIRA) [jira@apache.org]
Sent: Tuesday, August 02, 2011 9:41 AM
To: derby-dev@db.apache.org
Subject: [jira] [Created] (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

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


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