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

Bug in NULLIF Function

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.0.2.0
    • 10.1.3.1, 10.2.1.6
    • SQL
    • 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 Johnsen
        5. derby-nullif.patch
          22 kB
          Jeremy Boynes

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-1967 UNION (ALL) contraint violation problem

          • Major - Major loss of function.
          • Closed

          Activity

            People

              mamtas Mamta A. Satoor
              tulika Tulika Agrawal
              Votes:
              6 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: