Details
-
Bug
-
Resolution: Unresolved
-
Major
-
6.6.0, Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
EXPLAIN SELECT META().id
FROM default USE INDEX (USING FTS)
WHERE type="emp" AND (join_date > "2019-01-01" AND join_date < "2020-01-01");
Above query not covering.
If () are removed it covers.
Attachments
Gerrit Reviews
| For Gerrit Dashboard: MB-39182 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 127180,2 | MB-39182. Equality check with precedence | mad-hatter | query | Status: MERGED | +2 | +1 |
| 127339,2 | MB-39182. Equality check with precedence | master | query | Status: MERGED | +2 | +1 |
| 127376,3 | Revert "MB-39182. Equality check with precedence" | master | query | Status: MERGED | +2 | +1 |
| 127455,2 | MB-39182. build failure | mad-hatter | query | Status: MERGED | +2 | +1 |
| 127564,2 | MB-39182. Revert the fix | mad-hatter | query | Status: MERGED | +2 | +1 |