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

[6 Jun 18:35] Chris Apperson
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:
[7 Jun 12:45] MySQL Verification Team
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.