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

Bug in NULLIF Function

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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-nullif.patch
          22 kB
          Jeremy Boynes
        2. DERBY-903-changes-for-10.1-branch.diff
          0.8 kB
          Bernt Johnsen
        3. derby7Nullif080205svndiff.txt
          166 kB
        4. Derby7NullIf061005svndiff.txt
          165 kB
          Mamta A. Satoor
        5. Derby-7.txt
          1 kB
          Amit Handa

        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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment