[SPARK-46848] XML: Enhance XML bad record handling with partial results support

[shujingyang-db]

What changes were proposed in this pull request?

Enhance XML bad record handling with partial results support

Why are the changes needed?

Otherwise, we will get an empty result if the parser throws an exception

Does this PR introduce any user-facing change?

Yes

How was this patch tested?

Unit tests

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

No