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

Select with ">" does not work when using gsi index for certain datasets

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 4.0.0
    • 4.0.0
    • forestdb, secondary-index
    • Security Level: Public
    • ran the issue on the latest build. 1 node only, check for n_0 logs.
    • Untriaged
    • Yes
    • ForestDB: Oct 26 - Nov 13

    Description

      ./testrunner -i test.ini -t 2i.indexscans_2i.SecondaryIndexingScanTests.test_multi_create_query_explain_drop_index,groups=simple:greater_than:no_orderby_groupby:range,dataset=default,doc-per-day=1,use_gsi_for_primary=True,use_gsi_for_secondary=True,skip_cleanup=True

      1. Create 1 node cluster with all services
      2. Add default bucket with 2016 items for employee data set
      3. Create GSI index on a field "join_yr"
      4. query using select * from default where join_yr > 1999

      Step 4 returns empty result set

      Sample:

      {
      "tasks_points":

      { "task1": 1, "task2": 1 }

      ,
      "name": "employee-9",
      "mutated": 0,
      "skills": [
      "skill2010",
      "skill2011"
      ],
      "join_day": 9,
      "join_mo": 10,
      "email": "9-mail@couchbase.com",
      "test_rate": 10.1,
      "join_yr": 2011,
      "_id": "query-testemployee10153.1877827-0",
      "VMs": [

      { "RAM": 10, "os": "ubuntu", "name": "vm_10", "memory": 10 }

      ,

      { "RAM": 10, "os": "windows", "name": "vm_11", "memory": 10 }

      ],
      "job_title": "Engineer"
      }

      Attachments

        1. forestdb_test_MB-13715.go
          2 kB
        2. index_file.tar.gz
          774 kB
        3. log.tar.gz
          3.08 MB
        4. test.ini
          0.6 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            sundar Sundar Sridharan (Inactive)
            parag Parag Agarwal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty