Bug #102343 | Use FOREIGN KEY description for JOIN tables | ||
---|---|---|---|
Submitted: | 22 Jan 2021 11:08 | Modified: | 22 Jan 2021 14:05 |
Reporter: | Александр Ммммммм | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S4 (Feature request) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[22 Jan 2021 11:08]
Александр Ммммммм
[22 Jan 2021 11:12]
Александр Ммммммм
Some missprint. Right version: New syntax: SELECT d.id, d.date, w.name warehouse, cl.name client, m.name manager FROM documents d INNER JOIN d.document_warehouse w -- Just syntax sugar for "organizations w ON d.organization_id_warehouse = w.id" INNER JOIN d.document_client cl -- Just syntax sugar for "organizations cl ON d.organization_id_warehouse = cl.id" LEFT JOIN d.document_manager m -- Just syntax sugar for "organizations m ON d.organization_id_manager = m.id"
[22 Jan 2021 14:05]
MySQL Verification Team
Hi Mr. Mmmmmmm, Thank you for your feature request. However, we do not find it acceptable. Simply, SQL standard requires a definition of the common column. Some users simply want to get a Cartesian product and not a join, so this non-standard change would affect their applications. There are some client programs, mostly GUI ones, out there, who are able to create queries based on few choices made. That would be a good feature request for some GUI client of your choice. Not a feature request for the server.