{"action":"created","issue":{"url":"https://api.github.com/repos/couchbase/couchbase-lite-net/issues/609","repository_url":"https://api.github.com/repos/couchbase/couchbase-lite-net","labels_url":"https://api.github.com/repos/couchbase/couchbase-lite-net/issues/609/labels{/name}","comments_url":"https://api.github.com/repos/couchbase/couchbase-lite-net/issues/609/comments","events_url":"https://api.github.com/repos/couchbase/couchbase-lite-net/issues/609/events","html_url":"https://github.com/couchbase/couchbase-lite-net/issues/609","id":140248251,"number":609,"title":"After purging a doc, its rows are left behind in view indexes","user":{"login":"snej","id":43241,"avatar_url":"https://avatars.githubusercontent.com/u/43241?v=3","gravatar_id":"","url":"https://api.github.com/users/snej","html_url":"https://github.com/snej","followers_url":"https://api.github.com/users/snej/followers","following_url":"https://api.github.com/users/snej/following{/other_user}","gists_url":"https://api.github.com/users/snej/gists{/gist_id}","starred_url":"https://api.github.com/users/snej/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snej/subscriptions","organizations_url":"https://api.github.com/users/snej/orgs","repos_url":"https://api.github.com/users/snej/repos","events_url":"https://api.github.com/users/snej/events{/privacy}","received_events_url":"https://api.github.com/users/snej/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-11T17:44:41Z","updated_at":"2016-03-12T07:42:11Z","closed_at":null,"body":"See https://github.com/couchbase/couchbase-lite-ios/issues/1164"},"comment":{"url":"https://api.github.com/repos/couchbase/couchbase-lite-net/issues/comments/195684939","html_url":"https://github.com/couchbase/couchbase-lite-net/issues/609#issuecomment-195684939","issue_url":"https://api.github.com/repos/couchbase/couchbase-lite-net/issues/609","id":195684939,"user":{"login":"borrrden","id":2470288,"avatar_url":"https://avatars.githubusercontent.com/u/2470288?v=3","gravatar_id":"","url":"https://api.github.com/users/borrrden","html_url":"https://github.com/borrrden","followers_url":"https://api.github.com/users/borrrden/followers","following_url":"https://api.github.com/users/borrrden/following{/other_user}","gists_url":"https://api.github.com/users/borrrden/gists{/gist_id}","starred_url":"https://api.github.com/users/borrrden/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/borrrden/subscriptions","organizations_url":"https://api.github.com/users/borrrden/orgs","repos_url":"https://api.github.com/users/borrrden/repos","events_url":"https://api.github.com/users/borrrden/events{/privacy}","received_events_url":"https://api.github.com/users/borrrden/received_events","type":"User","site_admin":false},"created_at":"2016-03-12T07:42:11Z","updated_at":"2016-03-12T07:42:11Z","body":"@snej My testing shows that when a document is purged its revisions are removed from the revs table.  Isn't it due to the ON DELETE CASCADE statement on the view index?"}}