GitHub user sandhyasun opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1217
TRAFODION-2724
Needs to go into Trafodion 2.3 as well. 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/1217.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 #1217
----
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.
---
