{"action":"created","issue":{"url":"https://api.github.com/repos/citusdata/citus/issues/705","repository_url":"https://api.github.com/repos/citusdata/citus","labels_url":"https://api.github.com/repos/citusdata/citus/issues/705/labels{/name}","comments_url":"https://api.github.com/repos/citusdata/citus/issues/705/comments","events_url":"https://api.github.com/repos/citusdata/citus/issues/705/events","html_url":"https://github.com/citusdata/citus/issues/705","id":169441034,"number":705,"title":"Regression tests don't pass with upcoming 9.5 release","user":{"login":"anarazel","id":1598211,"avatar_url":"https://avatars.githubusercontent.com/u/1598211?v=3","gravatar_id":"","url":"https://api.github.com/users/anarazel","html_url":"https://github.com/anarazel","followers_url":"https://api.github.com/users/anarazel/followers","following_url":"https://api.github.com/users/anarazel/following{/other_user}","gists_url":"https://api.github.com/users/anarazel/gists{/gist_id}","starred_url":"https://api.github.com/users/anarazel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anarazel/subscriptions","organizations_url":"https://api.github.com/users/anarazel/orgs","repos_url":"https://api.github.com/users/anarazel/repos","events_url":"https://api.github.com/users/anarazel/events{/privacy}","received_events_url":"https://api.github.com/users/anarazel/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/citusdata/citus/labels/1-2%20days","name":"1-2 days","color":"f7c6c7"},{"url":"https://api.github.com/repos/citusdata/citus/labels/backport","name":"backport","color":"d93f0b"},{"url":"https://api.github.com/repos/citusdata/citus/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/citusdata/citus/milestones/6","html_url":"https://github.com/citusdata/citus/milestones/5.3%20Release","labels_url":"https://api.github.com/repos/citusdata/citus/milestones/6/labels","id":1900278,"number":6,"title":"5.3 Release","description":"Citus 5.3 Release","creator":{"login":"ozgune","id":2545443,"avatar_url":"https://avatars.githubusercontent.com/u/2545443?v=3","gravatar_id":"","url":"https://api.github.com/users/ozgune","html_url":"https://github.com/ozgune","followers_url":"https://api.github.com/users/ozgune/followers","following_url":"https://api.github.com/users/ozgune/following{/other_user}","gists_url":"https://api.github.com/users/ozgune/gists{/gist_id}","starred_url":"https://api.github.com/users/ozgune/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ozgune/subscriptions","organizations_url":"https://api.github.com/users/ozgune/orgs","repos_url":"https://api.github.com/users/ozgune/repos","events_url":"https://api.github.com/users/ozgune/events{/privacy}","received_events_url":"https://api.github.com/users/ozgune/received_events","type":"User","site_admin":false},"open_issues":21,"closed_issues":1,"state":"open","created_at":"2016-07-23T19:01:37Z","updated_at":"2016-08-11T22:10:11Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-08-04T18:23:47Z","updated_at":"2016-08-12T07:45:19Z","closed_at":null,"body":"```\r\nCREATE MATERIALIZED VIEW mv_articles_hash AS\r\n        SELECT * FROM articles_hash WHERE author_id = 1 WITH NO DATA;\r\n-DEBUG:  predicate pruning for shardId 840001\r\n-DEBUG:  Creating router plan\r\n-DEBUG:  Plan is router executable\r\n-ERROR:  scan directions other than forward scans are unsupported\r\n```\r\n\r\nDue to a bugfix this now works. I'm kind of inclined to just remove that test, rather than duplicate the output for the two versions."},"comment":{"url":"https://api.github.com/repos/citusdata/citus/issues/comments/239382311","html_url":"https://github.com/citusdata/citus/issues/705#issuecomment-239382311","issue_url":"https://api.github.com/repos/citusdata/citus/issues/705","id":239382311,"user":{"login":"mtuncer","id":9413470,"avatar_url":"https://avatars.githubusercontent.com/u/9413470?v=3","gravatar_id":"","url":"https://api.github.com/users/mtuncer","html_url":"https://github.com/mtuncer","followers_url":"https://api.github.com/users/mtuncer/followers","following_url":"https://api.github.com/users/mtuncer/following{/other_user}","gists_url":"https://api.github.com/users/mtuncer/gists{/gist_id}","starred_url":"https://api.github.com/users/mtuncer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtuncer/subscriptions","organizations_url":"https://api.github.com/users/mtuncer/orgs","repos_url":"https://api.github.com/users/mtuncer/repos","events_url":"https://api.github.com/users/mtuncer/events{/privacy}","received_events_url":"https://api.github.com/users/mtuncer/received_events","type":"User","site_admin":false},"created_at":"2016-08-12T07:45:19Z","updated_at":"2016-08-12T07:45:19Z","body":"I am also for removing the test.  This change would most likely to go into 9.6 if it hasn't made it yet.\r\n 9.5.4 change log says\r\n\r\n> Do not run the planner on the query contained in CREATE MATERIALIZED VIEW or CREATE TABLE AS when WITH NO DATA is specified (Michael Paquier, Tom Lane)\r\n> \r\n> This avoids some unnecessary failure conditions, for example if a stable function invoked by the materialized view depends on a table that doesn't exist yet.\r\n\r\n\r\n"}}
{"actor":{"display_login":"mtuncer"}}