Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
New-style optimizer hints are ignored if a query has STRAIGHT_JOIN hint before them:
CREATE TABLE t1 (f1 INT NOT NULL); |
INSERT INTO t1 VALUES (1),(2),(3); |
|
|
CREATE TABLE t2 (f1 INT NOT NULL); |
INSERT INTO t2 VALUES (3),(1),(8),(3); |
|
|
EXPLAIN EXTENDED SELECT STRAIGHT_JOIN /*+ NO_BNL()*/ * FROM t1, t2; |
|
|
DROP TABLE t1, t2; |
Compare this with the case
EXPLAIN EXTENDED SELECT /*+ NO_BNL()*/ STRAIGHT_JOIN * FROM t1, t2; |
where the STRAIGHT_JOIN hint follows new-style hints. Here new-style hint is parsed and applied.
Interaction with other old-style hints should be also tested.
Attachments
Issue Links
- relates to
-
MDEV-33281 Implement optimizer hints like in MySQL 8
-
- In Progress
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to MDEV-33281 [ MDEV-33281 ] |
| Affects Version/s | 11.8.1 [ 29961 ] |
| Fix Version/s | 12.0 [ 29945 ] | |
| Fix Version/s | N/A [ 14700 ] |