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 "Myrna van Lunteren (JIRA)" <de...@db.apache.org> on 2004/11/12 19:30:24 UTC
[jira] Resolved: (DERBY-45) Request support for CAST() in Like clause
[ http://nagoya.apache.org/jira/browse/DERBY-45?page=history ]
Myrna van Lunteren resolved DERBY-45:
-------------------------------------
Resolution: Fixed
patch for fix was submitted with svn revision 57487.
changed file:
java\engine\org\apache\derby\impl\sql\compile\LikeEscapeOperatorNode.java
also requires updates to java\testing\ora\apache\derbyTesting\functionTests\master\LOB.out and dynamicLikeOptimization.out.
> Request support for CAST() in Like clause
> -----------------------------------------
>
> Key: DERBY-45
> URL: http://nagoya.apache.org/jira/browse/DERBY-45
> Project: Derby
> Type: Improvement
> Components: SQL
> Versions: 10.0.2.0
> Environment: all platforms
> Reporter: Lance Andersen
> Assignee: Myrna van Lunteren
>
> Request support for CAST() in like clause for example:
> select t0.ID, t0.QUANTITY, t0.NAME, t0.PRICE, t0.PNUM from PRODUCTEJB_TABLE t0 where t0.NAME like CAST (? AS VARCHAR(32672))
> This is supported by DB2 and will ease migration between DB2 and Derby
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira