[jira] [Commented] (CALCITE-3235) Add CONCAT function for Redshift
[
https://issues.apache.org/jira/browse/CALCITE-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16938854#comment-16938854
]
Julian Hyde commented on CALCITE-3235:
--
Please post your question to the dev list. Adding questions to closed bugs
confuses people. I saw you also logged a bug with the same question. This
behavior is [cross-posting|https://en.wikipedia.org/wiki/Crossposting] and it
is not helpful. The dev list is the right place for such questions.
> 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(, ,
> ...)}}
> When using CONCAT, e.g.
> {{SELECT CONCAT('a', city) FROM public.aircraft}}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Commented] (CALCITE-3235) Add CONCAT function for Redshift
[
https://issues.apache.org/jira/browse/CALCITE-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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(, ,
> ...)}}
> When using CONCAT, e.g.
> {{SELECT CONCAT('a', city) FROM public.aircraft}}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Commented] (CALCITE-3235) Add CONCAT function for Redshift
[
https://issues.apache.org/jira/browse/CALCITE-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16908466#comment-16908466
]
Julian Hyde commented on CALCITE-3235:
--
Reviewing and testing now. I rebased and made a few tweaks in
[https://github.com/julianhyde/calcite/tree/3235-concat]; I will squash and
merge shortly if tests pass.
> 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
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> Get this error:
> {{No match found for function signature CONCAT(, ,
> ...)}}
> When using CONCAT, e.g.
> {{SELECT CONCAT('a', city) FROM public.aircraft}}
>
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
[jira] [Commented] (CALCITE-3235) Add CONCAT function for Redshift
[
https://issues.apache.org/jira/browse/CALCITE-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16907521#comment-16907521
]
Ryan Fu commented on CALCITE-3235:
--
PR: [https://github.com/apache/calcite/pull/1376] is ready for review
> 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
>Priority: Minor
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Get this error:
> {{No match found for function signature CONCAT(, ,
> ...)}}
> When using CONCAT, e.g.
> {{SELECT CONCAT('a', city) FROM public.aircraft}}
>
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
