{"action":"created","issue":{"url":"https://api.github.com/repos/RedisLabsModules/RediSearch/issues/533","repository_url":"https://api.github.com/repos/RedisLabsModules/RediSearch","labels_url":"https://api.github.com/repos/RedisLabsModules/RediSearch/issues/533/labels{/name}","comments_url":"https://api.github.com/repos/RedisLabsModules/RediSearch/issues/533/comments","events_url":"https://api.github.com/repos/RedisLabsModules/RediSearch/issues/533/events","html_url":"https://github.com/RedisLabsModules/RediSearch/issues/533","id":378697295,"node_id":"MDU6SXNzdWUzNzg2OTcyOTU=","number":533,"title":"Search with prefix return unexpected result","user":{"login":"aburakovskiy","id":1153385,"node_id":"MDQ6VXNlcjExNTMzODU=","avatar_url":"https://avatars1.githubusercontent.com/u/1153385?v=4","gravatar_id":"","url":"https://api.github.com/users/aburakovskiy","html_url":"https://github.com/aburakovskiy","followers_url":"https://api.github.com/users/aburakovskiy/followers","following_url":"https://api.github.com/users/aburakovskiy/following{/other_user}","gists_url":"https://api.github.com/users/aburakovskiy/gists{/gist_id}","starred_url":"https://api.github.com/users/aburakovskiy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aburakovskiy/subscriptions","organizations_url":"https://api.github.com/users/aburakovskiy/orgs","repos_url":"https://api.github.com/users/aburakovskiy/repos","events_url":"https://api.github.com/users/aburakovskiy/events{/privacy}","received_events_url":"https://api.github.com/users/aburakovskiy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-08T11:49:25Z","updated_at":"2018-11-08T12:46:28Z","closed_at":null,"author_association":"NONE","body":"My index\r\n<img width=\"293\" alt=\"2018-11-08_1347\" src=\"https://user-images.githubusercontent.com/1153385/48197021-f4e5d700-e35c-11e8-86bb-89908de0c8e4.png\">\r\n\r\nI try to do search with prefix in this way:\r\n`FT.SEARCH locations '@name_normalized:(san francisco*)' `\r\naccording to the documentation this should be similar to sql query \r\n`name_normalized LIKE 'san francisco%'`\r\nand expect that in the result will be all records which begin from 'san francisco' but now I also get records which have some words before this phrase, e.g. 'south san francisco'\r\n<img width=\"290\" alt=\"2018-11-08_1344\" src=\"https://user-images.githubusercontent.com/1153385/48196842-6bcea000-e35c-11e8-9e48-60dada08cc57.png\">\r\nIs it possible to exclude these records from result?"},"comment":{"url":"https://api.github.com/repos/RedisLabsModules/RediSearch/issues/comments/436982301","html_url":"https://github.com/RedisLabsModules/RediSearch/issues/533#issuecomment-436982301","issue_url":"https://api.github.com/repos/RedisLabsModules/RediSearch/issues/533","id":436982301,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNjk4MjMwMQ==","user":{"login":"itamarhaber","id":6059516,"node_id":"MDQ6VXNlcjYwNTk1MTY=","avatar_url":"https://avatars2.githubusercontent.com/u/6059516?v=4","gravatar_id":"","url":"https://api.github.com/users/itamarhaber","html_url":"https://github.com/itamarhaber","followers_url":"https://api.github.com/users/itamarhaber/followers","following_url":"https://api.github.com/users/itamarhaber/following{/other_user}","gists_url":"https://api.github.com/users/itamarhaber/gists{/gist_id}","starred_url":"https://api.github.com/users/itamarhaber/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/itamarhaber/subscriptions","organizations_url":"https://api.github.com/users/itamarhaber/orgs","repos_url":"https://api.github.com/users/itamarhaber/repos","events_url":"https://api.github.com/users/itamarhaber/events{/privacy}","received_events_url":"https://api.github.com/users/itamarhaber/received_events","type":"User","site_admin":false},"created_at":"2018-11-08T12:46:28Z","updated_at":"2018-11-08T12:46:28Z","author_association":"CONTRIBUTOR","body":"Hello @aburakovskiy \r\n\r\nTEXT fields undergo automatic tokenization, rendering their contents into search terms. The query, therefore, returns all results with both 'san' and 'francisco''s prefices.\r\n\r\nInstead, use a TAG field (whose default separator is ',') for the effect that you're looking for. Makes sense?"}}
{"actor":{"display_login":"itamarhaber"}}