pipe dream

From pipe +‎ dream, referring to the fantasies experienced when smoking an opium pipe. Compare Old English pīpdrēam (“the sound or music of a pipe”), which is formed identically but has a different meaning.