kdonnel
DVC-BCV
- Joined
- Feb 1, 2001
- Messages
- 7,086
https://www.cnn.com/2024/08/26/sport/mlb-player-history-two-teams-spt-intl/index.html
Danny Jansen made Major League Baseball history Monday by becoming the first player to play for two teams in the same game.
Sounds impossible until you read the story.
The same player being recorded in the game for two different teams seems like an edge case that no one thought about when designing a database or some queries for that database.
Danny Jansen made Major League Baseball history Monday by becoming the first player to play for two teams in the same game.
Sounds impossible until you read the story.
On June 26, Jansen was a member of the Toronto Blue Jays. At the time, he was in the middle of an at-bat against the Red Sox in a scoreless game at Fenway Park.
But that game was suspended due to weather in the top of the second inning with a runner on first base and one out.
It took two months for the contest to resume and during the wait, Jansen switched teams when Toronto traded him to Boston for three prospects.
When the suspended game continued Monday, Blue Jays center fielder Daulton Varsho pinch hit for Jansen.
Jansen started the resumed game behind home plate as a defensive substitution for catcher Reese McGuire, who was designated for assignment last month by Boston, for what was Jansen’s own at-bat.
The same player being recorded in the game for two different teams seems like an edge case that no one thought about when designing a database or some queries for that database.