Why is this an issue?
There is no reason to re-assign a variable to itself. Either this statement is redundant and should be removed, or the re-assignment is a mistake
and some other value or variable was intended for the assignment instead.
Noncompliant code example
SET name = name;
SET name = UPPER(name);