Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.2.3, 7.6.2
-
Untriaged
-
0
-
Unknown
Description
DROP INDEX default.ix21;
|
|
CREATE INDEX `ix21` ON default (name DESC) WHERE type != "doc";
|
|
EXPLAIN SELECT META(f).id
|
FROM default f
|
WHERE type != "doc" AND name > "xyz"
|
ORDER BY name DESC
|
OFFSET 10
|
LIMIT 20;
|
Also verify type NOT IN ["doc"] both places
If change both places ( type != "doc") = true , it pushed.
Also pushed
CREATE INDEX `ix21` ON default (name DESC, type) WHERE (type != "doc");
|
CREATE INDEX `ix21` ON default (name DESC, type) ;
|
Attachments
Issue Links
- links to