MySQL Error 3986 – ER_IMPLICIT_COMPARISON_FOR_JSON

MySQL Error Message

Evaluating a JSON value in SQL boolean context does an
implicit comparison against JSON integer 0; if this is not what
you want, consider converting JSON to a SQL numeric type with
JSON_VALUE RETURNING

Reason for the Error

ER_IMPLICIT_COMPARISON_FOR_JSON
was added in 8.0.21.