[
https://issues.apache.org/jira/browse/CALCITE-3375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde closed CALCITE-3375.
--------------------------------
Resolution: Invalid
This seems to be more of a question than a bug. Closing. Please ask the
question on the dev list. We will re-open if we discover that there is a bug
(i.e. we know the desired behavior and the observed behavior is different).
> calcite concat function
> -----------------------
>
> Key: CALCITE-3375
> URL: https://issues.apache.org/jira/browse/CALCITE-3375
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.21.0
> Reporter: cui
> Priority: Major
> Original Estimate: 96h
> Remaining Estimate: 96h
>
> 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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
