{"action":"opened","issue":{"url":"https://api.github.com/repos/yandex/ClickHouse/issues/3711","repository_url":"https://api.github.com/repos/yandex/ClickHouse","labels_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3711/labels{/name}","comments_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3711/comments","events_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3711/events","html_url":"https://github.com/yandex/ClickHouse/issues/3711","id":386198367,"node_id":"MDU6SXNzdWUzODYxOTgzNjc=","number":3711,"title":"Support standard 'locate' SQL function","user":{"login":"dfulachier","id":44165041,"node_id":"MDQ6VXNlcjQ0MTY1MDQx","avatar_url":"https://avatars3.githubusercontent.com/u/44165041?v=4","gravatar_id":"","url":"https://api.github.com/users/dfulachier","html_url":"https://github.com/dfulachier","followers_url":"https://api.github.com/users/dfulachier/followers","following_url":"https://api.github.com/users/dfulachier/following{/other_user}","gists_url":"https://api.github.com/users/dfulachier/gists{/gist_id}","starred_url":"https://api.github.com/users/dfulachier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dfulachier/subscriptions","organizations_url":"https://api.github.com/users/dfulachier/orgs","repos_url":"https://api.github.com/users/dfulachier/repos","events_url":"https://api.github.com/users/dfulachier/events{/privacy}","received_events_url":"https://api.github.com/users/dfulachier/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-30T13:58:28Z","updated_at":"2018-11-30T13:58:28Z","closed_at":null,"author_association":"NONE","body":"ClickHouse proposes the 'position' function, and we can do with that.\r\nBut in some case (queries generated from a BI tool such as Tableau), we cannot master the SQL generated. So it may be fine to get the locate function, with both possible syntaxes:\r\n\r\n- locate(search, source)\r\n- locate(search, source, startPos)\r\n"}}
{"actor":{"display_login":"dfulachier"}}