When will this happen ?

This is a fictitious post that could happen one day in cricket
Here is a newspaper report to dramatise the scenario
49.3 overs were bowled in the Australia versus South Africa 50 over match.
South Africa chasing 299 are 5/282 and needing 18 runs off 3 balls to win the match.
Jaques Kallis who came in with the score at 2/0 is 125 not out off 150 balls including 1 four 2 twos and 117 singles and was facing with 3 balls left.
Kallis who had played splendidly to this point was tired and in the previous 2 balls played 2 slogs that trickled to the fielders in the circle for no runs.
Kallis knelt down and appeared in a nauseous state, a few seconds later Kallis tells the umpires he is ill and is retiring hurt, the incoming batsman is Alby Morkel.
Morkel hits the next 3 balls out of the ground and South Africa win the match.
When will something similar to this happen in a limited overs match ?[or even a Test Match]
When will a struggling batsman retire hurt at any stage of a game to allow a big hitter to come in ?
When will this happen ?
Here is a newspaper report to dramatise the scenario
49.3 overs were bowled in the Australia versus South Africa 50 over match.
South Africa chasing 299 are 5/282 and needing 18 runs off 3 balls to win the match.
Jaques Kallis who came in with the score at 2/0 is 125 not out off 150 balls including 1 four 2 twos and 117 singles and was facing with 3 balls left.
Kallis who had played splendidly to this point was tired and in the previous 2 balls played 2 slogs that trickled to the fielders in the circle for no runs.
Kallis knelt down and appeared in a nauseous state, a few seconds later Kallis tells the umpires he is ill and is retiring hurt, the incoming batsman is Alby Morkel.
Morkel hits the next 3 balls out of the ground and South Africa win the match.
When will something similar to this happen in a limited overs match ?[or even a Test Match]
When will a struggling batsman retire hurt at any stage of a game to allow a big hitter to come in ?
When will this happen ?