Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-9145

Query for callsign on airport collection doesn't work

    XMLWordPrintable

Details

    Description

      When running the query "SELECT a.callsign FROM default:`travel-sample`.inventory.airport a LIMIT 5;", the resultset returned is empty, as the airport collection doesn't contain a field called callsign.

      cbq> SELECT a.callsign FROM default:`travel-sample`.inventory.airport a LIMIT 5;
      {
      "requestID": "dace9a7e-fa52-4110-a0c5-bc328f472d8b",
      "signature":

      { "callsign": "json" }

      ,
      "results": [
      {},
      {},
      {},
      {},
      {}
      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "165.1072ms", "executionTime": "165.0281ms", "resultCount": 5, "resultSize": 10, "serviceLoad": 2 }

      }
      cbq>

      Reporter: Richie Jarvis
      E-mail: richie@deepsky.org.uk

      Attachments

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

        Activity

          People

            simon.dew Simon Dew
            docsite-collector Docs Site Collector
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty