Bug #109805 natural join when typed as natuarl join returns cross product
Submitted: 27 Jan 4:23 Modified: 27 Jan 4:49
Reporter: Aman Yadav Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0 OS:Windows
Assigned to: CPU Architecture:x86 (64)
Tags: join, natural join

[27 Jan 4:23] Aman Yadav
When I run a query using natural join and mistype natural as natuarl, it returns a cross product.

How to repeat:
Create Tables and query natural join and write natural as natuarl.
[27 Jan 4:49] MySQL Verification Team
Hello Aman,

Thank you for the report and feedback.
IMHO this is duplicate of Bug #109804, please see Bug #109804.