{"action":"created","issue":{"url":"https://api.github.com/repos/apache/incubator-trafodion/issues/577","repository_url":"https://api.github.com/repos/apache/incubator-trafodion","labels_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/577/labels{/name}","comments_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/577/comments","events_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/577/events","html_url":"https://github.com/apache/incubator-trafodion/pull/577","id":164103710,"number":577,"title":"[TRAFODION-1673] support with clause","user":{"login":"traflm","id":12948514,"avatar_url":"https://avatars.githubusercontent.com/u/12948514?v=3","gravatar_id":"","url":"https://api.github.com/users/traflm","html_url":"https://github.com/traflm","followers_url":"https://api.github.com/users/traflm/followers","following_url":"https://api.github.com/users/traflm/following{/other_user}","gists_url":"https://api.github.com/users/traflm/gists{/gist_id}","starred_url":"https://api.github.com/users/traflm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/traflm/subscriptions","organizations_url":"https://api.github.com/users/traflm/orgs","repos_url":"https://api.github.com/users/traflm/repos","events_url":"https://api.github.com/users/traflm/events{/privacy}","received_events_url":"https://api.github.com/users/traflm/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":16,"created_at":"2016-07-06T15:26:51Z","updated_at":"2016-07-14T06:59:26Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/577","html_url":"https://github.com/apache/incubator-trafodion/pull/577","diff_url":"https://github.com/apache/incubator-trafodion/pull/577.diff","patch_url":"https://github.com/apache/incubator-trafodion/pull/577.patch"},"body":"initial support new SQL syntax 'WITH', which required in many use cases, for example, in 35 TPCDS queries.\r\nThis change will transform the WITH definition into table typed sub-query, so can be used in later compile phases.\r\nAs tested, in 35 TPCDS queries that contains WITH, this change pass 19 of them , others due to other syntax gap, like rollup. The passed TPCDS queries include:\r\n q1\r\nq2\r\nq4\r\nq11\r\nq23\r\nq24\r\nq30\r\nq31\r\nq33\r\nq51\r\nq54\r\nq56\r\nq58\r\nq59\r\nq60\r\nq64\r\nq81\r\nq83\r\nq97\r\n\r\nSince still not widely tested, this syntax is still protected by MODE_SPECIAL_4 CQD.\r\n\r\nPlease help to code review it. "},"comment":{"url":"https://api.github.com/repos/apache/incubator-trafodion/issues/comments/232576818","html_url":"https://github.com/apache/incubator-trafodion/pull/577#issuecomment-232576818","issue_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/577","id":232576818,"user":{"login":"traflm","id":12948514,"avatar_url":"https://avatars.githubusercontent.com/u/12948514?v=3","gravatar_id":"","url":"https://api.github.com/users/traflm","html_url":"https://github.com/traflm","followers_url":"https://api.github.com/users/traflm/followers","following_url":"https://api.github.com/users/traflm/following{/other_user}","gists_url":"https://api.github.com/users/traflm/gists{/gist_id}","starred_url":"https://api.github.com/users/traflm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/traflm/subscriptions","organizations_url":"https://api.github.com/users/traflm/orgs","repos_url":"https://api.github.com/users/traflm/repos","events_url":"https://api.github.com/users/traflm/events{/privacy}","received_events_url":"https://api.github.com/users/traflm/received_events","type":"User","site_admin":false},"created_at":"2016-07-14T06:59:26Z","updated_at":"2016-07-14T06:59:26Z","body":"@selvaganesang trafci works with this with_clause as well. \r\n@venkat1m how to check repository compatibility? Is there any hint where should I look at?"}}
{"actor":{"display_login":"traflm"}}