{"action":"opened","issue":{"url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/4727","repository_url":"https://api.github.com/repos/bcit-ci/CodeIgniter","labels_url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/4727/labels{/name}","comments_url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/4727/comments","events_url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/4727/events","html_url":"https://github.com/bcit-ci/CodeIgniter/issues/4727","id":167571135,"number":4727,"title":"CI3 Feature Request, MySQL drivers: Add a possibility directly to set sql_mode per session.","user":{"login":"ivantcholakov","id":1438104,"avatar_url":"https://avatars.githubusercontent.com/u/1438104?v=3","gravatar_id":"","url":"https://api.github.com/users/ivantcholakov","html_url":"https://github.com/ivantcholakov","followers_url":"https://api.github.com/users/ivantcholakov/followers","following_url":"https://api.github.com/users/ivantcholakov/following{/other_user}","gists_url":"https://api.github.com/users/ivantcholakov/gists{/gist_id}","starred_url":"https://api.github.com/users/ivantcholakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ivantcholakov/subscriptions","organizations_url":"https://api.github.com/users/ivantcholakov/orgs","repos_url":"https://api.github.com/users/ivantcholakov/repos","events_url":"https://api.github.com/users/ivantcholakov/events{/privacy}","received_events_url":"https://api.github.com/users/ivantcholakov/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-07-26T10:11:31Z","updated_at":"2016-07-26T10:11:31Z","closed_at":null,"body":"In MySQL 5.7 some default options about sql_mode got changed. For example here is the case I've got:\r\n\r\nDevelopment machine:\r\nMySQL 5.7.13\r\nSELECT @@sql_mode;\r\nONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\r\n\r\nProduction server:\r\nMySQL 5.5.48\r\nSELECT @@sql_mode;\r\n(returns empty string)\r\n\r\nThere is a database connection setting:\r\n['stricton'] TRUE/FALSE - forces 'Strict Mode' connections - good for ensuring strict SQL while developing\r\nWhen it is true, STRICT_ALL_TABLES option gets enforced. When it is false, STRICT_ALL_TABLES and STRICT_TRANS_TABLES get disable. These are the cases this option covers currently. But I need to ensure that my development and production MySQL servers behave identically.\r\n\r\n--------------------------------------------\r\n\r\nCould ['stricton'] be made to accept string type that directly enumerates the sql_mode options directly?"}}
{"actor":{"display_login":"ivantcholakov"}}