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

          For Gerrit Dashboard: MB-20208
          # Subject Branch Project Status CR V

          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