Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.0.0
-
4.7.0-888
-
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
- blocks
-
MB-19612 4.5.1 Minor Release
- Closed