MySQL error code
MySQL error 3973
MySQL server error 3973 is ER_SUBQUERY_TRANSFORM_REJECTED, reported with SQLSTATE HY000.
Statement requires a transform of a subquery to a non-SET operation (like IN2EXISTS, or subquery-to-LATERAL-derived-table). This is not allowed with optimizer switch 'subquery_to_derived' on.
| Error | 3973 |
|---|---|
| Name | ER_SUBQUERY_TRANSFORM_REJECTED |
| SQLSTATE | HY000 |
| Group | Server errors |
Source: MySQL 8.4 Error Reference