GitHub user sandhyasun opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1216
TRAFODION-2724
Fix to ensure internal statements used to retrieve LOB descriptor chunks
information during an extract are closed properly. The issue was if the the
caller of extract passed in the exact length, the ""readCursorData method would
return the correct data but would leave the "open" to the internal table in a
FETCH state. This change ensures that a second "fetch" is done so EOD would be
seen and as a result the internal statement would get closed within the method
ExLob::fethCursor which would call SQL_EXEC_LOBcliInterface(handleIn,
handleLenIn, ....
LOB_CLI_SELECT_CLOSE, .....)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/incubator-trafodion
san_2.2traf_misc
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1216.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 #1216
----
commit 89576f3dc7f5e37977ec3cdd9f0fd5ecadee0d36
Author: Sandhya Sundaresan <[email protected]>
Date: 2017-08-22T17:38:42Z
Changes to take care of closing internal cursor statement when extract
operation is done and the exact length of data is passed in to be extracted.
commit 8a260f425e0527100c8039b8db8a8b4db64b1101
Author: Sandhya Sundaresan <[email protected]>
Date: 2017-08-22T17:41:39Z
Expected file change to show result of unload.
----
---
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.
---
