1 of 1

Error 1923: At least one of the 'in_to_exists' or 'materialization' optimizer_switch flags must be '

Error Code

SQLSTATE

Error

Description

1923

ER_ILLEGAL_SUBQUERY_OPTIMIZER_SWITCHES

At least one of the 'in_to_exists' or 'materialization' optimizer_switch flags must be 'on'.

Possible Causes and Solutions