Add test for UpdateStatistics chaining set and remove #9042

Job	Run time
cibw-dev-env-smoke-test	32s
integration-test	7m 33s
integration-test-gcs	1m 9s
lint-and-unit-test (3.12)	1m 15s
lint-and-unit-test (3.10)	1m 6s
integration-test-s3	1m 10s
lint-and-unit-test (3.13)	59s
lint-and-unit-test (3.11)	1m 14s
integration-test-adls	1m 18s
lint-and-unit-test (3.14)	1m 7s
integration-coverage-report	1s
	17m 24s

Provide feedback