{"action":"created","issue":{"url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/99","repository_url":"https://api.github.com/repos/tds-fdw/tds_fdw","labels_url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/99/labels{/name}","comments_url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/99/comments","events_url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/99/events","html_url":"https://github.com/tds-fdw/tds_fdw/issues/99","id":179070700,"number":99,"title":"DISTINCT doesn't work for 2.0.0-alpha1","user":{"login":"Loriowar","id":2118479,"avatar_url":"https://avatars.githubusercontent.com/u/2118479?v=3","gravatar_id":"","url":"https://api.github.com/users/Loriowar","html_url":"https://github.com/Loriowar","followers_url":"https://api.github.com/users/Loriowar/followers","following_url":"https://api.github.com/users/Loriowar/following{/other_user}","gists_url":"https://api.github.com/users/Loriowar/gists{/gist_id}","starred_url":"https://api.github.com/users/Loriowar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Loriowar/subscriptions","organizations_url":"https://api.github.com/users/Loriowar/orgs","repos_url":"https://api.github.com/users/Loriowar/repos","events_url":"https://api.github.com/users/Loriowar/events{/privacy}","received_events_url":"https://api.github.com/users/Loriowar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-09-25T06:06:56Z","updated_at":"2017-01-25T13:53:03Z","closed_at":null,"body":"Query `SELECT DISTINCT \"column_name\" FROM foreign_table;` doesn't work. This return duplicate entries in case of usage tds-fdw from branch `2.0.0-alpha1`. Branch `1.0.7` works as expected for the same query and the same environment.\n\nMy env:\n- Ubuntu 14.04\n- PostgreSQL 9.5\n- MSSQL 2012\n- freetds-common 0.91-5\n"},"comment":{"url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/comments/275112854","html_url":"https://github.com/tds-fdw/tds_fdw/issues/99#issuecomment-275112854","issue_url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/99","id":275112854,"user":{"login":"Loriowar","id":2118479,"avatar_url":"https://avatars.githubusercontent.com/u/2118479?v=3","gravatar_id":"","url":"https://api.github.com/users/Loriowar","html_url":"https://github.com/Loriowar","followers_url":"https://api.github.com/users/Loriowar/followers","following_url":"https://api.github.com/users/Loriowar/following{/other_user}","gists_url":"https://api.github.com/users/Loriowar/gists{/gist_id}","starred_url":"https://api.github.com/users/Loriowar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Loriowar/subscriptions","organizations_url":"https://api.github.com/users/Loriowar/orgs","repos_url":"https://api.github.com/users/Loriowar/repos","events_url":"https://api.github.com/users/Loriowar/events{/privacy}","received_events_url":"https://api.github.com/users/Loriowar/received_events","type":"User","site_admin":false},"created_at":"2017-01-25T13:53:03Z","updated_at":"2017-01-25T13:53:03Z","body":"This query still return duplications\r\n    SELECT DISTINCT ON (\"WMSLOCATIONID\") \"WMSLOCATIONID\" AS wmslocationid\r\n    FROM  wrc_ctrs\r\n    WHERE \"WMSLOCATIONID\" != '';\r\n\r\nYour variant has incorrect syntax for PG. I don't know how can work `DISTINCT ON` and `COUNT` in this query."}}
{"actor":{"display_login":"Loriowar"}}