db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <derby-...@db.apache.org>
Subject [jira] Resolved: (DERBY-45) Request support for CAST() in Like clause
Date Fri, 12 Nov 2004 18:30:24 GMT
     [ 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:
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:
>  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:
If you want more information on JIRA, or have a bug to report see:

View raw message