Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.0, Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
ADVISE SELECT t_1.int_field1 , t_1.decimal_field1 , t_1.primary_key_id , t_1.bool_field1
FROM bucket_01 t_1
INNER JOIN bucket_04 t_4
ON ( t_1.primary_key_id = t_4.primary_key_id )
INNER JOIN bucket_04 t_5
ON ( t_1.primary_key_id = t_5.primary_key_id );
This query fails to give covering index recommendation for bucket_01.
Attachments
For Gerrit Dashboard: MB-39707 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
129673,4 | MB-39707 Take virtual indexes into consideration for deriveNotNullFilter | master | query | Status: MERGED | +2 | +1 |
129768,2 | MB-39707 Fix build error on CE | master | query | Status: MERGED | +2 | +1 |
129789,2 | MB-39707 Take virtual indexes into consideration for deriveNotNullFilter | mad-hatter | query | Status: MERGED | +2 | +1 |
129790,2 | MB-39707 Fix build error on CE | mad-hatter | query | Status: MERGED | +2 | +1 |
129791,3 | MB-39707 Remove the testcase which includes an improvement for 7.0. Change-Id: I0705604b2d750826bf84959a8edfb5f93f8e1a14 Reviewed-on: http://review.couchbase.org/c/query/+/129791 Well-Formed: Build Bot <build@couchbase.com> Reviewed-by: Sitaram Vemulapalli <sitaram.vemulapalli@couchbase.com> Tested-by: Chang Liu <chang.liu@couchbase.com> | mad-hatter | query | Status: MERGED | +2 | +1 |