On a Lotka-Volterra competition system: diffusion vs advection