[jira] [Created] (CALCITE-5178) Scalar subquery in scalar subquery generates plan that will not compile

2022-06-02 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-5178: Summary: Scalar subquery in scalar subquery generates plan that will not compile Key: CALCITE-5178 URL: https://issues.apache.org/jira/browse/CALCITE-5178 Project:

Re: Help adding Snowflake variant syntax

2022-06-02 Thread Walaa Eldin Moustafa
Hi Julian, Thanks for asking those questions! I was providing this material as an educational reference since the use case is very similar to the resources I shared. I found those references to help enrich the Calcite community in the past. For example, Gavin Ray has written an article [1] on

Review request PR#2623

2022-06-02 Thread Konstantin Orlov
Hello, community! I would like to ask for your help with the review of this PR [1]. It’s been a while since I worked on this for the last time, but now I’m really looking forward to driving this till the end. This change addresses the issue described in CALCITE-4913 [2]. Basically, I want the

Re: [DISCUSS] not equal operator vs less than combining greater than

2022-06-02 Thread Benchao Li
Yanjing, Yes, I know. But I don't think this is a problem. Yanjing Wang 于2022年6月2日周四 17:54写道: > Benchao, > > I mean that "name" <> '3' will have '3' to be varchar(10) type, but "name" > > '3' or "name" < '3' will have '3' to be char(1) type, I noticed that your > change will make "name" > '3'

Re: [DISCUSS] not equal operator vs less than combining greater than

2022-06-02 Thread Yanjing Wang
Benchao, I mean that "name" <> '3' will have '3' to be varchar(10) type, but "name" > '3' or "name" < '3' will have '3' to be char(1) type, I noticed that your change will make "name" > '3' or "name" < '3' to be "name" <> '3', but the '3' is still char(1) type. should the '3' type be consistent

Re: [DISCUSS] not equal operator vs less than combining greater than

2022-06-02 Thread Yanjing Wang
Big thanks to you, Benchao, I also noticed that SubstitutionVisitor#isEquivalent method evaluates equivalence without types and RexCall#computeDigest(boolean withType) with false argument . Now we are aware that the type difference doesn't affect materialization applications and expression

[jira] [Created] (CALCITE-5177) Query loses hint after decorrelation

2022-06-02 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5177: -- Summary: Query loses hint after decorrelation Key: CALCITE-5177 URL: https://issues.apache.org/jira/browse/CALCITE-5177 Project: Calcite Issue Type: Bug