PYTHON-5794 - Add prose tests to verify correct retry behavior when a… #801

Job	Run time
DocTest	1m 0s
Make an sdist	17s
Test minimum dependencies and Python	55s
static	3m 4s
Link Check	3m 34s
CPython pypy-3.11-ubuntu-latest	14m 12s
CPython 3.10-ubuntu-latest	13m 9s
CPython 3.13t-ubuntu-latest	13m 10s
Coverage	14m 14s
Typing Tests (3.10)	59s
Docs Checks	38s
Typing Tests (3.11)	1m 6s
Integration Tests	57s
Install from SDist and Test	1m 3s
	1h 8m 18s

Provide feedback