Bug #109805 natural join when typed as natuarl join returns cross product

• Submitted: 27 Jan 2023 4:23
• Modified: 27 Jan 2023 4:49
• Reporter: Aman Yadav
• Status: Duplicate
• Category: MySQL Server: Optimizer
• Severity: S2 (Serious)
• Version: 8.0
• OS: Windows
• CPU Architecture: x86 (64)
• Tags: join, natural join

[27 Jan 2023 4:23] Aman Yadav

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.

[27 Jan 2023 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.

regards,
Umesh