{"action":"opened","issue":{"url":"https://api.github.com/repos/pingcap/tidb/issues/4762","repository_url":"https://api.github.com/repos/pingcap/tidb","labels_url":"https://api.github.com/repos/pingcap/tidb/issues/4762/labels{/name}","comments_url":"https://api.github.com/repos/pingcap/tidb/issues/4762/comments","events_url":"https://api.github.com/repos/pingcap/tidb/issues/4762/events","html_url":"https://github.com/pingcap/tidb/issues/4762","id":264910520,"number":4762,"title":"insert 0 timestamp in strict sql mode should failed","user":{"login":"zz-jason","id":5268763,"avatar_url":"https://avatars0.githubusercontent.com/u/5268763?v=4","gravatar_id":"","url":"https://api.github.com/users/zz-jason","html_url":"https://github.com/zz-jason","followers_url":"https://api.github.com/users/zz-jason/followers","following_url":"https://api.github.com/users/zz-jason/following{/other_user}","gists_url":"https://api.github.com/users/zz-jason/gists{/gist_id}","starred_url":"https://api.github.com/users/zz-jason/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zz-jason/subscriptions","organizations_url":"https://api.github.com/users/zz-jason/orgs","repos_url":"https://api.github.com/users/zz-jason/repos","events_url":"https://api.github.com/users/zz-jason/events{/privacy}","received_events_url":"https://api.github.com/users/zz-jason/received_events","type":"User","site_admin":false},"labels":[{"id":541179553,"url":"https://api.github.com/repos/pingcap/tidb/labels/compatibility","name":"compatibility","color":"e99695","default":false}],"state":"open","locked":false,"assignee":{"login":"zz-jason","id":5268763,"avatar_url":"https://avatars0.githubusercontent.com/u/5268763?v=4","gravatar_id":"","url":"https://api.github.com/users/zz-jason","html_url":"https://github.com/zz-jason","followers_url":"https://api.github.com/users/zz-jason/followers","following_url":"https://api.github.com/users/zz-jason/following{/other_user}","gists_url":"https://api.github.com/users/zz-jason/gists{/gist_id}","starred_url":"https://api.github.com/users/zz-jason/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zz-jason/subscriptions","organizations_url":"https://api.github.com/users/zz-jason/orgs","repos_url":"https://api.github.com/users/zz-jason/repos","events_url":"https://api.github.com/users/zz-jason/events{/privacy}","received_events_url":"https://api.github.com/users/zz-jason/received_events","type":"User","site_admin":false},"assignees":[{"login":"zz-jason","id":5268763,"avatar_url":"https://avatars0.githubusercontent.com/u/5268763?v=4","gravatar_id":"","url":"https://api.github.com/users/zz-jason","html_url":"https://github.com/zz-jason","followers_url":"https://api.github.com/users/zz-jason/followers","following_url":"https://api.github.com/users/zz-jason/following{/other_user}","gists_url":"https://api.github.com/users/zz-jason/gists{/gist_id}","starred_url":"https://api.github.com/users/zz-jason/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zz-jason/subscriptions","organizations_url":"https://api.github.com/users/zz-jason/orgs","repos_url":"https://api.github.com/users/zz-jason/repos","events_url":"https://api.github.com/users/zz-jason/events{/privacy}","received_events_url":"https://api.github.com/users/zz-jason/received_events","type":"User","site_admin":false},{"login":"XuHuaiyu","id":9039012,"avatar_url":"https://avatars1.githubusercontent.com/u/9039012?v=4","gravatar_id":"","url":"https://api.github.com/users/XuHuaiyu","html_url":"https://github.com/XuHuaiyu","followers_url":"https://api.github.com/users/XuHuaiyu/followers","following_url":"https://api.github.com/users/XuHuaiyu/following{/other_user}","gists_url":"https://api.github.com/users/XuHuaiyu/gists{/gist_id}","starred_url":"https://api.github.com/users/XuHuaiyu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/XuHuaiyu/subscriptions","organizations_url":"https://api.github.com/users/XuHuaiyu/orgs","repos_url":"https://api.github.com/users/XuHuaiyu/repos","events_url":"https://api.github.com/users/XuHuaiyu/events{/privacy}","received_events_url":"https://api.github.com/users/XuHuaiyu/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2017-10-12T11:48:03Z","updated_at":"2017-10-12T11:48:03Z","closed_at":null,"author_association":"MEMBER","body":"## 1. What did you do?\r\n\r\nin strict sql mode:\r\n\r\n```sql\r\ndrop table if exists t;\r\ncreate table t(a timestamp);\r\ninsert into t values(0);\r\n```\r\n\r\n## 2. What did you expect to see?\r\n\r\n```sql\r\nMySQL > insert into t values(0);\r\nERROR 1292 (22007): Incorrect datetime value: '0' for column 'a' at row 1\r\n```\r\n\r\n## 3. What did you see instead?\r\n\r\n```sql\r\nTiDB > insert into t values(0);\r\nQuery OK, 1 row affected (0.00 sec)\r\n```\r\n\r\n\r\n## 4. What version of TiDB are you using (`tidb-server -V`)?\r\n\r\n```bash\r\n$./bin/tidb-server -V\r\nRelease Version: 0.9.0\r\nGit Commit Hash: 60626912a7fb4f9f0ec449bd3aef17cf3d9b9ba5\r\nGit Commit Branch: master\r\nUTC Build Time:  2017-10-12 11:37:52\r\n```\r\n"}}
{"actor":{"display_login":"zz-jason"}}