Mad Detective (2007)
Mad Detective (Chinese: 神探) is a 2007 Hong Kong psychological thriller film produced and directed by Johnnie To and Wai Ka-Fai. The film centers on Bun (Lau Ching-Wan), a schizophrenic, former police inspector who comes out of retirement to help a rookie detective (Andy On) solve a complex murder case, involving a missing colleague and a suspected policeman (Lam Ka-Tung) suffering from a multiple personality disorder.
More at Wikipedia.