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

as of the 6.5 beta, N1QL will only support GSI indexes, not VIEW indexes

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • Mad Hatter
    • Mad Hatter
    • query
    • DOC-2019-S22-Nov01
    • 1

    Description

      Statements like this will no longer work:

      create index f_idx on myBucket(foo) using view

      These will continue to work:

      create index f_idx on myBucket(foo) 

      create index f_idx on myBucket(foo) using gsi

      Pre-existing view-type indexes will not be accessible.

       

      Attachments

        Issue Links

          backports to

          Bug - A problem which impairs or prevents the functions of the product. DOC-3937 USING VIEW is now deprecated

          • Major - Major loss of function.
          • Resolved
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-33596 node-to-node encryption will not encrypt connection between query engine and views

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. DOC-5907 Docs update for N1QL view index.

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link mad-hatter changes implemented by #924

          mentioned in

          Page Loading...

          Page Loading...

          Activity

            People

              simon.dew Simon Dew
              johan.larson Johan Larson (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty