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

can't use the META function on CREATE INDEX

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • 2213 on ubuntu
    • Untriaged
    • Unknown

    Description

      a number of customers bury the type of docs into their doc key. indexing based on type generally helps many queries thus the following type of index become super useful to help improve query perf. However we don't seem to have the ability to use META function in indexing;
      CREATE INDEX i3 on `beer-sample`(META(`beer-sample`).id) USING GSI;

      we need to add support for META function to enable this in CREATE INDEX.

      Below will be supported:

      Meta().id

      Attachments

        Issue Links

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

          Activity

            People

              gerald Gerald Sangudi (Inactive)
              cihan Cihan Biyikoglu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  PagerDuty