Description
Version: 5.1.0-1511
test: tuqquery/tuq_2i_index.py test_array_index_delete
Run the test conf: python testrunner.py -i /Users/korrigan.clark/Desktop/resources/vagrant-2.ini -c conf/tuq/py-tuq-arrayindexing.conf -p doc-per-day=6,primary_indx_type=GSI,array_indexing=True
The test has two indexes: primary and arraydel_idx
CREATE INDEX array_delidx ON default( DISTINCT ARRAY v FOR v in join_yr END) USING gsi
Then run:
EXPLAIN delete from default where any v in join_yr SATISFIES v=2012 end LIMIT 1
This will show PrimaryScan when DistinctScan is expected.
You can run:
EXPLAIN select * from default where any v in join_yr SATISFIES v=2012 end LIMIT 1
and you will see that DistinctScan is occuring
Attachments
Issue Links
- is duplicated by
-
MB-27227 Index is not selected for range updates
- Closed
For Gerrit Dashboard: MB-27188 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
86841,6 | MB-27188, MB-27227 UPDATE and DELETE statements not using appropriate index | master | query | Status: MERGED | +2 | +1 |