Add test for UpdateStatistics chaining set and remove #9043

Job	Run time
integration-test-adls	1m 24s
cibw-dev-env-smoke-test	29s
integration-test-gcs	1m 22s
lint-and-unit-test (3.12)	58s
lint-and-unit-test (3.11)	59s
lint-and-unit-test (3.14)	1m 1s
lint-and-unit-test (3.13)	1m 7s
lint-and-unit-test (3.10)	54s
integration-test-s3	1m 15s
integration-test	10m 54s
integration-coverage-report	35s
	20m 58s

Provide feedback