D&D writers were on drugs in the 70's.

[Ryzorrin]

This is description from the campaign module "In Search of the Unknown," copyrighted 1979.

XXXI. ROOM OF POOLS.

f) Pool of wine -- This pool is filled with powerful wine of a deep red color. Not only is it excellent wine, it has a taste so inviting that anyone tasting it will be prone to drink more and more until intoxicated! If a sip is taken, the taster will have a 60% chance of drinking more (regardless of the player's wishes). If this is done, three 6-sided dice are thrown and compared to the character's constitution rating; if the number rolled is greater than the character's constitution score, then the difference is figured, and this is the number of hours the character will be intoxicated (if the roll is equal or less, the character "holds his liquor" and is unaffected. Any character so intoxicated wil suffer the following penalties: -2 on all rolls "to hit" in combat, -3 to dexterity rating, and any other disadvantages to being drunk that the DM may deem in effect (prone to loud and boisterous speech, stumbling about, a greater chance to be surprised, etc.) After the allotted number of hours have passed, the character returns to normal. Any intoxicated character who returns to the pool of wine will have a 90% chance of drinking too much again, and the check against constitution will then be necessitated once more. If any of the wine is removed from the room, it will immediately lose its potency and be considered as normal wine, but actually rather weak in its effects.

k) Fish pool - This pool of normal lake water holds numerous small fish. It has no other special properties, nor are the fish unusual in any way.

CAVERN OF THE MYSTICAL STONE

on a roll of 17: "Causes idiocy for 1-4 hours (unable to function intelligently or fight, must be led by other adventurers.)"
on a roll of 19: "Gives a curse: the character will sleep for 72 straight each month, beginning one day before and ending one day after each new moon (can only be removed by a remove curse spell."

I remember seeing a while ago something about a potion or something of gender change as well, but I can't seem to find where in the booklet it is.

[Assirra]

*snark* I love the pool of fish

[Ryzorrin]

OF course there's always the girdle of sex-change. Which loses it's effect after you put it on, and since it's cursed, you can't take it off without a remove curse. They never brought this item over (officially) to 3rd or 3.5.