GitHub user sandhyasun opened a pull request:
https://github.com/apache/incubator-trafodion/pull/889
[TRAFODION-2408] Changes to support "empty lob" insert/update and update
directly using lobhandle
Empty_blob()/ Emptyclob() functions will insert a dummy row into the LOB
descriptor tables as a place holder. The lobhandle will be created but will
contain no data. This lob handle can later be used to update data directly to
it without scanning the SQL table.
JIRA contains more details on syntax/examples.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/incubator-trafodion empty_lob_work
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/889.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 #889
----
commit 7baf325f3fd612125f49b6f6763e6e895ba52d58
Author: Sandhya Sundaresan <[email protected]>
Date: 2016-12-21T19:04:25Z
Changes to support new syntax and implementation empty_blob/empty_clob for
insert/updates
Changes to support new syntax for updating a lob directly through a
lobhandle without scanning the table.This is done via new ExeUtil operator.
Changes to add columnname info to LOBMD_ table. This helps in mapping any
given lobhandle back to the table and the column.
Added new sections to the regression test executor/TEST130 to test these
changes
commit f364d03a5b73373421b885f73302545ad5208bc7
Author: Sandhya Sundaresan <[email protected]>
Date: 2016-12-21T19:11:02Z
Merge remote branch 'origin/master' into empty_lob_work
----
---
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.
---
