fix: reject decimal promotion that changes the scale #9203

Job	Run time
integration-test-adls	1m 14s
cibw-dev-env-smoke-test	31s
lint-and-unit-test (3.10)	3m 18s
integration-test-s3	1m 18s
integration-test-gcs	1m 11s
lint-and-unit-test (3.13)	3m 20s
integration-test	10m 54s
lint-and-unit-test (3.14)	2m 29s
lint-and-unit-test (3.12)	2m 51s
lint-and-unit-test (3.11)	3m 22s
integration-coverage-report	27s
	30m 55s

Provide feedback