Can't use USING with STRAIGHT_JOIN

[5lava]

Hello,
While migrating from MariaDB to Percona XtraDB Cluster I found out that USING can't be used with STRAIGHT_JOIN.
For example:

select * from A straight_join B using(id); -- syntax error
select * from A straight_join B on A.id=B.id; -- works fine
select * from A join B on A.id=B.id; -- works fine
select * from A join B using(id); -- works fine

[5lava (5lava)]

5.7.14-8, wsrep_26.17

[Kenn Takara (kenn-takara)]

select * from A straight_join B using(id);
  fails on PXC 5.6.34
  fails on PXC 5.7.16
  fails on PS 5.7.17

From the docs

  https://dev.mysql.com/doc/refman/5.7/en/join.html

According to the syntax, USING can't be used with STRAIGHT_JOIN.

moving upstream.

[Muhammad Irfan (muhammad-irfan)]

The syntax rule is described in manual https://dev.mysql.com/doc/refman/5.7/en/join.html
Syntax with STRAIGHT_JOIN allows ON condition by not USING clause. To summarize, It's expected behavior.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3616