{"action":"created","issue":{"url":"https://api.github.com/repos/pat/thinking-sphinx/issues/1009","repository_url":"https://api.github.com/repos/pat/thinking-sphinx","labels_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/1009/labels{/name}","comments_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/1009/comments","events_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/1009/events","html_url":"https://github.com/pat/thinking-sphinx/issues/1009","id":174289067,"number":1009,"title":"indexes with a count","user":{"login":"atomical","id":329704,"avatar_url":"https://avatars.githubusercontent.com/u/329704?v=3","gravatar_id":"","url":"https://api.github.com/users/atomical","html_url":"https://github.com/atomical","followers_url":"https://api.github.com/users/atomical/followers","following_url":"https://api.github.com/users/atomical/following{/other_user}","gists_url":"https://api.github.com/users/atomical/gists{/gist_id}","starred_url":"https://api.github.com/users/atomical/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/atomical/subscriptions","organizations_url":"https://api.github.com/users/atomical/orgs","repos_url":"https://api.github.com/users/atomical/repos","events_url":"https://api.github.com/users/atomical/events{/privacy}","received_events_url":"https://api.github.com/users/atomical/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-08-31T14:31:20Z","updated_at":"2016-09-03T21:26:14Z","closed_at":null,"body":"Hi,\r\n\r\nI have an index with a count, but it lists the index as a string in mysql:\r\n\r\n```\r\n  indexes \"count(0)\", as: :present_user_count, type: :integer, sortable: true\r\n```\r\n\r\n```\r\n| present_user_count        | string    |\r\n```\r\n\r\nAny ideas?"},"comment":{"url":"https://api.github.com/repos/pat/thinking-sphinx/issues/comments/244570600","html_url":"https://github.com/pat/thinking-sphinx/issues/1009#issuecomment-244570600","issue_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/1009","id":244570600,"user":{"login":"pat","id":4183,"avatar_url":"https://avatars.githubusercontent.com/u/4183?v=3","gravatar_id":"","url":"https://api.github.com/users/pat","html_url":"https://github.com/pat","followers_url":"https://api.github.com/users/pat/followers","following_url":"https://api.github.com/users/pat/following{/other_user}","gists_url":"https://api.github.com/users/pat/gists{/gist_id}","starred_url":"https://api.github.com/users/pat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pat/subscriptions","organizations_url":"https://api.github.com/users/pat/orgs","repos_url":"https://api.github.com/users/pat/repos","events_url":"https://api.github.com/users/pat/events{/privacy}","received_events_url":"https://api.github.com/users/pat/received_events","type":"User","site_admin":false},"created_at":"2016-09-03T21:26:14Z","updated_at":"2016-09-03T21:26:14Z","body":"In the generated Sphinx configuration file, you'll find a `sql_query` setting for each source (which is paired to an index). Within the WHERE clause there are variables for a window on the primary key - you'll need to change those for real values (or remove those conditions if you want _all_ records returned - likely that'll be very slow though!)"}}
{"actor":{"display_login":"pat"}}