Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support multiple session set statement syntax #6508

Closed
aquarapid opened this issue Jul 30, 2020 · 1 comment
Closed

Support multiple session set statement syntax #6508

aquarapid opened this issue Jul 30, 2020 · 1 comment
Milestone

Comments

@aquarapid
Copy link
Contributor

This is completely valid MySQL syntax, but does not work against Vitess 7.0:

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

Running them individually works fine:

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

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

unfortunately, certain connectors/clients that are not easy to modify use this syntax. A good example is mysqldump in MySQL 8.0, which actually sends the above timeout variables sequence to the server, which cannot be bypassed via mysqldump CLI options.

@harshit-gangal
Copy link
Member

harshit-gangal commented Jul 30, 2020

added support on master #6494

@askdba askdba added this to the v8.0 milestone Oct 6, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants