{"action":"created","issue":{"url":"https://api.github.com/repos/vitessio/vitess/issues/4387","repository_url":"https://api.github.com/repos/vitessio/vitess","labels_url":"https://api.github.com/repos/vitessio/vitess/issues/4387/labels{/name}","comments_url":"https://api.github.com/repos/vitessio/vitess/issues/4387/comments","events_url":"https://api.github.com/repos/vitessio/vitess/issues/4387/events","html_url":"https://github.com/vitessio/vitess/issues/4387","id":384081070,"node_id":"MDU6SXNzdWUzODQwODEwNzA=","number":4387,"title":"set session sql_mode='NO_ENGINE_SUBSTITUTION'","user":{"login":"hellracer","id":3840828,"node_id":"MDQ6VXNlcjM4NDA4Mjg=","avatar_url":"https://avatars3.githubusercontent.com/u/3840828?v=4","gravatar_id":"","url":"https://api.github.com/users/hellracer","html_url":"https://github.com/hellracer","followers_url":"https://api.github.com/users/hellracer/followers","following_url":"https://api.github.com/users/hellracer/following{/other_user}","gists_url":"https://api.github.com/users/hellracer/gists{/gist_id}","starred_url":"https://api.github.com/users/hellracer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hellracer/subscriptions","organizations_url":"https://api.github.com/users/hellracer/orgs","repos_url":"https://api.github.com/users/hellracer/repos","events_url":"https://api.github.com/users/hellracer/events{/privacy}","received_events_url":"https://api.github.com/users/hellracer/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-11-25T13:53:12Z","updated_at":"2018-11-25T22:13:52Z","closed_at":"2018-11-25T22:13:52Z","author_association":"NONE","body":"#### Overview of the Issue\r\n\r\nLaravel  connect to vtgate and does set this mode, but vtgate don't accept this as a valid construct\r\nset session sql_mode='NO_ENGINE_SUBSTITUTION'\r\n\r\n#### Reproduction Steps\r\n\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 16\r\nServer version: 5.5.10-Vitess Percona Server (GPL), Release '25', Revision '7e2732e'\r\n\r\nCopyright (c) 2009-2018 Percona LLC and/or its affiliates\r\nCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.\r\n\r\nOracle is a registered trademark of Oracle Corporation and/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql> set session sql_mode='NO_ENGINE_SUBSTITUTION';\r\nERROR 1105 (HY000): vtgate: http://etcd:15001/: unsupported construct: set session sql_mode='NO_ENGINE_SUBSTITUTION'\r\n\r\n1. Run `set session sql_mode='NO_ENGINE_SUBSTITUTION'`\r\n1. View error `ERROR 1105 (HY000): vtgate: http://etcd:15001/: unsupported construct: set session sql_mode='NO_ENGINE_SUBSTITUTION'`\r\n\r\n#### Binary version\r\nExample:\r\n\r\n```sh\r\ngiaquinti@workspace:~$ vtgate --version\r\nVersion: e232f21 (Git branch 'master') built on Thu Nov 22 07:32:04 PST 2018 by useradmin@etcd using go1.11.2 linux/amd64using go1.11.2 linux/amd6giaquinti@workspace using go1.10 linux/amd64\r\n```\r\n\r\n#### Operating system and Environment details\r\n\r\nUbuntu 16.04\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/vitessio/vitess/issues/comments/441478476","html_url":"https://github.com/vitessio/vitess/issues/4387#issuecomment-441478476","issue_url":"https://api.github.com/repos/vitessio/vitess/issues/4387","id":441478476,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTQ3ODQ3Ng==","user":{"login":"sougou","id":589370,"node_id":"MDQ6VXNlcjU4OTM3MA==","avatar_url":"https://avatars1.githubusercontent.com/u/589370?v=4","gravatar_id":"","url":"https://api.github.com/users/sougou","html_url":"https://github.com/sougou","followers_url":"https://api.github.com/users/sougou/followers","following_url":"https://api.github.com/users/sougou/following{/other_user}","gists_url":"https://api.github.com/users/sougou/gists{/gist_id}","starred_url":"https://api.github.com/users/sougou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sougou/subscriptions","organizations_url":"https://api.github.com/users/sougou/orgs","repos_url":"https://api.github.com/users/sougou/repos","events_url":"https://api.github.com/users/sougou/events{/privacy}","received_events_url":"https://api.github.com/users/sougou/received_events","type":"User","site_admin":false},"created_at":"2018-11-25T22:13:52Z","updated_at":"2018-11-25T22:13:52Z","author_association":"MEMBER","body":"FTR: This line was changed to make it work: https://github.com/laravel/framework/blob/5.7/src/Illuminate/Database/Connectors/MySqlConnector.php#L152"}}
{"actor":{"display_login":"sougou"}}