MySQL Error 3574 – ER_CTE_RECURSIVE_REQUIRES_NONRECURSIVE_FIRST

MySQL Error Message

Recursive Common Table Expression ‘%s’ should have one or
more non-recursive query blocks followed by one or more recursive
ones

Reason for the Error

ER_CTE_RECURSIVE_REQUIRES_NONRECURSIVE_FIRST
was added in 8.0.1.