Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
Ubuntu Jammy
Description
Query using SphinxSE.
When using 10.10.1 or 10.9.2 and earlier.
The queries are super quick.
30 rows in set (1 min 32.022 sec)
After upgrading 10.10.2, and 10.9.3 the same query
30 rows in set (0.125 sec)
When running explain on the query type=eq_ref on the quick version.
and eq|filter on the slow one.
Disabling eq|filter with
set @@optimizer_switch="rowid_filter=off";
Resolved the issue.
Attachments
Issue Links
- is part of
-
MDEV-30218 Incorrect optimization for rowid_filtering
- Closed