Error 1156 if compression enabled by client (CLIENT_COMPRESS) and SQL select text is 27k long, 100% resproducible:
errno=1156(08S01), Got packets out of order

Never occurs if compression disabled.

See the full select text in attachment - vrfstaticroute_table_and_select.txt

Debugged it setting breakpoint on the places where "packets out of order" condition detected, e.g. on net_serv.cc's "goto packets_out_of_order", see gdb_mysqld_packets_out_of_order_1.txt

Workarounded it by changing if condition in my_real_read, see net_serv.cc.fixed:

if (net->buff[ net->where_b + 3 ] != ( uchar )net->pkt_nr)
=>
if (net->buff[ net->where_b + 3 ] != ( uchar )net->compress_pkt_nr
&&
net->buff[ net->where_b + 3 ] != ( uchar )net->pkt_nr)

But not sure at all if it is a correct solution