In "Legacy of Fire" we got three wishes, which i can remember.
1. turning the human wife of our elven player into an elf
2. splitting the mystic theurge of nethys into two characters
3. transforming the dragon disciple into a real dragon
the last two wishes were made at the end of the campaign to make the characters unplayable for future sessions etc.