|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
all platforms
|
|
| Resolution Date: |
12/Nov/04 06:28 PM
|
|
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
|
|
Description
|
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 |
Show » |
|
Improvement
Closed
Major
Request support for CAST() in Like clause
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.