SELECT ... STRAIGHT_JOIN ... USING ... returns syntax error

[dveeden]

Bug Report

1. Minimal reproduce step (Required)

SELECT 1 FROM (SELECT 1 x) a STRAIGHT_JOIN (SELECT 1 x) b USING (x);

2. What did you expect to see? (Required)

mysql-8.4.0> SELECT 1 FROM (SELECT 1 x) a STRAIGHT_JOIN (SELECT 1 x) b USING (x);
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

3. What did you see instead (Required)

mysql-8.0.11-TiDB-v8.1.0> SELECT 1 FROM (SELECT 1 x) a STRAIGHT_JOIN (SELECT 1 x) b USING (x);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 63 near "USING (x)" 

4. What is your TiDB version? (Required)