{"action":"created","issue":{"url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/113","repository_url":"https://api.github.com/repos/tds-fdw/tds_fdw","labels_url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/113/labels{/name}","comments_url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/113/comments","events_url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/113/events","html_url":"https://github.com/tds-fdw/tds_fdw/issues/113","id":197556288,"number":113,"title":"Incorrect work of JOIN clause","user":{"login":"rentechpro","id":18398428,"avatar_url":"https://avatars.githubusercontent.com/u/18398428?v=3","gravatar_id":"","url":"https://api.github.com/users/rentechpro","html_url":"https://github.com/rentechpro","followers_url":"https://api.github.com/users/rentechpro/followers","following_url":"https://api.github.com/users/rentechpro/following{/other_user}","gists_url":"https://api.github.com/users/rentechpro/gists{/gist_id}","starred_url":"https://api.github.com/users/rentechpro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rentechpro/subscriptions","organizations_url":"https://api.github.com/users/rentechpro/orgs","repos_url":"https://api.github.com/users/rentechpro/repos","events_url":"https://api.github.com/users/rentechpro/events{/privacy}","received_events_url":"https://api.github.com/users/rentechpro/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-12-26T08:22:23Z","updated_at":"2016-12-29T15:12:53Z","closed_at":null,"body":"create foreign table ms_tables (\r\n    tab_name varchar(128),\r\n    col_name varchar(128),\r\n    typ_name varchar(128),\r\n    len smallint\r\n)\r\nserver fs_rc\r\noptions (query '\r\n    select so.name as tab_name, sc.name as col_name, st.name as typ_name, sc.length as len\r\n    from sysobjects so\r\n    join syscolumns sc on sc.id = so.id\r\n    join systypes st on st.xtype = sc.xtype\r\n    where so.xtype = ''U''\r\n    order by so.name, sc.colid;\r\n');\r\n\r\nselect count (1) from ms_tables; -- 109 rows\r\n\r\nselect count (1) -- 16 rows\r\nfrom information_schema.tables t\r\nwhere table_schema = 'dbo'\r\n  and table_type = 'BASE TABLE';\r\n\r\nselect count (1) -- 12 rows\r\nfrom information_schema.tables t\r\njoin ms_tables m on lower (m.tab_name) = lower (t.table_name)\r\nwhere table_schema = 'dbo'\r\n  and table_type = 'BASE TABLE';\r\n\r\nselect count (1) -- 103 rows\r\nfrom information_schema.tables t\r\nfull join ms_tables m on lower (m.tab_name) = lower (t.table_name)\r\nwhere table_schema = 'dbo'\r\n  and table_type = 'BASE TABLE';\r\n\r\nThe schema dbo has 16 same table names on both sides. but join see 1 the same table name only!\r\n\r\nThe full join sees all 16 table names but simple join see the same quantity.\r\n\r\nPostgres 9.6.1, tds_fdw-1.0.8, MS SQL 2008R2."},"comment":{"url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/comments/269643630","html_url":"https://github.com/tds-fdw/tds_fdw/issues/113#issuecomment-269643630","issue_url":"https://api.github.com/repos/tds-fdw/tds_fdw/issues/113","id":269643630,"user":{"login":"Smtgr14","id":799384,"avatar_url":"https://avatars.githubusercontent.com/u/799384?v=3","gravatar_id":"","url":"https://api.github.com/users/Smtgr14","html_url":"https://github.com/Smtgr14","followers_url":"https://api.github.com/users/Smtgr14/followers","following_url":"https://api.github.com/users/Smtgr14/following{/other_user}","gists_url":"https://api.github.com/users/Smtgr14/gists{/gist_id}","starred_url":"https://api.github.com/users/Smtgr14/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Smtgr14/subscriptions","organizations_url":"https://api.github.com/users/Smtgr14/orgs","repos_url":"https://api.github.com/users/Smtgr14/repos","events_url":"https://api.github.com/users/Smtgr14/events{/privacy}","received_events_url":"https://api.github.com/users/Smtgr14/received_events","type":"User","site_admin":false},"created_at":"2016-12-29T15:12:53Z","updated_at":"2016-12-29T15:12:53Z","body":"Can you clarify this issue a bit more?\r\nI'm not getting what the issue is exactly.\r\n  What result are you expecting?\r\n  What happens instead?\r\n  What steps are you taking that cause this to appear?"}}
{"actor":{"display_login":"Smtgr14"}}