{"action":"closed","issue":{"url":"https://api.github.com/repos/zombodb/zombodb/issues/198","repository_url":"https://api.github.com/repos/zombodb/zombodb","labels_url":"https://api.github.com/repos/zombodb/zombodb/issues/198/labels{/name}","comments_url":"https://api.github.com/repos/zombodb/zombodb/issues/198/comments","events_url":"https://api.github.com/repos/zombodb/zombodb/issues/198/events","html_url":"https://github.com/zombodb/zombodb/issues/198","id":214254690,"number":198,"title":"zdb_estimate_count returns '0' with no criteria on main table of join","user":{"login":"MarkMatte","id":15038790,"avatar_url":"https://avatars0.githubusercontent.com/u/15038790?v=3","gravatar_id":"","url":"https://api.github.com/users/MarkMatte","html_url":"https://github.com/MarkMatte","followers_url":"https://api.github.com/users/MarkMatte/followers","following_url":"https://api.github.com/users/MarkMatte/following{/other_user}","gists_url":"https://api.github.com/users/MarkMatte/gists{/gist_id}","starred_url":"https://api.github.com/users/MarkMatte/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MarkMatte/subscriptions","organizations_url":"https://api.github.com/users/MarkMatte/orgs","repos_url":"https://api.github.com/users/MarkMatte/repos","events_url":"https://api.github.com/users/MarkMatte/events{/privacy}","received_events_url":"https://api.github.com/users/MarkMatte/received_events","type":"User","site_admin":false},"labels":[{"id":237486354,"url":"https://api.github.com/repos/zombodb/zombodb/labels/bug","name":"bug","color":"fc2929","default":true},{"id":574124234,"url":"https://api.github.com/repos/zombodb/zombodb/labels/v3.1.11","name":"v3.1.11","color":"1d76db","default":false}],"state":"closed","locked":false,"assignee":{"login":"eeeebbbbrrrr","id":5117238,"avatar_url":"https://avatars0.githubusercontent.com/u/5117238?v=3","gravatar_id":"","url":"https://api.github.com/users/eeeebbbbrrrr","html_url":"https://github.com/eeeebbbbrrrr","followers_url":"https://api.github.com/users/eeeebbbbrrrr/followers","following_url":"https://api.github.com/users/eeeebbbbrrrr/following{/other_user}","gists_url":"https://api.github.com/users/eeeebbbbrrrr/gists{/gist_id}","starred_url":"https://api.github.com/users/eeeebbbbrrrr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eeeebbbbrrrr/subscriptions","organizations_url":"https://api.github.com/users/eeeebbbbrrrr/orgs","repos_url":"https://api.github.com/users/eeeebbbbrrrr/repos","events_url":"https://api.github.com/users/eeeebbbbrrrr/events{/privacy}","received_events_url":"https://api.github.com/users/eeeebbbbrrrr/received_events","type":"User","site_admin":false},"assignees":[{"login":"eeeebbbbrrrr","id":5117238,"avatar_url":"https://avatars0.githubusercontent.com/u/5117238?v=3","gravatar_id":"","url":"https://api.github.com/users/eeeebbbbrrrr","html_url":"https://github.com/eeeebbbbrrrr","followers_url":"https://api.github.com/users/eeeebbbbrrrr/followers","following_url":"https://api.github.com/users/eeeebbbbrrrr/following{/other_user}","gists_url":"https://api.github.com/users/eeeebbbbrrrr/gists{/gist_id}","starred_url":"https://api.github.com/users/eeeebbbbrrrr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eeeebbbbrrrr/subscriptions","organizations_url":"https://api.github.com/users/eeeebbbbrrrr/orgs","repos_url":"https://api.github.com/users/eeeebbbbrrrr/repos","events_url":"https://api.github.com/users/eeeebbbbrrrr/events{/privacy}","received_events_url":"https://api.github.com/users/eeeebbbbrrrr/received_events","type":"User","site_admin":false}],"milestone":null,"comments":5,"created_at":"2017-03-15T01:22:36Z","updated_at":"2017-04-17T17:31:03Z","closed_at":"2017-04-17T17:31:03Z","body":"```SQL\r\nzdbtaptests=# select count(*)  FROM \"unit_tests\".\"consolidated_record_view\" WHERE var_bigint_expand_group = 5;\r\n count\r\n-------\r\n     4\r\n(1 row)\r\n\r\nTime: 0.772 ms\r\n\r\nzdbtaptests=# SELECT * FROM zdb_estimate_count('unit_tests.consolidated_record_view', '( var_bigint_expand_group = 5  )');\r\n zdb_estimate_count\r\n--------------------\r\n                  0\r\n(1 row)\r\n\r\nTime: 7.107 ms\r\n\r\nzdbtaptests=# SELECT * FROM zdb_estimate_count('unit_tests.consolidated_record_view', '( pk_data:\"*\" AND var_bigint_expand_group = 5  )');\r\n zdb_estimate_count\r\n--------------------\r\n                  4\r\n(1 row)\r\n\r\nTime: 7.294 ms\r\n\r\nzdbtaptests=# select count(*)  FROM \"unit_tests\".\"consolidated_record_view\" WHERE zdb ==> '( var_bigint_expand_group = 5  )';\r\n count\r\n-------\r\n     4\r\n(1 row)\r\n\r\nTime: 13.022 ms\r\n```"}}
{"actor":{"display_login":"eeeebbbbrrrr"}}