Language:
كتاب الحدود
86  
Limits and Punishments set by Allah (Hudood)
(4)
Chapter: Beating with stalks of date-palm leaves and shoes.
(4)
باب الضَّرْبِ بِالْجَرِيدِ وَالنِّعَالِ
Sahih al-Bukhari 6778

Narrated `Ali bin Abi Talib:

I would not feel sorry for one who dies because of receiving a legal punishment, except the drunk, for if he should die (when being punished), I would give blood money to his family because no fixed punishment has been ordered by Allah's Messenger (ﷺ) for the drunk.

حَدَّثَنَا عَبْدُ اللَّهِ بْنُ عَبْدِ الْوَهَّابِ، حَدَّثَنَا خَالِدُ بْنُ الْحَارِثِ، حَدَّثَنَا سُفْيَانُ، حَدَّثَنَا أَبُو حَصِينٍ، سَمِعْتُ عُمَيْرَ بْنَ سَعِيدٍ النَّخَعِيَّ، قَالَ سَمِعْتُ عَلِيَّ بْنَ أَبِي طَالِبٍ ـ رضى الله عنه ـ قَالَ مَا كُنْتُ لأُقِيمَ حَدًّا عَلَى أَحَدٍ فَيَمُوتَ، فَأَجِدَ فِي نَفْسِي، إِلاَّ صَاحِبَ الْخَمْرِ، فَإِنَّهُ لَوْ مَاتَ وَدَيْتُهُ، وَذَلِكَ أَنَّ رَسُولَ اللَّهِ صلى الله عليه وسلم لَمْ يَسُنَّهُ‏.‏
Reference : Sahih al-Bukhari 6778
In-book reference : Book 86, Hadith 7
USC-MSA web (English) reference : Vol. 8, Book 81, Hadith 769
  (deprecated numbering scheme)