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.