{"action":"created","issue":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/603","repository_url":"https://api.github.com/repos/greenplum-db/gpdb","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/603/labels{/name}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/603/comments","events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/603/events","html_url":"https://github.com/greenplum-db/gpdb/pull/603","id":145928514,"number":603,"title":"DECLARE CURSOR don't error out during dispatch.","user":{"login":"xiong-gang","id":14144434,"avatar_url":"https://avatars.githubusercontent.com/u/14144434?v=3","gravatar_id":"","url":"https://api.github.com/users/xiong-gang","html_url":"https://github.com/xiong-gang","followers_url":"https://api.github.com/users/xiong-gang/followers","following_url":"https://api.github.com/users/xiong-gang/following{/other_user}","gists_url":"https://api.github.com/users/xiong-gang/gists{/gist_id}","starred_url":"https://api.github.com/users/xiong-gang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xiong-gang/subscriptions","organizations_url":"https://api.github.com/users/xiong-gang/orgs","repos_url":"https://api.github.com/users/xiong-gang/repos","events_url":"https://api.github.com/users/xiong-gang/events{/privacy}","received_events_url":"https://api.github.com/users/xiong-gang/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-04-05T09:09:15Z","updated_at":"2016-04-07T06:50:34Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/603","html_url":"https://github.com/greenplum-db/gpdb/pull/603","diff_url":"https://github.com/greenplum-db/gpdb/pull/603.diff","patch_url":"https://github.com/greenplum-db/gpdb/pull/603.patch"},"body":"In GPDB, QEs start execution once the plan of DECLARE CURSOR is dispatched, and the\r\nerrors of execution will be reported back to dispatcher. As threads are scheduled\r\nby OS, the execution sequence of multiple dispatcher threads is unpredictable, which\r\nwill make the behavior of DECLARE CURSOR inconsistent.\r\nThis fix keeps DECLARE CURSOR from erroring out in dispatch phase and the errors will\r\nbe reported during FETCH or at the end of the transaction."},"comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments/206720837","html_url":"https://github.com/greenplum-db/gpdb/pull/603#issuecomment-206720837","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/603","id":206720837,"user":{"login":"danielgustafsson","id":321790,"avatar_url":"https://avatars.githubusercontent.com/u/321790?v=3","gravatar_id":"","url":"https://api.github.com/users/danielgustafsson","html_url":"https://github.com/danielgustafsson","followers_url":"https://api.github.com/users/danielgustafsson/followers","following_url":"https://api.github.com/users/danielgustafsson/following{/other_user}","gists_url":"https://api.github.com/users/danielgustafsson/gists{/gist_id}","starred_url":"https://api.github.com/users/danielgustafsson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielgustafsson/subscriptions","organizations_url":"https://api.github.com/users/danielgustafsson/orgs","repos_url":"https://api.github.com/users/danielgustafsson/repos","events_url":"https://api.github.com/users/danielgustafsson/events{/privacy}","received_events_url":"https://api.github.com/users/danielgustafsson/received_events","type":"User","site_admin":false},"created_at":"2016-04-07T06:50:34Z","updated_at":"2016-04-07T06:50:34Z","body":"I agree with @ashwinstar, not sure I think this behaviour is an improvement. This seems to me like the sort of issue we should solve in the test harness (like how gpdiff/atmsort today handles a lot of output related things) rather than in Greenplum."}}