MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0 Subquery Errors

There are some errors that apply only to subqueries. This section describes them.

For transactional storage engines, the failure of a subquery causes the entire statement to fail. For nontransactional storage engines, data modifications made before the error was encountered are preserved.