The Diamonds will miss the gold medal match at the Commonwealth Games for the first time after being upset by Jamaica in a thrilling semi-final, 45-46.