New optimizer hint for changing the session system variable.

New optimizer hint for changing the session system variable.

In MySQL 8.0.3, we have introduced a new optimizer hint called SET_VAR. This hint allows to change the value of a system variable for a single query.

Earlier, changing a system variable for a single query would require four steps:

1) Store current value.

…
Source: New optimizer hint for changing the session system variable.