3154227 - Trigger not working as expected. - SAP ASE

• Trigger set to delete records, is not working as expected. 
• When used with a set rowcount 1 -- it works as expected and fires the trigger - to rollback.
• When set rowcount 0 -- it does not work as expected - it does not fire the trigger and data is deleted.
  create trigger mytable_delete 
  on mytable 
  for delete as
  set rowcount 0 
  if  (select count(*)
      from deleted, mytable 
      where mytable.LoginName = deleted.LoginName and deleted.LoginName in ('login1','login3','login2')) > 0
    begin 
      rollback transaction 
      print "You are not allowed to delete login1 , login3 or login2 entries from mytable , Contact Engineering Team"
    end
  go

SAP Adaptive Server Enterprise (ASE) 16.0

delete trigger issue, rollback not firing, delete operation anomaly, trigger rollback failure, data deletion problem, database trigger debugging, delete trigger set issue, rollback transaction error, trigger execution problem, database record deletion, troubleshooting, trigger bug, database rollback issue, delete trigger configuration , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To