fix: reject decimal promotion that changes the scale #9189

Job	Run time
integration-test-adls	1m 22s
integration-test-s3	1m 10s
lint-and-unit-test (3.10)	3m 27s
lint-and-unit-test (3.11)	3m 10s
integration-test	11m 56s
lint-and-unit-test (3.13)	3m 11s
cibw-dev-env-smoke-test	30s
lint-and-unit-test (3.12)	3m 8s
lint-and-unit-test (3.14)	2m 39s
integration-test-gcs	1m 21s
integration-coverage-report	31s
	32m 25s

Provide feedback