question #3 Sahih al-Bukhari 6814, Book 86, Hadith 43 : What are the implications of bearing witness against oneself in the context of Islamic legal proceedings?

A man from the tribe of Bani Aslam came to Allah’s Messenger (ﷺ) and Informed him that he had committed
illegal sexual intercourse and bore witness four times against himself. Allah’s Messenger (ﷺ) ordered him to
be stoned to death as he was a married Person.