Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-32482

decode produces same result for missing and not missing

    XMLWordPrintable

Details

    • Untriaged
    • Unknown

    Description

      this query: 

      select decode(field_that_is_missing, missing, 'ok') from default

      will produce the same results as this query:

      select decode(field_that_is_missing, not missing, 'ok') from default

      and this query:

      select decode(field_that_is_null, null, 'ok') from default

      will produce the same results as 

      select decode(field_that_is_null, not null, 'ok') from default

      furthermore:

      select decode(field_that_is_missing, valued, 'ok') from default

      and

      select decode(field_that_is_missing, not valued, 'ok') from default

      throws a syntax error

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              kamini.jagtiani Kamini Jagtiani
              korrigan.clark Korrigan Clark (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty