[jira] [Commented] (CALCITE-3235) Add CONCAT function for Redshift

["cui (Jira)" <ji...@apache.org>]

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

cui commented on CALCITE-3235:
------------------------------

I use calcite to connect mysql to test, I have two column test data , age(int) and name(varchar) and the table name is test.score_new, and I have two row test data following:
+----+---------+-----+
| id | name    | age |
+----+---------+-----+
|  1 | 飞      |  16 |
+----+---------+-----+
when I use the sql : select '飞'||16 or select '飞'||'16' , it will return the right result : EXPR$0=飞16
But when I use the sql : select "name"||"age" from "test"."score_new", it will return the result : EXPR$0=1,
and sql : select "sid"||"sid" from "test"."score_new", it will return : EXPR$0=1,
and sql : select "name"||"name" from "test"."score_new", it will return : EXPR$0=0,
the result is not what I want, I want to get the result : 飞16, why ? and How to solve this problem

> Add CONCAT function for Redshift
> --------------------------------
>
>                 Key: CALCITE-3235
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3235
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Ryan Fu
>            Assignee: Julian Hyde
>            Priority: Minor
>              Labels: pull-request-available
>             Fix For: 1.21.0
>
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> Get this error:
> {{No match found for function signature CONCAT(<CHARACTER>, <CHARACTER>, ...)}}
> When using CONCAT, e.g.
> {{SELECT CONCAT('a', city) FROM public.aircraft}}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)