MySQL Bugs: #111302: Returns OK in Message

Bug #111302	Returns OK in Message
Submitted:	6 Jun 2023 18:35	Modified:	7 Jun 2023 12:45
Reporter:	Chris Apperson	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	8.0.32 build 2612062 CE (64 bits)	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Select statement for view returns OK in message window and no results.  No error reported.

I also ran each select that is contained in the view, there is a few union all clauses, and each select runs fine and returns data.

When I run the view in the from clause It runs for about 20 mins which is typical and returns just OK in the message field of the log and no results show.

How to repeat:
?

Hi Mr. Apperson,

Thank you for your bug report.

However, we can not repeat it.

You have not sent us a dump of all tables that are included in the query. You have also not sent us a SELECT statement that are included in that UNION ALL query.

Can't repeat.