order by+ lock in share mode/for update, lock clause is ignored

[actiontech-bot]

Raised by: @FlyingMao
Steps:

1. Query: select * from sbtest1 order by id lock in share mode;
2. General log:
   

[actiontech-bot]

By @FlyingMao

Followings are ignored in composite query:

• SQL_BIG_RESULT/SQL_SMALL_RESULT
• SQL_BUFFER_RESULT
• STRAIGHT_JOIN
• SQL_CACHE/SQL_NO_CACHE
• SQL_CALC_FOUND_ROWS
• for update/lock in share mode

[actiontech-bot]

By @yanhuqing666

Refer:

• https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html
• https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
• https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html

[irene-coming]

duplicate issue with #473