Jose Canseco -- DUMPED BY FIANCEE ... 'He's an 'A-hole'

Jose Canseco's engagement is officially OVER ... with Leila Knight telling TMZ Sports she dumped the former MLB star because "he's an a**hole."One month after he shot himself in the finger ... nearly striking Leila in their Vegas home ... Knight…