[DERBY-45] Request support for CAST() in Like clause

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.0
• Fix Version/s: 10.0.2.2
• Component/s: SQL
• Environment: all platforms
• Assignee: Myrna van Lunteren
• Reporter: Lance Andersen
• Created: 18/Oct/04 19:06
• Updated: 04/Jun/05 19:03
• Resolved: 12/Nov/04 18:28

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