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

Test_where_join_keys_equal_more_covering fails: join query with view index gives wrong results

    XMLWordPrintable

Details

    • Untriaged
    • Yes

    Description

      Test which fails:
      python testrunner.py -i test.ini -c conf/tuq/py-covering-index.conf -p gsi_type=forestdb -p nodes_init=2
       
      gsi index:
      CREATE INDEX coveringindextwo ON default(join_day, tasks_ids, job_title)  USING gsi;
       
      view index
      CREATE INDEX coveringindextwo ON default(join_day, tasks_ids, job_title)  USING view;
       
      Query issued:
      SELECT employee.join_day, employee.tasks_ids, new_project_full.job_title new_project FROM default  as employee use index(`coveringindextwo`) INNER JOIN default as new_project_full ON KEYS employee.tasks_ids WHERE employee.join_day <= 2 order by employee.join_day limit 10;
       
      Above query with gsi index gives no result.
       
      SELECT employee.join_day, employee.tasks_ids, new_project_full.job_title new_project FROM default  as employee use index(`coveringindextwo` using view) INNER JOIN default as new_project_full ON KEYS employee.tasks_ids WHERE employee.join_day <= 2 order by employee.join_day limit 10;
       
      Above query with view index gives 10 results which is wrong.
       
       
      With primary index the query gives no results.
      
      

       

      Attachments

        Issue Links

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

          Activity

            People

              keshav Keshav Murthy
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty