How to force MySQL to honestly execute a query, without optimization, with the execution of all subqueries?

M

mr_creo2017-06-15 12:27:33

MySQL

mr_creo, 2017-06-15 12:27:33

Good afternoon,
How to make MySQL honestly execute a query, without optimization, with the execution of all subqueries?
There is a SELECT query containing a subquery, and so, if there are no records according to the condition of the main query, then the subquery is not executed at all, probably MySQL's query optimization is to blame.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Andrey, 2017-06-15
@VladimirAndreev

Apparently not. well, either execute the subquery as a RIGHT JOIN with the main query, then the subquery will be executed first, then the main query, and when they are joined, 0 rows will be returned.
I really don't see why you need it...