MySQL Bugs: #109805: natural join when typed as natuarl join returns cross product

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:	None
Category:	MySQL Server: Optimizer	Severity:	S2 (Serious)
Version:	8.0	OS:	Windows
Assigned to:		CPU Architecture:	x86 (64)
Tags:	join, natural join

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.

Hello Aman,

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

regards,
Umesh