Details

    • Type: Bug
    • Status: Closed
    • Priority: 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.)"

        Attachments

        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:
                mamtas Mamta A. Satoor
                Reporter:
                tulika Tulika Agrawal
              • Votes:
                6 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: