[
https://issues.apache.org/jira/browse/TRAFODION-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15952521#comment-15952521
]
ASF GitHub Bot commented on TRAFODION-2516:
-------------------------------------------
GitHub user sandhyasun opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1041
Rework the fix for [TRAFODION-2516] to returntype for param as LOB in…
…stead of coercing the type by default to char type since it confuses JDBC
and Catalog APIs. The expected input param still is expected as a varchar
format. Also added testcases both for the regression as well as the
clitestdriver program. Added support for update with param as well. Fixed a
problem with GC limit where GC was happening too often when the "update lob"
interface was called becuase the limit was not taken as MB and was taken as
bytes instead.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/incubator-trafodion 2.2_work
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1041.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 #1041
----
commit ac9b22737ee98d782d5ecb9986d36ba8c4fa28e5
Author: Sandhya Sundaresan <[email protected]>
Date: 2017-04-02T04:46:59Z
Rework the fix for [TRAFODION-2516] to returntype for param as LOB instead
of coercing the type by default to char type since it confuses JDBC and Catalog
APIs. The expected input param still is expected as a varchar format. Also
added testcases both for the regression as well as the clitestdriver program.
----
> Enhance stringtolob builtin function to take varchar/char columns as parameter
> ------------------------------------------------------------------------------
>
> Key: TRAFODION-2516
> URL: https://issues.apache.org/jira/browse/TRAFODION-2516
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-exe
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
>
> Today the stringtolob built in function that converts a string to a LOB type
> before inserrting into a lob column takes a string literal as input. Need to
> enhance it to take a char column or a varchar column as input too.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
