You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/04/02 04:51:42 UTC
[jira] [Commented] (TRAFODION-2516) Enhance stringtolob builtin
function to take varchar/char columns as parameter
[ 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 <sa...@apache.org>
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)