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

[CBAS] Conditional functions for Unknowns are not implemented in SQL++

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • 5.5.0
    • CBAS DP2
    • analytics
    • Untriaged
    • No

    Description

      Build : 647

      Conditional functions for unknowns are not implemented in SQL+, but they are supported in N1QL. These should be either documented, or fixed in SQL+.

      Following are the functions not implemented in SQL++:
      IFNAN@2, NANIF@2, POSINFIF@2, IFINF@2, IFMISSINGORNULL@2, MISSINGIF@2

      SELECT feature_name, IFNAN(story_point[2],story_point[1]) as point FROM default_shadow ORDER BY feature_name;
      SELECT feature_name, NANIF(story_points[0],story_point[0]) FROM default_shadow ORDER BY feature_name;
      SELECT feature_name, POSINFIF(story_point[2],story_point[1]) as point FROM default_shadow ORDER BY feature_name;
      SELECT feature_name, IFINF(story_point[2],story_point[1]) as point FROM default_shadow ORDER BY feature_name;
      SELECT feature_name, IFMISSINGORNULL(coverage_tests.P0,coverage_tests.P4) as C FROM default_shadow ORDER BY feature_name;
      SELECT feature_name, MISSINGIF(coverage_tests.P0,0) as point FROM default_shadow ORDER BY feature_name;

      Attachments

        Issue Links

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

          Activity

            People

              dmitry.lychagin Dmitry Lychagin (Inactive)
              mihir.kamdar Mihir Kamdar (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