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.

In MySQL 8.0.19 and later, all of the errors described in this section also apply when using TABLE in subqueries.

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.