GitHub user huor opened a pull request:
https://github.com/apache/incubator-hawq/pull/659
HAWQ-738. Allocate query resource twice in function call through jdbc
Root cause analysis:
1. It uses exec_parse_message and exec_bind_message and allocate query
resource twice in parse and bind phases accordingly when using jdbc to call the
function: SELECT public.fn_debug(). Thus query resource is allocated twice in
function call through jdbc.
2. It uses exec_simple_query and allocate query resource there on once when
using psql/libpq to call the function: SELECT public.fn_debug().
The resolution is to do not allocate query resource in parse, and only
allocate query resource in bind.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/huor/incubator-hawq huor_jdbc
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/659.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #659
----
commit e02d0e0f313832f1d0998efc1c59aaad2d421364
Author: Ruilong Huo <[email protected]>
Date: 2016-05-17T06:52:39Z
HAWQ-738. Allocate query resource twice in function call through jdbc
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
