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

N1QL "create index USING VIEW" based indexes have problems

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 7.0.0
    • 4.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      Queries that are computed using view indexes have some known problems:

      • indexing array values does not work correctly
      • indexing meta().id does not work correctly

      There is some suspicion that view indexes were not QAed very closely.

      Primary and secondary indexes are created slightly differently. It might be useful to create both of them the same way. Explained in more detail below.

      Basically, the view indexes need a re-examination.

      Attachments

        Issue Links

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

          Activity

            People

              pierre.regazzoni Pierre Regazzoni
              johan.larson Johan Larson (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty