Add regression tests for SELECT FOR UPDATE/SHARE NOWAIT.

Thomas Munro