{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/7722","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/7722/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/7722/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/7722/events","html_url":"https://github.com/orientechnologies/orientdb/issues/7722","id":255468476,"number":7722,"title":"Incorrect result from count query","user":{"login":"Bankde","id":12493875,"avatar_url":"https://avatars3.githubusercontent.com/u/12493875?v=4","gravatar_id":"","url":"https://api.github.com/users/Bankde","html_url":"https://github.com/Bankde","followers_url":"https://api.github.com/users/Bankde/followers","following_url":"https://api.github.com/users/Bankde/following{/other_user}","gists_url":"https://api.github.com/users/Bankde/gists{/gist_id}","starred_url":"https://api.github.com/users/Bankde/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bankde/subscriptions","organizations_url":"https://api.github.com/users/Bankde/orgs","repos_url":"https://api.github.com/users/Bankde/repos","events_url":"https://api.github.com/users/Bankde/events{/privacy}","received_events_url":"https://api.github.com/users/Bankde/received_events","type":"User","site_admin":false},"labels":[{"id":550094349,"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/analyzing","name":"analyzing","color":"1d76db","default":false},{"id":356638774,"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/storage%20team","name":"storage team","color":"c5def5","default":false}],"state":"open","locked":false,"assignee":{"login":"laa","id":105066,"avatar_url":"https://avatars0.githubusercontent.com/u/105066?v=4","gravatar_id":"","url":"https://api.github.com/users/laa","html_url":"https://github.com/laa","followers_url":"https://api.github.com/users/laa/followers","following_url":"https://api.github.com/users/laa/following{/other_user}","gists_url":"https://api.github.com/users/laa/gists{/gist_id}","starred_url":"https://api.github.com/users/laa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laa/subscriptions","organizations_url":"https://api.github.com/users/laa/orgs","repos_url":"https://api.github.com/users/laa/repos","events_url":"https://api.github.com/users/laa/events{/privacy}","received_events_url":"https://api.github.com/users/laa/received_events","type":"User","site_admin":false},"assignees":[{"login":"laa","id":105066,"avatar_url":"https://avatars0.githubusercontent.com/u/105066?v=4","gravatar_id":"","url":"https://api.github.com/users/laa","html_url":"https://github.com/laa","followers_url":"https://api.github.com/users/laa/followers","following_url":"https://api.github.com/users/laa/following{/other_user}","gists_url":"https://api.github.com/users/laa/gists{/gist_id}","starred_url":"https://api.github.com/users/laa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laa/subscriptions","organizations_url":"https://api.github.com/users/laa/orgs","repos_url":"https://api.github.com/users/laa/repos","events_url":"https://api.github.com/users/laa/events{/privacy}","received_events_url":"https://api.github.com/users/laa/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/88","html_url":"https://github.com/orientechnologies/orientdb/milestone/88","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/88/labels","id":1768027,"number":88,"title":"2.2.x (next hotfix)","description":"","creator":{"login":"robfrank","id":413587,"avatar_url":"https://avatars3.githubusercontent.com/u/413587?v=4","gravatar_id":"","url":"https://api.github.com/users/robfrank","html_url":"https://github.com/robfrank","followers_url":"https://api.github.com/users/robfrank/followers","following_url":"https://api.github.com/users/robfrank/following{/other_user}","gists_url":"https://api.github.com/users/robfrank/gists{/gist_id}","starred_url":"https://api.github.com/users/robfrank/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robfrank/subscriptions","organizations_url":"https://api.github.com/users/robfrank/orgs","repos_url":"https://api.github.com/users/robfrank/repos","events_url":"https://api.github.com/users/robfrank/events{/privacy}","received_events_url":"https://api.github.com/users/robfrank/received_events","type":"User","site_admin":false},"open_issues":160,"closed_issues":10,"state":"open","created_at":"2016-05-16T08:28:14Z","updated_at":"2017-09-08T10:21:36Z","due_on":null,"closed_at":null},"comments":16,"created_at":"2017-09-06T03:18:03Z","updated_at":"2017-09-11T03:59:07Z","closed_at":null,"author_association":"NONE","body":"### OrientDB Version: 2.23\r\n### Java Version: 1.8.0\r\n### OS: freeBSD 10.3\r\n\r\nI have encountered strange result during \"count\" query. Im not sure if this is actual bug or just my misunderstanding.\r\n\r\n## Expected behavior  \r\ncount * and count rid should have equal number.\r\n\r\n## Actual behavior  \r\nThese queries are in 2.2.23.\r\n```\r\nselect count(@rid) from transactions  -  792743\r\nselect count(*) from transactions  -  1276958\r\n```\r\nI thought rid can never be null ?\r\nI even check if there is any record that rid is NULL but there is none.\r\n```\r\nselect * from transactions where @rid is NULL  -  nothing\r\n```\r\n\r\nThen I realized we just upgraded ordb from 2.2.4 to 2.2.23. So I went back to query in 2.2.4 if it works correctly.\r\n```\r\nselect count(*) from transactions  -  1276958\r\nselect count(@rid) from transactions  -  810532\r\n```\r\nNotice count(rid) result from v2.2.4 is not even equal to result from v2.2.23.\r\n \r\n\r\n--\r\n\r\n\r\n\r\n\r\n## Steps to reproduce  \r\nI don't know how this happen.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/328409453","html_url":"https://github.com/orientechnologies/orientdb/issues/7722#issuecomment-328409453","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/7722","id":328409453,"user":{"login":"Bankde","id":12493875,"avatar_url":"https://avatars3.githubusercontent.com/u/12493875?v=4","gravatar_id":"","url":"https://api.github.com/users/Bankde","html_url":"https://github.com/Bankde","followers_url":"https://api.github.com/users/Bankde/followers","following_url":"https://api.github.com/users/Bankde/following{/other_user}","gists_url":"https://api.github.com/users/Bankde/gists{/gist_id}","starred_url":"https://api.github.com/users/Bankde/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bankde/subscriptions","organizations_url":"https://api.github.com/users/Bankde/orgs","repos_url":"https://api.github.com/users/Bankde/repos","events_url":"https://api.github.com/users/Bankde/events{/privacy}","received_events_url":"https://api.github.com/users/Bankde/received_events","type":"User","site_admin":false},"created_at":"2017-09-11T03:59:07Z","updated_at":"2017-09-11T03:59:07Z","author_association":"NONE","body":"Any update on these issues ?"}}
{"actor":{"display_login":"Bankde"}}