You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "cui (Jira)" <ji...@apache.org> on 2019/09/26 06:22:00 UTC
[jira] [Created] (CALCITE-3375) calcite concat function
cui created CALCITE-3375:
----------------------------
Summary: 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
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)