[jira] [Created] (CALCITE-5782) Add TO_HEX and FROM_HEX functions (enabled in BigQuery library)
Dan Zou created CALCITE-5782:
Summary: Add TO_HEX and FROM_HEX functions (enabled in BigQuery
library)
Key: CALCITE-5782
URL: https://issues.apache.org/jira/browse/CALCITE-5782
Project: Calcite
Issue Type: New Feature
Reporter: Dan Zou
Assignee: Dan Zou
Add TO_HEX and FROM_HEX functions (enabled in BigQuery library)
* TO_HEX: Converts a sequence of {{BYTES}} into a hexadecimal {{{}STRING{}}}.
* FROM_HEX: Converts a hexadecimal-encoded {{STRING}} into {{BYTES}} format
See more details in BigQuery doc
[TO_HEX|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#to_hex],
[FROM_HEX|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#from_hex]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
Re: [ANNOUNCE] New committer: Oliver Lee
Congratulations and welcome Oliver!
[jira] [Created] (CALCITE-5781) Integrating Apache Calcite into OSS-Fuzz
Henry Lin created CALCITE-5781: -- Summary: Integrating Apache Calcite into OSS-Fuzz Key: CALCITE-5781 URL: https://issues.apache.org/jira/browse/CALCITE-5781 Project: Calcite Issue Type: Test Reporter: Henry Lin Hi all, We have prepared the [initial integration|https://github.com/google/oss-fuzz/pull/10536] of Apache Calcite into [Google OSS-Fuzz|https://github.com/google/oss-fuzz] which will provide more security for your project. *Why do you need Fuzzing?* The Code Intelligence JVM fuzzer [Jazzer|https://github.com/CodeIntelligenceTesting/jazzer] has already found [hundreds of bugs|https://github.com/CodeIntelligenceTesting/jazzer/blob/main/docs/findings.md] in open source projects including for example [OpenJDK|https://nvd.nist.gov/vuln/detail/CVE-2022-21360], [Protobuf|https://nvd.nist.gov/vuln/detail/CVE-2021-22569] or [jsoup|https://github.com/jhy/jsoup/security/advisories/GHSA-m72m-mhq2-9p6c]. Fuzzing proved to be very effective having no false positives. It provides a crashing input which helps you to reproduce and debug any finding easily. The integration of your project into the OSS-Fuzz platform will enable continuous fuzzing of your project by [Jazzer|https://github.com/CodeIntelligenceTesting/jazzer]. *What do you need to do?* The integration requires the maintainer or one established project committer to deal with the bug reports. You need to create or provide one email address that is associated with a google account as per [here|https://google.github.io/oss-fuzz/getting-started/accepting-new-projects/]. When a bug is found, you will receive an email that will provide you with access to ClusterFuzz, crash reports, code coverage reports and fuzzer statistics. More than 1 person can be included. *How can Code Intelligence support you?* We will continue to add more fuzz targets to improve code coverage over time. Furthermore, we are permanently enhancing fuzzing technologies by developing new fuzzers and bug detectors. Please let me know if you have any questions regarding fuzzing or the OSS-Fuzz integration. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (CALCITE-5780) Always-true OR expressions contains reverse order comparison should be simplified to TRUE
Runkang He created CALCITE-5780:
---
Summary: Always-true OR expressions contains reverse order
comparison should be simplified to TRUE
Key: CALCITE-5780
URL: https://issues.apache.org/jira/browse/CALCITE-5780
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.34.0
Reporter: Runkang He
The following expressions which contains reverse order comparison are always
true:
{code:sql}
1 > x or 1 <= x or x is null
1 < x or 1 >= x or x is null
1 > x or 0 < x or x is null
{code}
But currently these expressions are not fully simplified to TRUE, the current
simplified results are SEARCH operator.
The root cause is that RexSimplify doesn't identify these cases and makes
targeted simplification.
It would be nice if RexSimplify.simplifyOr handled these cases.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
Re: [ANNOUNCE] New committer: Oliver Lee
Congratulations and welcome Oliver! On Tue, Jun 13, 2023, 06:45 Stamatis Zampetakis wrote: > Apache Calcite's Project Management Committee (PMC) has invited Oliver > Lee to become a committer, and we are pleased to announce that they > have accepted. > > Oliver started working with us around November 2022 and since then > they contributed multiple SQL functions to the Calcite repository > bringing lots of improvements to the BigQuery dialect. They improved > the extensibility of the SQL validator and pushed various fixes in > RelNode serialization to JSON. > > Oliver, welcome, thank you for your contributions, and we look forward > to your further interactions with the community! If you wish, please > feel free to tell us more about yourself and what you are working on. > > As your first commit, please add yourself to the contributors list [1] > and the community page will re-generate [2]. > > Stamatis (on behalf of the Apache Calcite PMC) > > [1] > https://github.com/apache/calcite/blob/main/site/_data/contributors.yml > [2] https://calcite.apache.org/community/#project-members >
[jira] [Created] (CALCITE-5779) Implicit column alias for single-column table function does not work
Dmitry Sysolyatin created CALCITE-5779:
--
Summary: Implicit column alias for single-column table function
does not work
Key: CALCITE-5779
URL: https://issues.apache.org/jira/browse/CALCITE-5779
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.34.0
Reporter: Dmitry Sysolyatin
Implicit column alias for single-column table function works only for UNNEST.
But should work for every table function.
For example, PostgreSQL returns the same result for
{code:java}
SELECT i FROM UNNEST(ARRAY(1,2)) as i;
SELECT i FROM generate_series(1,2) as i;
i
---
1
2
(2 rows)
{code}
Calcite throws"Column 'i' not found in any table" exception for
{code:java}
SELECT i FROM generate_series(1,2) as i
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
Re: [ANNOUNCE] New committer: Oliver Lee
Congratulations Oliver! Best Jacky! Tanner Clary 于2023年6月14日周三 06:31写道： > Congrats Oliver!! Very well deserved > > On Tue, Jun 13, 2023 at 12:29 PM Julian Hyde wrote: > > > Thanks for your contributions, Oliver! And welcome! > > > > On Tue, Jun 13, 2023 at 4:31 AM Zhe Hu wrote: > > > > > > Congrats Oliver! > > > Replied Message > > > | From | xiong duan | > > > | Date | 06/13/2023 19:17 | > > > | To | dev | > > > | Subject | Re: [ANNOUNCE] New committer: Oliver Lee | > > > Congratulations Oliver! > > > > > > Dan Zou 于2023年6月13日周二 19:16写道： > > > > > > > Congratulations Oliver! > > > > > > > > Best, > > > > Dan Zou > > > > > > > > > > > > > > > > > > > > > > > > > 2023年6月13日 18:44，Stamatis Zampetakis 写道： > > > > > > > > > > Apache Calcite's Project Management Committee (PMC) has invited > > Oliver > > > > > Lee to become a committer, and we are pleased to announce that they > > > > > have accepted. > > > > > > > > > > Oliver started working with us around November 2022 and since then > > > > > they contributed multiple SQL functions to the Calcite repository > > > > > bringing lots of improvements to the BigQuery dialect. They > improved > > > > > the extensibility of the SQL validator and pushed various fixes in > > > > > RelNode serialization to JSON. > > > > > > > > > > Oliver, welcome, thank you for your contributions, and we look > > forward > > > > > to your further interactions with the community! If you wish, > please > > > > > feel free to tell us more about yourself and what you are working > on. > > > > > > > > > > As your first commit, please add yourself to the contributors list > > [1] > > > > > and the community page will re-generate [2]. > > > > > > > > > > Stamatis (on behalf of the Apache Calcite PMC) > > > > > > > > > > [1] > > > > > > https://github.com/apache/calcite/blob/main/site/_data/contributors.yml > > > > > [2] https://calcite.apache.org/community/#project-members > > > > > > > > > > >
[jira] [Created] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect
jackylau created CALCITE-5778: - Summary: Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect Key: CALCITE-5778 URL: https://issues.apache.org/jira/browse/CALCITE-5778 Project: Calcite Issue Type: Improvement Components: core Affects Versions: 1.35.0 Reporter: jackylau Fix For: 1.35.0 -- This message was sent by Atlassian Jira (v8.20.10#820010)
