mysqldump: Allow setting multiple variables in one statement

[morgo]

Feature Description

Mysqldump from MySQL 8.0 requires setting multiple session vars in the one statement. These are session variables which should be safe for Vitess to parse but ignore:

mysql> SET SESSION NET_READ_TIMEOUT= 700;
Query OK, 0 rows affected (0.00 sec)

mysql> set SESSION NET_WRITE_TIMEOUT= 700;
Query OK, 0 rows affected (0.01 sec)

mysql> SET SESSION NET_READ_TIMEOUT= 700, SESSION NET_WRITE_TIMEOUT= 700;
ERROR 1105 (HY000): vtgate: http://morgox1:15001/: syntax error at position 61 near 'NET_WRITE_TIMEOUT'

The workaround is to add the option --skip-network-timeout to mysqldump. i.e.:

mysqldump  --lock-tables=off --quote-names --set-gtid-purged=OFF --no-tablespaces --skip-network-timeout commerce

[saifalharthi]

Multiple variables can be set like this mysql> SET SESSION NET_READ_TIMEOUT= 700, NET_WRITE_TIMEOUT= 700;

[aquarapid]

Accidentally reopened.