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

Composite atomic-array indexes not ingesting data on creation

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.1.0
    • None
    • analytics
    • Untriaged
    • 1
    • Unknown
    • CX Sprint 262, CX Sprint 263

    Description

      The following sequence of events does not deliver the right result. The issue lies with ingestion job created on CREATE INDEX. (Tracking on open sourceĀ ASTERIXDB-2959)

      SET               `compiler.arrayindex` "true";
      DROP DATAVERSE    TestDataverse IF EXISTS;
      CREATE DATAVERSE  TestDataverse;
      USE               TestDataverse;
      CREATE TYPE       GenericType AS { _id: bigint  };
      CREATE DATASET    TestDataset (GenericType)
      PRIMARY KEY       _id;
      INSERT INTO       TestDataset [
          { "_id": 100, "f": 1, "a": {"b": [{"c": {"d": 1}}]} },
          { "_id": 101, "f": "a", "a": null },
          { "_id": 102, "f": "a", "a": {"b": null} },
          { "_id": 103, "f": "a", "a": {"b": [{"c": null}]} },
          { "_id": 104, "f": "a", "a": {"b": [{"c": {"d": null}}]} }
          ];
      CREATE INDEX      TestIdx
      ON                TestDataset (
          f : bigint,
          UNNEST a.b
          SELECT c.d : bigint
      );
      FROM TestDataset D
      UNNEST D.a.b AB
      WHERE D.f = 1 AND AB.c.d = 1
      SELECT D._id;

      Attachments

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

        Activity

          People

            glenn.galvizo Glenn Galvizo
            glenn.galvizo Glenn Galvizo
            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