MySQL Bugs: #112108: VIEW reference in a SELECT subquery returns different results between 5.7 & 8.0

Bug #112108	VIEW reference in a SELECT subquery returns different results between 5.7 & 8.0
Submitted:	18 Aug 2023 7:13	Modified:	22 Aug 2023 7:18
Reporter:	IVAN HO	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S3 (Non-critical)
Version:	8.0.33, 8.0.34	OS:	Red Hat (8)
Assigned to:		CPU Architecture:	Any
Tags:	view subquery

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

test case

Attachment: testcase.sql (application/octet-stream, text), 3.09 KiB.

Test Case mysql 5.7.39 result

Attachment: testcase 5.7.39 result.sql (application/octet-stream, text), 1.62 KiB.

Test Case mysql 8.0.33 result

Attachment: testcase 8.0.33 result.sql (application/octet-stream, text), 1.68 KiB.