[SPARK-49140][SQL] Widening type promotion from int/long to decimal and support custom decimal logic type for int in `AvroDeserializer`

[wayneguow]

What changes were proposed in this pull request?

This PR aims to:

1. Widening type promotion from int/long to decimal in AvroDeserializer. Supported as following(Avro Type -> Spark Type):

• Int -> DecimalType;
• Long -> DecimalType ;

2. Support custom decimal logic type for int We already support long in #41409.

Why are the changes needed?

Similar to Parquet reader, we'd better to enable type promotion/widening for Avro deserializer.

Does this PR introduce any user-facing change?

Yes, Users can use wider types more flexibly.

How was this patch tested?

Pass GA and add some new test cases.

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

No.

[wayneguow]

cc @dongjoon-hyun @cloud-fan thanks.

[wayneguow]

@dongjoon-hyun Could you help to also review it when you have some time, cause that this PR contains some similar feature that you reviewed before(related PR: support custom decimal logic type for long). Thanks ~

[github-actions[bot]]

We're closing this PR because it hasn't been updated in a while. This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable. If you'd like to revive this PR, please reopen it and ask a committer to remove the Stale tag!