Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: 10.1.3.1, 10.2.1.6
    • Component/s: SQL
    • Labels:
      None

      Description

      Reporting for Christian d'Heureuse, filed on derby-dev list.

      The NULLIF built-in function of Cloudscape 10.0.1.0 beta seems to accept
      only string values.

      Examples:

      values nullif('a','b');
      --> OK

      values nullif(1,2);
      --> Error message: "ERROR 42X89: Types 'CHAR' and
      'INTEGER' are not type compatible. (Neither type
      is assignable to the other type.)"

      1. Derby-7.txt
        1 kB
        Amit Handa
      2. Derby7NullIf061005svndiff.txt
        165 kB
        Mamta A. Satoor
      3. derby7Nullif080205svndiff.txt
        166 kB
      4. DERBY-903-changes-for-10.1-branch.diff
        0.8 kB
        Bernt M. Johnsen
      5. derby-nullif.patch
        22 kB
        Jeremy Boynes

        Issue Links

          Activity

            People

            • Assignee:
              Mamta A. Satoor
              Reporter:
              Tulika Agrawal
            • Votes:
              6 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development