{"action":"created","issue":{"url":"https://api.github.com/repos/zombodb/zombodb/issues/132","repository_url":"https://api.github.com/repos/zombodb/zombodb","labels_url":"https://api.github.com/repos/zombodb/zombodb/issues/132/labels{/name}","comments_url":"https://api.github.com/repos/zombodb/zombodb/issues/132/comments","events_url":"https://api.github.com/repos/zombodb/zombodb/issues/132/events","html_url":"https://github.com/zombodb/zombodb/issues/132","id":165340101,"number":132,"title":"Nested #expand excludes non-group members ","user":{"login":"Shigoki","id":20440413,"avatar_url":"https://avatars.githubusercontent.com/u/20440413?v=3","gravatar_id":"","url":"https://api.github.com/users/Shigoki","html_url":"https://github.com/Shigoki","followers_url":"https://api.github.com/users/Shigoki/followers","following_url":"https://api.github.com/users/Shigoki/following{/other_user}","gists_url":"https://api.github.com/users/Shigoki/gists{/gist_id}","starred_url":"https://api.github.com/users/Shigoki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Shigoki/subscriptions","organizations_url":"https://api.github.com/users/Shigoki/orgs","repos_url":"https://api.github.com/users/Shigoki/repos","events_url":"https://api.github.com/users/Shigoki/events{/privacy}","received_events_url":"https://api.github.com/users/Shigoki/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-13T14:48:20Z","updated_at":"2016-07-13T17:26:06Z","closed_at":null,"body":"Using nested expand functionality in the example appears to lose the ability to include records that have no group value.\r\n\r\n```\r\n                                  Table \"public.expandtest\"\r\n  Column  |         Type          |                         Modifiers                          \r\n----------+-----------------------+------------------------------------------------------------\r\n pk_id    | bigint                | not null default nextval('expandtest_pk_id_seq'::regclass)\r\n name     | character varying(64) | \r\n group_id | character varying(64) | \r\nIndexes:\r\n    \"expandtest_pkey\" PRIMARY KEY, btree (pk_id)\r\n    \"es_expandtest\" zombodb (zdb('expandtest'::regclass, ctid), zdb(expandtest.*)) WITH (url='http://xxx.xx.xx.xx:pppp/', replicas='1', shards='5')\r\n\r\nselect * from expandtest;\r\n pk_id |   name   | group_id \r\n-------+----------+----------\r\n     1 | Franklin | g1\r\n     2 | Eleanor  | g1\r\n     3 | Theo     | g1\r\n     4 | Tommy    | \r\n     5 | Billy    | \r\n     6 | Georgie  | \r\n(6 rows)\r\n\r\nselect pk_id, name, group_id from expandtest where zdb('expandtest'::regclass, ctid) ==> '(pk_id < 6 AND (#expand<group_id=<this.index>group_id>(pk_id:3 OR pk_id:5)))';\r\n pk_id |   name   | group_id \r\n-------+----------+----------\r\n     1 | Franklin | g1\r\n     2 | Eleanor  | g1\r\n     3 | Theo     | g1\r\n     5 | Billy    | \r\n(4 rows)\r\n\r\n\r\nselect pk_id, name, group_id from expandtest where zdb('expandtest'::regclass, ctid) ==> '((#expand<group_id=<this.index>group_id>(pk_id < 6 AND #expand<group_id=<this.index>group_id>(pk_id:3 OR pk_id:5))))';\r\n pk_id |   name   | group_id \r\n-------+----------+----------\r\n     1 | Franklin | g1\r\n     2 | Eleanor  | g1\r\n     3 | Theo     | g1\r\n(3 rows)"},"comment":{"url":"https://api.github.com/repos/zombodb/zombodb/issues/comments/232426830","html_url":"https://github.com/zombodb/zombodb/issues/132#issuecomment-232426830","issue_url":"https://api.github.com/repos/zombodb/zombodb/issues/132","id":232426830,"user":{"login":"eeeebbbbrrrr","id":5117238,"avatar_url":"https://avatars.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},"created_at":"2016-07-13T17:26:06Z","updated_at":"2016-07-13T17:26:06Z","body":"Thanks for the report.  Which version of ZomboDB and if v3.0, are you also using the SIREn plugin?"}}
{"actor":{"display_login":"eeeebbbbrrrr"}}