MySQL Bugs: #114890: return empty set with inner join

Bug #114890	return empty set with inner join
Submitted:	6 May 2024 1:49	Modified:	9 May 2024 9:40
Reporter:	wei tong	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	8.0.23	OS:	Other (Amazon RDS - mysql)
Assigned to:		CPU Architecture:	Any

Description:
The query involved retrieving data from 11 temporary tables, with a combined dataset of over 200,000 records. However, when attempting an inner join between the last two temporary tables, the query returned empty results. Despite the fact that the conditions for the inner join would have results, the data was not retrieved as expected. But the query to successfully retrieve data by adding the limit keyword.

How to repeat:
One temporary table is related to 6 master tables. The temporary table is related to a partition table where has more than 200,000 records.

Hi Mr. tong,

Thank you for your bug report.

However, let us inform you that this is a forum for the bugs with fully repeatable test cases. Test case should consist of a set of SQL statement always leading to the bug being exposed.

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php 

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.  

Thank you for your interest in MySQL.

More important then the above info is that you are using an unsupported release of 8.0. Please use 8.0.37.