Vaibhav Joshi created CALCITE-6280:
--
Summary: The Jetty's version number leak occurred while using the
query sever
Key: CALCITE-6280
URL: https://issues.apache.org/jira/browse/CALCITE-6280
Project:
I think it is difficult and impossible to make calcite function results
completely consistent with other SQL systems. In practice, when
calculations are pushed down to different data source adapters for
execution, there is no guarantee that the final results will be completely
consistent in
Thank you very much to the calcite community for raising these questions.
This is what I have been doubting. I am very sorry that this doubt has been
discussed for so long.
Maybe we also need to consider another issue, that is, the database version
issue. Versions like mysql and postgres are very
SQL logic test has conditionals. So we could encode each database response
(including the one from Calcite)
On Sun, Feb 25, 2024, 3:33 PM Julian Hyde wrote:
> Does SQL Logic Test have an opinion about what SQRT(-1) should return?
> If Calcite is pretending to be Oracle, it should return NaN. If
I think leveraging testContainers (
https://java.testcontainers.org/quickstart/junit_4_quickstart/) could
automate the process effectively. TestContainers provides modules for
different databases such as MySQL, Oracle (
https://github.com/testcontainers/testcontainers-java/tree/main/modules),
Does SQL Logic Test have an opinion about what SQRT(-1) should return?
If Calcite is pretending to be Oracle, it should return NaN. If it is
pretending to be MySQL it should return NULL. AFAICT, SQL Logic Test
would regard (at most) one of those responses as correct. If it even
covers SQRT.
On
Write test with SQL logic test
https://www.sqlite.org/sqllogictest/doc/trunk/about.wiki
Then run those tests against each database. (This technique is called
oracle testing)
On Sun, Feb 25, 2024, 3:13 PM Julian Hyde wrote:
> TL;DR: We need to add software engineering processes to ensure that
TL;DR: We need to add software engineering processes to ensure that
Calcite is consistent with other SQL systems. What should those be?
There has been a lot of activity recently adding functions such as
LOG2 [1] and ensuring that existing functions such as LOG and SQRT [2]
are consistent with
so cool , it will be very useful for beginners and users.
thank you very much
Best regards,
Cancai cai
Zhengqiang Duan 于2024年2月25日周日 19:08写道：
> @Jiajun, thank you very much for putting together such a great study
> material.
>
> Best regards,
> Zhengqiang
>
> Jiajun Xie 于2024年2月25日周日 17:04写道：
@Jiajun, thank you very much for putting together such a great study material.
Best regards,
Zhengqiang
Jiajun Xie 于2024年2月25日周日 17:04写道：
>
> Hello all,
>
> When I read blogs about Calcite,
> I always want to replicate other people's examples on my own.
>
> Constructing examples requires a lot
If this work can be completed, it will be very useful for beginners and
users.
Jiajun Xie 于2024年2月25日周日 17:04写道：
> Hello all,
>
> When I read blogs about Calcite,
> I always want to replicate other people's examples on my own.
>
> Constructing examples requires a lot of pre-work,
> which can
Hello all,
When I read blogs about Calcite,
I always want to replicate other people's examples on my own.
Constructing examples requires a lot of pre-work,
which can be time-consuming for newcomers.
So I built a repository that combines code and blogs.
Everyone can read blogs and debug code
12 matches
Mail list logo
