{"action":"opened","issue":{"url":"https://api.github.com/repos/KazuakiM/vim-sqlfix/issues/11","labels_url":"https://api.github.com/repos/KazuakiM/vim-sqlfix/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/KazuakiM/vim-sqlfix/issues/11/comments","events_url":"https://api.github.com/repos/KazuakiM/vim-sqlfix/issues/11/events","html_url":"https://github.com/KazuakiM/vim-sqlfix/issues/11","id":123136797,"number":11,"title":"Support BETWEEN 〜 AND 〜","user":{"login":"KazuakiM","id":1524429,"avatar_url":"https://avatars.githubusercontent.com/u/1524429?v=3","gravatar_id":"","url":"https://api.github.com/users/KazuakiM","html_url":"https://github.com/KazuakiM","followers_url":"https://api.github.com/users/KazuakiM/followers","following_url":"https://api.github.com/users/KazuakiM/following{/other_user}","gists_url":"https://api.github.com/users/KazuakiM/gists{/gist_id}","starred_url":"https://api.github.com/users/KazuakiM/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KazuakiM/subscriptions","organizations_url":"https://api.github.com/users/KazuakiM/orgs","repos_url":"https://api.github.com/users/KazuakiM/repos","events_url":"https://api.github.com/users/KazuakiM/events{/privacy}","received_events_url":"https://api.github.com/users/KazuakiM/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/KazuakiM/vim-sqlfix/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-12-20T06:29:57Z","updated_at":"2015-12-20T06:29:57Z","closed_at":null,"body":"BETWEEN 〜 AND 〜 の ANDで改行処理が実行される。\r\n通常のANDとは意味が異なるため、改行されない事が望ましい。\r\n\r\n実行前\r\n```sql\r\nSELECT * FROM users WHERE birthday BETWEEN '2014-02-25 00:00:00' AND DATE_FORMAT('2015-02-25', '%Y-%m-%d 23:59:59');\r\n```\r\n修正前\r\n```sql\r\nSELECT *\r\nFROM users\r\nWHERE birthday BETWEEN '2014-02-25 00:00:00'\r\nAND DATE_FORMAT( '2015-02-25', '%Y-%m-%d 23:59:59');\r\n```\r\n修正後\r\n```sql\r\nSELECT *\r\nFROM users\r\nWHERE birthday BETWEEN '2014-02-25 00:00:00' AND DATE_FORMAT( '2015-02-25', '%Y-%m-%d 23:59:59');\r\n```"}}