Details
Minor
Description
STRAIGHT_JOIN should be usable in every context where a regular JOIN can be used, but does not support:
SELECT ... FROM t1 STRAIGHT_JOIN t2 USING(id);
or
SELECT ... FROM t1 NATURAL STRAIGHT_JOIN t2;
yet.
See also http://bugs.mysql.com/35268
Gliffy Diagrams
Attachments
Issue Links
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
It seems to be documented this way in http://dev.mysql.com/doc/refman/5.5/en/join.html, so I suppose technically it's a feature request more than a bug. As such, setting the Fixed version to 10.x.
Yes, the documentation matches the parser code ...
For the STRAIGHT_JOIN part i might agree with feature request as this is a MySQL specific extension, it would add consistency though and allow for simply replacing a JOIN with a STRAIGHT_JOIN optimizer hint in every context without having to rewrite NATURAL JOIN or JOIN ... USING() into an equivalent JOIN ... ON clause first.
The NATURAL INNER JOIN part is improving compliance with the SQL standard though ... ( https://kb.askmonty.org/en/syntax-rules/ )
Reviewed, tests run and pushed into 10.0-base
NATURAL INNER JOIN also doesn't work ...