{"action":"created","issue":{"url":"https://api.github.com/repos/pat/thinking-sphinx/issues/935","labels_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/935/labels{/name}","comments_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/935/comments","events_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/935/events","html_url":"https://github.com/pat/thinking-sphinx/issues/935","id":99810877,"number":935,"title":"weird search result","user":{"login":"casiodk","id":632607,"avatar_url":"https://avatars.githubusercontent.com/u/632607?v=3","gravatar_id":"","url":"https://api.github.com/users/casiodk","html_url":"https://github.com/casiodk","followers_url":"https://api.github.com/users/casiodk/followers","following_url":"https://api.github.com/users/casiodk/following{/other_user}","gists_url":"https://api.github.com/users/casiodk/gists{/gist_id}","starred_url":"https://api.github.com/users/casiodk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/casiodk/subscriptions","organizations_url":"https://api.github.com/users/casiodk/orgs","repos_url":"https://api.github.com/users/casiodk/repos","events_url":"https://api.github.com/users/casiodk/events{/privacy}","received_events_url":"https://api.github.com/users/casiodk/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-08-08T16:09:34Z","updated_at":"2015-08-10T17:16:30Z","closed_at":null,"body":"given a customer\r\n\r\n```\r\nCustomer.create(address_street_name: \"Bjælkevej\", address_street_number: \"44\", rec_id: \"kj3\")\r\n```\r\n\r\nI get these seacrh results\r\n```\r\nCustomer.search \"jælkevej\", star: true, ranker: :bm25, with: { deleted_at: 0 }, page: 1, per_page: 15\r\n  Sphinx Query (0.6ms)  SELECT * FROM `customer_core`, `customer_delta` WHERE MATCH('*jælkevej*') AND `deleted_at` = 0 AND `sphinx_deleted` = 0 LIMIT 0, 15 OPTION ranker=bm25\r\n  Sphinx  Found 0 results\r\n```\r\n```\r\nCustomer.search \"ælkevej\", star: true, ranker: :bm25, with: { deleted_at: 0 }, page: 1, per_page: 15\r\n  Sphinx Query (0.6ms)  SELECT * FROM `customer_core`, `customer_delta` WHERE MATCH('*ælkevej*') AND `deleted_at` = 0 AND `sphinx_deleted` = 0 LIMIT 0, 15 OPTION ranker=bm25\r\n  Sphinx  Found 1 results\r\n  Customer Load (0.4ms)  SELECT \"customers\".* FROM \"customers\" WHERE \"customers\".\"id\" = 2\r\n => [#<Customer id: 2, address_city_name: nil, address_country_name: nil, name: nil, name_alias: nil, phone: nil, rec_id: \"kj3\", address_street_name: \"Bjælkevej\", address_street_number: \"44\", address_zip_code: nil, created_at: \"2015-08-08 16:03:58\", updated_at: \"2015-08-08 16:03:58\", address_additional_info: nil, street: nil, delta: true, imported_at: \"2015-08-08 16:03:58\", deleted_at: nil, email: nil>]\r\n```\r\n\r\nTHIS IS MY INDEX\r\n```\r\n# -*- encoding : utf-8 -*-\r\nThinkingSphinx::Index.define :customer, :with => :active_record, :delta => ThinkingSphinx::Deltas::DelayedDelta do\r\n  indexes name, as: :customer_name, infixes: true, sortable: true\r\n  indexes name_alias, as: :customer_name_alias, infixes: true, sortable: true\r\n  indexes [address_street_name, address_street_number, address_additional_info, address_zip_code, address_city_name, address_country_name, street], as: :customer_address, infixes: true, sortable: true\r\n  indexes rec_id, as: :customer_rec_id, infixes: true, sortable: true\r\n  has deleted_at\r\n  set_property :enable_star => true\r\n  set_property :min_infix_len => 1\r\n  set_property :html_strip => true\r\n  set_property :charset_type => \"utf-8\"\r\nend\r\n```"},"comment":{"url":"https://api.github.com/repos/pat/thinking-sphinx/issues/comments/129531342","html_url":"https://github.com/pat/thinking-sphinx/issues/935#issuecomment-129531342","issue_url":"https://api.github.com/repos/pat/thinking-sphinx/issues/935","id":129531342,"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-08-10T17:16:30Z","updated_at":"2015-08-10T17:16:30Z","body":"The fact that it passes on CircleCI does suggest it's probably a difference between the two environments. Does it pass in the test environment on your machine, as opposed to development? Do you know what version of Sphinx is being used on CircleCI?"}}