[jira] [Commented] (TRAFODION-2951) group_concat on utf8 column with chinese character get messy code

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-2951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16351442#comment-16351442 ] 

ASF GitHub Bot commented on TRAFODION-2951:
-------------------------------------------

GitHub user traflm opened a pull request:

    https://github.com/apache/trafodion/pull/1438

    [TRAFODION-2951] group_concat on utf8 column with chinese character get messy code

    the pivot synthesize type function not consider the charset of output.
    Add code to copy the charset from child.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/traflm/trafodion TRAFODION-2951

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/trafodion/pull/1438.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 #1438
    
----
commit c7039b920846ba084f8404ba48ea5c8ab2dd3dc5
Author: Liu Ming <ov...@...>
Date:   2018-02-03T10:09:27Z

    [TRAFODION-2951] group_concat on utf8 column with chinese character get messy code

commit 3c963796066d13a2a55bb6a8fe903d82b5ea49da
Author: Liu Ming <ov...@...>
Date:   2018-02-03T11:12:02Z

    add regression test

----


> group_concat on utf8 column with chinese character get messy code
> -----------------------------------------------------------------
>
>                 Key: TRAFODION-2951
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2951
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: liu ming
>            Assignee: liu ming
>            Priority: Major
>
> 1. create table t_pivot(role_id VARCHAR(50 BYTES) CHARACTER SET UTF8,role_nm VARCHAR(200 BYTES) CHARACTER SET UTF8);
> 2. 
> insert into t_pivot values('role_01','管理员');
> insert into t_pivot values('role_02','审计员');
>  
> 3. GROUP_CONCAT
> SQL>select GROUP_CONCAT(role_nm) from t_pivot;
> (EXPR)-------------------------------------
> ?????????,???è?????  
>    
> SQL>select GROUP_CONCAT(role_id) from t_pivot;
> (EXPR)
> -------------------------------------
> role_01,role_02



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)