Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-45

Request support for CAST() in Like clause

    Details

    • 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
    • Labels:
      None
    • Environment:
      all platforms

      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

        Attachments

          Activity

            People

            • Assignee:
              myrna Myrna van Lunteren
              Reporter:
              lancea Lance Andersen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: