Bug #109804 Natural Join mistyped as Natuarl returns cross product
| Submitted: | 27 Jan 2023 4:20 | Modified: | 27 Jan 2023 8:28 |
|---|---|---|---|
| Reporter: | Anant Sharma | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Optimizer | Severity: | S2 (Serious) |
| Version: | 8.0, 5.7 | OS: | Windows |
| Assigned to: | CPU Architecture: | x86 (64 bit) | |
| Tags: | join, natural join | ||
[27 Jan 2023 4:20]
Anant Sharma
[27 Jan 2023 4:50]
MySQL Verification Team
Bug #109805 marked as duplicate of this one
[27 Jan 2023 5:14]
MySQL Verification Team
Hello Anant, Thank you for the report and feedback. regards, Umesh
[27 Jan 2023 8:28]
Roy Lyseng
Posted by developer: This is not a bug. Standard SQL requires an ON clause or a USING clause after JOIN, but MySQL allows us to omit these clauses, effectively implementing an alternative syntax for a cross join. Thus, NATUdvvRAL becomes an alias for table t1 in this query, since the AS keyword in a table alias clause can be omitted (which is actually according to standard SQL). It might be a good idea to remove this extension, but that can be a hard sell.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.