Re: [ANNOUNCE] Chunwei Lei joins Calcite PMC
Thanks everyone! It is a great honor to join the Calcite PMC. Best, Chunwei On Fri, May 27, 2022 at 10:26 AM Yanjing Wang wrote: > Congrats, Chunwei! > > Forward Xu 于2022年5月25日周三 15:17写道： > > > Congratulations, Chunwei! > > > > > > Best, > > > > Forwardxu > > > > Stamatis Zampetakis 于2022年5月25日周三 14:46写道： > > > > > Congratulations Chunwei. You have been doing a lot of work for the > > project > > > and this is very much appreciated! > > > Thanks for all your efforts. > > > > > > Best, > > > Stamatis > > > > > > On Wed, May 25, 2022 at 8:32 AM Haisheng Yuan > wrote: > > > > > > > Congratulations, Chunwei! > > > > > > > > On 2022/05/25 06:26:35 Michael Mior wrote: > > > > > Congratulations and thank you Chunwei! > > > > > > > > > > -- > > > > > Michael Mior > > > > > mm...@apache.org > > > > > > > > > > > > > > > Le mar. 24 mai 2022 à 16:47, Ruben Q L a > écrit : > > > > > > > > > > > I am pleased to announce that Chunwei has accepted an invitation > to > > > > join > > > > > > the > > > > > > Calcite PMC. Chunwei has been a consistent and helpful figure in > > the > > > > > > Calcite community for which we are very grateful. We look forward > > to > > > > the > > > > > > continued contributions and support. > > > > > > > > > > > > Please join me in congratulating Chunwei! > > > > > > > > > > > > - Ruben (on behalf of the Calcite PMC) > > > > > > > > > > > > > > > > > > > > >
[jira] [Created] (CALCITE-5184) In parser, allow "LIMIT start, ALL"
Julian Hyde created CALCITE-5184:
Summary: In parser, allow "LIMIT start, ALL"
Key: CALCITE-5184
URL: https://issues.apache.org/jira/browse/CALCITE-5184
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
In parser, allow "LIMIT start, ALL". For example,
{code:sql}
SELECT *
FROM Emp
ORDER BY sal DESC
LIMIT 10, ALL
{code}
would be equivalent to
{code:sql}
SELECT *
FROM Emp
ORDER BY sal DESC
OFFSET 10
{code}
No other database supports this syntax, but Calcite supports Postgres' "LIMIT
ALL" and MySQL's "LIMIT start, count" so it makes sense to combine them.
See the original discussion in CALCITE-5086.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
Re: [ANNOUNCE] Vladimir Ozerov joins Calcite PMC
Hi everybody, Thank you very much! пт, 27 мая 2022 г. в 05:27, Yanjing Wang : > Congrats Vladimir! > > Forward Xu 于2022年5月25日周三 15:18写道： > > > Congratulations Vladimir! > > > > > > Best, > > > > ForwardXu > > > > Stamatis Zampetakis 于2022年5月25日周三 15:05写道： > > > > > Congratulations Vladimir. You have shown that you care for the project > in > > > many different ways and it's only natural to see you in the PMC. > > > > > > Best, > > > Stamatis > > > > > > On Wed, May 25, 2022 at 8:33 AM Haisheng Yuan > wrote: > > > > > > > Congratulations Vladimir! > > > > > > > > On 2022/05/25 06:27:16 Michael Mior wrote: > > > > > Congratulations Vladimir! > > > > > > > > > > -- > > > > > Michael Mior > > > > > mm...@apache.org > > > > > > > > > > > > > > > Le mar. 24 mai 2022 à 16:47, Ruben Q L a > écrit : > > > > > > > > > > > I am pleased to announce that Vladimir has accepted an invitation > > to > > > > join > > > > > > the Calcite PMC. Vladimir has been a consistent and helpful > figure > > in > > > > the > > > > > > Calcite community for which we are very grateful. We look forward > > to > > > > the > > > > > > continued contributions and support. > > > > > > > > > > > > Please join me in congratulating Vladimir! > > > > > > > > > > > > - Ruben (on behalf of the Calcite PMC) > > > > > > > > > > > > > > > > > > > > >
[jira] [Created] (CALCITE-5183) Impossible condition in return type inference for SqlIntervalOperator?
Steven Talbot created CALCITE-5183: -- Summary: Impossible condition in return type inference for SqlIntervalOperator? Key: CALCITE-5183 URL: https://issues.apache.org/jira/browse/CALCITE-5183 Project: Calcite Issue Type: Bug Reporter: Steven Talbot I could be wrong here, but I don't see how to make this work, and I don't see any tests for it being used on the relBuilder side of the fence (where the "impossible" type inference is invoked for me). [https://github.com/apache/calcite/commit/03c76a7d2b896042ab417ddc36f1849f874ad3dd#diff-f6836cabfabc14be277e9f7406ab38996aaa45bac86969cecd64189c2fd7c745R57] requires the second argument to the Interval call to be a SqlIntervalQualifier. In the context of RexCallBinding, I don't believe this is possible, since the argument has to be a RexLiteral, and RexLiteral exposes no way to directly wrap a value as a SqlIntervalQualifier like this. Again, this is where my reading of the code gets uncertain, but neither signature of RexBuilder.makeIntervalLiteral will give you what you want, and I don't see any way this could be possible. This issue means that there seems to be no way to use `SqlStdOperatorTable.INTERVAL` with RelBuilder.call. -- This message was sent by Atlassian Jira (v8.20.7#820007)
[jira] [Created] (CALCITE-5182) STDDEV returning NaN values
Matt P created CALCITE-5182:
---
Summary: STDDEV returning NaN values
Key: CALCITE-5182
URL: https://issues.apache.org/jira/browse/CALCITE-5182
Project: Calcite
Issue Type: Bug
Reporter: Matt P
Example w/ Calcite 1.30:
{code:java}
0: jdbc:calcite:model=src/test/resources/mode> SELECT STDDEV(x) FROM (VALUES
1+power(2,-52), 1+power(2,-51)) x;
++
| EXPR$0 |
++
| NaN |
++
1 row selected (0.577 seconds){code}
{{{}{}}}This is due to the numerical issues in the formula that is being used:
{code:java}
variance = avg(x*x) - avg(x)*avg(x){code}
Though mathematically this should always be non-negative, due to numerical
errors it can be negative and thus when the square root is taken to get the
STDDEV it results in NaN.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
