[SPARK-42841][SQL]Assign a name to the error class _LEGACY_ERROR_TEMP_2005

[yuexing]

What changes were proposed in this pull request?

see https://issues.apache.org/jira/browse/SPARK-42841, replace _LEGACY_ERROR_TEMP_2005 with a meaningful name. Some points:

• To make sure full UT coverage, method with "datatype" is refactored to call another one with "string".
• sqlStat '0A000' means NOT_SUPPORTED or CANNOT.

Why are the changes needed?

see https://issues.apache.org/jira/browse/SPARK-42841

Does this PR introduce any user-facing change?

No

How was this patch tested?

UT

Was this patch authored or co-authored using generative AI tooling?

No