[
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)
