You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Brett Bergquist (JIRA)" <ji...@apache.org> on 2011/08/02 15:41:27 UTC
[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
[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
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ 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
[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
Posted by "Kathey Marsden (Assigned) (JIRA)" <ji...@apache.org>.
[ 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] [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
Posted by "Brett Bergquist (JIRA)" <ji...@apache.org>.
[ 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
[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
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13089034#comment-13089034 ]
Rick Hillegas commented on DERBY-5370:
--------------------------------------
Tests passed cleanly for me. Committed derby-5370-01-aa-withTest.diff to trunk at subversion revision 1160445.
> 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
[jira] [Updated] (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
Posted by "Brett Bergquist (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brett Bergquist updated DERBY-5370:
-----------------------------------
Attachment: derby-5370.diff
Patch to output correct constants for the 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
> 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
[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
Posted by "Brett Bergquist (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13076206#comment-13076206 ]
Brett Bergquist commented on DERBY-5370:
----------------------------------------
Actually it is not the column types that matter, but rather constant types that are passed with the SELECT statement WHERE clause that uses a Restricted Table Function. These constant types are not correctly reproduced by the toSQL method.
> 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
[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
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13089043#comment-13089043 ]
Rick Hillegas commented on DERBY-5370:
--------------------------------------
Ported 1160445 from trunk to 10.8 branch at subversion revision 1160455.
> 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
[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
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Updated] (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
Posted by "Kathey Marsden (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-5370:
----------------------------------
Fix Version/s: 10.9.0.0
10.8.2.3
> 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
> Fix For: 10.8.2.3, 10.9.0.0
>
> 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] [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
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13089469#comment-13089469 ]
Rick Hillegas commented on DERBY-5370:
--------------------------------------
Ported 1160680 from trunk to 10.8 branch at subversion revision 1160683.
> 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
[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
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13078304#comment-13078304 ]
Rick Hillegas commented on DERBY-5370:
--------------------------------------
Thanks for the patch, Brett. I think that this should cover the comparable Derby types. Since BLOB and CLOB aren't comparable I don't think we need cases for them. If you want to add a test case to RestrictedVTITest, that would be great. If you don't want to, I will beef up the patch with a test. Thanks.
> 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
[jira] [Updated] (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
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-5370:
---------------------------------
Attachment: derby-5370-01-aa-withTest.diff
Attaching derby-5370-01-aa-withTest.diff. This adds a regression test to Brett's patch. I am running tests now.
Touches the following files:
-----------
M java/engine/org/apache/derby/vti/Restriction.java
Brett's change.
-----------
A java/testing/org/apache/derbyTesting/functionTests/tests/lang/RestrictedTableVTI.java
M java/testing/org/apache/derbyTesting/functionTests/tests/lang/RestrictedVTITest.java
Test case for the improved Restriction.toSQL() method.
> 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
[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
Posted by "Kathey Marsden (Assigned) (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Resolved] (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
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas resolved DERBY-5370.
----------------------------------
Resolution: Fixed
> 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