Derby
  1. Derby
  2. DERBY-45

Request support for CAST() in Like clause

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major 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

        Activity

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development