Add upsert regression test for non-join partition changes #8653

Job	Run time
cibw-dev-env-smoke-test	32s
integration-test	10m 26s
integration-test-adls	1m 15s
integration-test-s3	1m 19s
integration-test-gcs	1m 16s
lint-and-unit-test (3.10)	3m 4s
lint-and-unit-test (3.11)	3m 6s
lint-and-unit-test (3.12)	2m 57s
lint-and-unit-test (3.13)	3m 34s
lint-and-unit-test (3.14)	2m 32s
integration-coverage-report	30s
	30m 31s

Provide feedback