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

          Tulika Agrawal created issue -
          Amit Handa made changes -
          Field Original Value New Value
          Attachment Derby-7.txt [ 18596 ]
          Jeremy Boynes made changes -
          Attachment derby-nullif.patch [ 18669 ]
          Mamta A. Satoor made changes -
          Attachment Derby7NullIf061005svndiff.txt [ 12310665 ]
          Anonymous made changes -
          Attachment derby7Nullif080205svndiff.txt [ 12311519 ]
          Mamta A. Satoor made changes -
          Assignee Mamta A. Satoor [ mamtas ]
          Mamta A. Satoor made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Mamta A. Satoor made changes -
          Environment
          Fix Version/s 10.2.0.0 [ 11187 ]
          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.)"
          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.)"
          Mamta A. Satoor made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Bernt M. Johnsen made changes -
          Status Closed [ 6 ] Reopened [ 4 ]
          Resolution Fixed [ 1 ]
          Bernt M. Johnsen made changes -
          Fix Version/s 10.2.0.0 [ 11187 ]
          Resolution Fixed [ 1 ]
          Fix Version/s 10.1.3.0 [ 12310616 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          Bernt M. Johnsen made changes -
          Status Closed [ 6 ] Reopened [ 4 ]
          Resolution Fixed [ 1 ]
          Bernt M. Johnsen made changes -
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          Fix Version/s 10.2.0.0 [ 11187 ]
          Bernt M. Johnsen made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Bernt M. Johnsen made changes -
          Attachment DERBY-903-changes-for-10.1-branch.diff [ 12326306 ]
          Bernt M. Johnsen made changes -
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          Andrew McIntyre made changes -
          Link This issue relates to DERBY-1967 [ DERBY-1967 ]
          Gavin made changes -
          Workflow jira [ 37481 ] Default workflow, editable Closed status [ 12801240 ]

            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