{"action":"created","issue":{"url":"https://api.github.com/repos/Piiit/tpg/issues/54","labels_url":"https://api.github.com/repos/Piiit/tpg/issues/54/labels{/name}","comments_url":"https://api.github.com/repos/Piiit/tpg/issues/54/comments","events_url":"https://api.github.com/repos/Piiit/tpg/issues/54/events","html_url":"https://github.com/Piiit/tpg/issues/54","id":116304670,"number":54,"title":"SET OPERATIONS: Wrong renaming of second CTE if columns do not match the first CTE by position","user":{"login":"Piiit","id":6096063,"avatar_url":"https://avatars.githubusercontent.com/u/6096063?v=3","gravatar_id":"","url":"https://api.github.com/users/Piiit","html_url":"https://github.com/Piiit","followers_url":"https://api.github.com/users/Piiit/followers","following_url":"https://api.github.com/users/Piiit/following{/other_user}","gists_url":"https://api.github.com/users/Piiit/gists{/gist_id}","starred_url":"https://api.github.com/users/Piiit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Piiit/subscriptions","organizations_url":"https://api.github.com/users/Piiit/orgs","repos_url":"https://api.github.com/users/Piiit/repos","events_url":"https://api.github.com/users/Piiit/events{/privacy}","received_events_url":"https://api.github.com/users/Piiit/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Piiit/tpg/labels/3-IN%20DEVELOPMENT","name":"3-IN DEVELOPMENT","color":"009800"},{"url":"https://api.github.com/repos/Piiit/tpg/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/Piiit/tpg/milestones/1","html_url":"https://github.com/Piiit/tpg/milestones/First%20full%20version","labels_url":"https://api.github.com/repos/Piiit/tpg/milestones/1/labels","id":1406277,"number":1,"title":"First full version","description":"All operators should be implemented, but no details needed. Implement error handling, s.t. it does not cause server crashes.","creator":{"login":"Piiit","id":6096063,"avatar_url":"https://avatars.githubusercontent.com/u/6096063?v=3","gravatar_id":"","url":"https://api.github.com/users/Piiit","html_url":"https://github.com/Piiit","followers_url":"https://api.github.com/users/Piiit/followers","following_url":"https://api.github.com/users/Piiit/following{/other_user}","gists_url":"https://api.github.com/users/Piiit/gists{/gist_id}","starred_url":"https://api.github.com/users/Piiit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Piiit/subscriptions","organizations_url":"https://api.github.com/users/Piiit/orgs","repos_url":"https://api.github.com/users/Piiit/repos","events_url":"https://api.github.com/users/Piiit/events{/privacy}","received_events_url":"https://api.github.com/users/Piiit/received_events","type":"User","site_admin":false},"open_issues":6,"closed_issues":29,"state":"open","created_at":"2015-11-11T10:53:41Z","updated_at":"2015-12-22T13:32:36Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2015-11-11T10:24:08Z","updated_at":"2015-12-22T13:35:40Z","closed_at":"2015-12-22T10:19:05Z","body":"The columns of the second CTE get renamed to match the column names of the first. We do this because we want to use the normalizer USING clause to be more concise. \r\nCurrently we do not match the aliases to the correct positions inside the target list of the second CTE.\r\n\r\nExample query that fails:\r\n```\r\nselect a,b,t from e  \r\nUNION PERIOD WITH (t,t) \r\nselect b,t,a from f;\r\npsql:unibz/tests/test-temporal-setop.sql:84: ERROR:  function pg_catalog.lower(integer) does not exist\r\nHINT:  No function matches the given name and argument types. You might need to add explicit type casts.\r\n```  "},"comment":{"url":"https://api.github.com/repos/Piiit/tpg/issues/comments/166620091","html_url":"https://github.com/Piiit/tpg/issues/54#issuecomment-166620091","issue_url":"https://api.github.com/repos/Piiit/tpg/issues/54","id":166620091,"user":{"login":"Piiit","id":6096063,"avatar_url":"https://avatars.githubusercontent.com/u/6096063?v=3","gravatar_id":"","url":"https://api.github.com/users/Piiit","html_url":"https://github.com/Piiit","followers_url":"https://api.github.com/users/Piiit/followers","following_url":"https://api.github.com/users/Piiit/following{/other_user}","gists_url":"https://api.github.com/users/Piiit/gists{/gist_id}","starred_url":"https://api.github.com/users/Piiit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Piiit/subscriptions","organizations_url":"https://api.github.com/users/Piiit/orgs","repos_url":"https://api.github.com/users/Piiit/repos","events_url":"https://api.github.com/users/Piiit/events{/privacy}","received_events_url":"https://api.github.com/users/Piiit/received_events","type":"User","site_admin":false},"created_at":"2015-12-22T13:35:40Z","updated_at":"2015-12-22T13:35:40Z","body":"Belongs to #88."}}