MDEV_6976: Assertion `! is_set() || m_can_overwrite_status' failed in Diagnostics_area::set_error_status on SET STATEMENT debug_sync

DEBUG_SYNC has complex logic of using different from other variables so it is prohibited in SEt STATENT