Pipe IT: always throw exception with failure when executing non-queries & Fixed some semantic errors of IT

Pipe IT: always throw exception with failure when executing non-queries & Fixed some semantic errors of IT #3204