{"action":"created","issue":{"url":"https://api.github.com/repos/EC-CUBE/ec-cube/issues/1905","repository_url":"https://api.github.com/repos/EC-CUBE/ec-cube","labels_url":"https://api.github.com/repos/EC-CUBE/ec-cube/issues/1905/labels{/name}","comments_url":"https://api.github.com/repos/EC-CUBE/ec-cube/issues/1905/comments","events_url":"https://api.github.com/repos/EC-CUBE/ec-cube/issues/1905/events","html_url":"https://github.com/EC-CUBE/ec-cube/issues/1905","id":186683476,"number":1905,"title":"【管理画面】受注一覧のページング結果が正しくない場合がある","user":{"login":"hiroo2016","id":19830874,"avatar_url":"https://avatars.githubusercontent.com/u/19830874?v=3","gravatar_id":"","url":"https://api.github.com/users/hiroo2016","html_url":"https://github.com/hiroo2016","followers_url":"https://api.github.com/users/hiroo2016/followers","following_url":"https://api.github.com/users/hiroo2016/following{/other_user}","gists_url":"https://api.github.com/users/hiroo2016/gists{/gist_id}","starred_url":"https://api.github.com/users/hiroo2016/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hiroo2016/subscriptions","organizations_url":"https://api.github.com/users/hiroo2016/orgs","repos_url":"https://api.github.com/users/hiroo2016/repos","events_url":"https://api.github.com/users/hiroo2016/events{/privacy}","received_events_url":"https://api.github.com/users/hiroo2016/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-11-02T00:25:16Z","updated_at":"2016-11-02T04:27:17Z","closed_at":null,"body":"現在、update_dateが条件指定されていますが、更新日は同一になる可能性があるため、\r\n第二条件としてidを指定するなどしたほうが良いのではないかと考えます。\r\n\r\n更新日の同じレコードが1ページ目の一番下と、2ページ目の一番上に存在する状態で、\r\n2ページ目の関係のない（更新日が違う）受注データを削除したとき、\r\n再度ページングを試すと、1ページ目の一番下に表示されたレコードが2ページ目の一番上にも表示される、という現象が起こりました。（MySQL5.6）\r\n（この現象を確認できたのは、削除されたデータがある場合のみです）\r\n\r\norder byで指定したカラム以外の順序は保証されていないために起こるのだと思いますが、\r\nご確認のほどよろしくお願いいたします。\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/EC-CUBE/ec-cube/issues/comments/257769523","html_url":"https://github.com/EC-CUBE/ec-cube/issues/1905#issuecomment-257769523","issue_url":"https://api.github.com/repos/EC-CUBE/ec-cube/issues/1905","id":257769523,"user":{"login":"nanasess","id":815715,"avatar_url":"https://avatars.githubusercontent.com/u/815715?v=3","gravatar_id":"","url":"https://api.github.com/users/nanasess","html_url":"https://github.com/nanasess","followers_url":"https://api.github.com/users/nanasess/followers","following_url":"https://api.github.com/users/nanasess/following{/other_user}","gists_url":"https://api.github.com/users/nanasess/gists{/gist_id}","starred_url":"https://api.github.com/users/nanasess/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nanasess/subscriptions","organizations_url":"https://api.github.com/users/nanasess/orgs","repos_url":"https://api.github.com/users/nanasess/repos","events_url":"https://api.github.com/users/nanasess/events{/privacy}","received_events_url":"https://api.github.com/users/nanasess/received_events","type":"User","site_admin":false},"created_at":"2016-11-02T04:27:17Z","updated_at":"2016-11-02T04:27:17Z","body":"関連 #1837"}}
{"actor":{"display_login":"nanasess"}}