Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.0, 6.6.1, 6.6.2, Cheshire-Cat
-
Untriaged
-
1
-
No
Description
CREATE INDEX ix10 ON default(c1); |
CREATE INDEX ix11 ON default(c10,self); -- The reason self is rare but used for covering of r |
INSERT INTO default VALUES("k01", {"c1":20, "id":"k01"}); |
INSERT INTO default VALUES("k02", {"c1":21, "id":"k02"}); |
INSERT INTO default VALUES("ck02", {"c10":21, "id":"ck02"}); |
|
|
|
EXPLAIN SELECT l.id
|
FROM default AS l |
LEFT JOIN default AS r ON l.c1 = r.c10 |
WHERE r IS MISSING AND l.c1 > 10; |
{
|
"#operator": "IndexScan3", |
"as": "r", |
"index": "ix11", |
"index_id": "c1846460bcfb76a2", |
"index_projection": { |
"primary_key": true |
},
|
"keyspace": "default", |
"namespace": "default", |
"nested_loop": true, |
"spans": [ |
{
|
"exact": true, |
"range": [ |
{
|
"high": "null", |
"inclusion": 0, |
"low": "null" |
}
|
]
|
}
|
],
|
"using": "gsi" |
}
|
Attachments
Issue Links
- backports to
-
MB-46613 [BP MB-46607] - empty span generated when Index has self and Outer JOIN WHERE clause has MISSING
- Closed
For Gerrit Dashboard: MB-46607 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
154597,2 | MB-46607 Avoid using WHERE clause filters to generate index spans for inner of LEFT OUTER JOIN | master | query | Status: MERGED | +2 | +1 |
154626,2 | MB-46613 Avoid using WHERE clause filters to generate index spans for inner of LEFT OUTER JOIN | mad-hatter | query | Status: MERGED | +2 | +1 |
155415,2 | MB-46616 Code cleanup for issue with IS MISSING filter in the WHERE clause of LEFT OUTER JOIN | cheshire-cat | query | Status: MERGED | +2 | +1 |
155546,2 | MB-46616 Code cleanup for issue with IS MISSING filter in the WHERE clause of LEFT OUTER JOIN | master | query | Status: MERGED | +2 | +1 |