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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2011/05/13 15:02:47 UTC
[jira] [Created] (DERBY-5231) Restriction.ColumnQualifier.toSQL()
should quote string constants and handle time constants better
Restriction.ColumnQualifier.toSQL() should quote string constants and handle time constants better
--------------------------------------------------------------------------------------------------
Key: DERBY-5231
URL: https://issues.apache.org/jira/browse/DERBY-5231
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.9.0.0
Reporter: Rick Hillegas
Restriction generates
select x, y, x from foo where ( name = bar)
rather than
select x, y, x from foo where ( name = 'bar' )
Similar problems probably plague other non-numeric constants.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5231) Restriction.ColumnQualifier.toSQL()
should quote string constants and handle time constants better
Posted by "Mamta A. Satoor (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mamta A. Satoor updated DERBY-5231:
-----------------------------------
Urgency: Normal
Labels: derby_triage10_9 (was: )
> Restriction.ColumnQualifier.toSQL() should quote string constants and handle time constants better
> --------------------------------------------------------------------------------------------------
>
> Key: DERBY-5231
> URL: https://issues.apache.org/jira/browse/DERBY-5231
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.9.0.0
> Reporter: Rick Hillegas
> Labels: derby_triage10_9
>
> Restriction generates
> select x, y, x from foo where ( name = bar)
> rather than
> select x, y, x from foo where ( name = 'bar' )
> Similar problems probably plague other non-numeric constants.
--
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-5231) Restriction.ColumnQualifier.toSQL()
should quote string constants and handle time constants better
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13033032#comment-13033032 ]
Rick Hillegas commented on DERBY-5231:
--------------------------------------
This bug was identified in the following email discussion on derby-user: http://old.nabble.com/Limitations-of-org.apache.derby.vti.Restriction-classes-to31610180.html#a31610180
> Restriction.ColumnQualifier.toSQL() should quote string constants and handle time constants better
> --------------------------------------------------------------------------------------------------
>
> Key: DERBY-5231
> URL: https://issues.apache.org/jira/browse/DERBY-5231
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.9.0.0
> Reporter: Rick Hillegas
>
> Restriction generates
> select x, y, x from foo where ( name = bar)
> rather than
> select x, y, x from foo where ( name = 'bar' )
> Similar problems probably plague other non-numeric constants.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira