Thanks for the examples.
I tried query "select 1 + 2 + 3;" on calcite, it returns 6. I'm not sure how many arguments are passed in this case, maybe two args for each plus operator, but string concat operator should act in the similar way. I've created a JIRA to track the issue https://issues.apache.org/jira/browse/CALCITE-1924. ________________________________ 发件人: Julian Hyde <[email protected]> 发送时间: 2017年8月4日 2:55:14 收件人: [email protected] 主题: Re: String concat operator symbol "+" No plans, but contributions would be welcome. Like ‘%’ [1] and ‘!=‘ [2], these should be allowed only in in particular conformance modes. Please log a JIRA case now, and attach a pull request when you have one. Do you expect concat to accept exactly 2 arguments or any number? Julian [1] https://issues.apache.org/jira/browse/CALCITE-1897 <https://issues.apache.org/jira/browse/CALCITE-1897> [2] https://issues.apache.org/jira/browse/CALCITE-1374 <https://issues.apache.org/jira/browse/CALCITE-1374> [CALCITE-1374] Support operator "!=" as an alternative to ...<https://issues.apache.org/jira/browse/CALCITE-1374> issues.apache.org Maryann Xue added a comment - 13/Sep/16 20:05 - edited As I was adding some new tests and verifying existing tests, I found the following code comment in ... [CALCITE-1374] Support operator "!=" as an alternative to ...<https://issues.apache.org/jira/browse/CALCITE-1374> issues.apache.org Maryann Xue added a comment - 13/Sep/16 20:05 - edited As I was adding some new tests and verifying existing tests, I found the following code comment in ... > On Aug 3, 2017, at 5:22 AM, roger shi <[email protected]> wrote: > > Hi all, > > > I find different DBMS supports different string concat operators, "+", "||", > and concat keyword. Calcite does not support symbol "+" as string concat > operator, while some BI tools depend on it. Is there any plan to support it? > If there's a patch to enable the feature, is it possible to be accepted? > > > Thanks.
