{"action":"created","issue":{"url":"https://api.github.com/repos/pat/thinking-sphinx/issues/958","labels_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/958/labels{/name}","comments_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/958/comments","events_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/958/events","html_url":"https://github.com/pat/thinking-sphinx/issues/958","id":117340932,"number":958,"title":"sql_query_pre became sql_query_post_index after upgrading","user":{"login":"pixways-abarbotte","id":15875040,"avatar_url":"https://avatars.githubusercontent.com/u/15875040?v=3","gravatar_id":"","url":"https://api.github.com/users/pixways-abarbotte","html_url":"https://github.com/pixways-abarbotte","followers_url":"https://api.github.com/users/pixways-abarbotte/followers","following_url":"https://api.github.com/users/pixways-abarbotte/following{/other_user}","gists_url":"https://api.github.com/users/pixways-abarbotte/gists{/gist_id}","starred_url":"https://api.github.com/users/pixways-abarbotte/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pixways-abarbotte/subscriptions","organizations_url":"https://api.github.com/users/pixways-abarbotte/orgs","repos_url":"https://api.github.com/users/pixways-abarbotte/repos","events_url":"https://api.github.com/users/pixways-abarbotte/events{/privacy}","received_events_url":"https://api.github.com/users/pixways-abarbotte/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-17T12:04:32Z","updated_at":"2015-11-19T09:46:11Z","closed_at":null,"body":"Hi,\r\n\r\nI expose our versions first \r\n\r\nWe were like this in our previous application : \r\n-ruby 1.9.2p290 (2011-07-09 revision 32553) [x86_64-linux]\r\n-rails (3.2.18)\r\n-Sphinx 2.0.1-beta (r2792)\r\n-thinking-sphinx (2.0.9)\r\n-ts-delayed-delta (1.1.3)\r\n\r\nNow we are here : \r\n-ruby 2.1.1p76 (2014-02-24 revision 45161) [x86_64-linux]\r\n-rails (4.2.1)\r\n-Sphinx 2.2.6-id64-release (r4843)\r\n-thinking-sphinx (3.1.3)\r\n-ts-delayed-delta (2.0.2)\r\n\r\n\r\nAnd we encounter a strange thing when we are generating our production.sphinx.conf file \r\nwith rake ts:configure\r\nIt is about delta in index_core\r\n\r\nIn previous version, it was generating like this\r\nsql_query_pre = UPDATE `images` SET `delta` = 0 WHERE `delta` = 1\r\n\r\nBut now, this query is generated like this\r\nsql_query_post_index = UPDATE `images` SET `delta` = 0 WHERE `delta` = 1\r\n\r\n\r\nDid someone can help me about this ?\r\nI can provide more explanations/details if needed \r\n\r\nThanks in advance\r\n"},"comment":{"url":"https://api.github.com/repos/pat/thinking-sphinx/issues/comments/158005916","html_url":"https://github.com/pat/thinking-sphinx/issues/958#issuecomment-158005916","issue_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/958","id":158005916,"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":"2015-11-19T09:46:11Z","updated_at":"2015-11-19T09:46:11Z","body":"Okay, I've reverted this behaviour in the develop branch (see ac1529a9ad99bd39a9d3b279b96e497d589d70f8), so sql_query_pre is used again for resetting the delta flags. It's still not ideal, but I think it's better to have the data be consistent by the time a full index finishes, rather than waiting until the next time the task is called (which in your case could be a full day)."}}