The Messenger of Allah would become sexually impure then sleep as he was, without touching water. (Da'if)Sufyan said: "I mentioned this Hadith one day, and Isma'il said to me: 'O young man, you should support this Hadith with something else.'"
أَنَّ رَسُولَ اللَّهِ ﷺ كَانَ يُجْنِبُ ثُمَّ يَنَامُ كَهَيْئَتِهِ لاَ يَمَسُّ مَاءً قَالَ سُفْيَانُ فَذَكَرْتُ الْحَدِيثَ يَوْمًا فَقَالَ لِي إِسْمَاعِيلُ يَا فَتًى يُشَدُّ هَذَا الْحَدِيثُ بِشَىْءٍ