Uploaded image for project: 'Couchbase Lite'
  1. Couchbase Lite
  2. CBL-216

Ordering null values inconsistent with N1QL expectations

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Won't Do
    • Critical
    • 3.0
    • None
    • LiteCore
    • Security Level: Public

    Description

      https://github.com/couchbase/couchbase-lite-core/issues/762

      Given the following query:

       

      {{SELECT fl_result(fl_value(_doc.body, 'shipped-on')) FROM kv_default AS _doc WHERE (fl_value(_doc.body, 'test_id') = 'select_func') AND (_doc.flags & 1 = 0) ORDER BY fl_value(_doc.body, 'shipped-on')

      {"ORDER_BY":[[".shipped-on"]],"WHAT":[[".shipped-on"]],"WHERE":["=",[".test_id"],"select_func"]}}}

      The results should be entries with missing shipped-on, null shipped-on, and then values, but the actual result is missing shipped-on, values, null shipped-on.

      Attachments

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

        Activity

          People

            The Lite The Lite
            jimb Jim Borden
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty