[jira] [Commented] (CALCITE-5782) Add TO_HEX and FROM_HEX functions (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732857#comment-17732857 ] Julian Hyde commented on CALCITE-5782: -- Please be sure to use Calcite’s type names when describing

[jira] [Commented] (CALCITE-5780) Always-true OR expressions contain reverse order comparison should be simplified to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732856#comment-17732856 ] xiong duan commented on CALCITE-5780: - [~Runking] Hi, The 1 > x or 0 < x or x is null can't be

[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

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732811#comment-17732811 ] Rong Rong commented on CALCITE-5740: actually i think it would be super useful to add the

[jira] [Updated] (CALCITE-5780) Always-true OR expressions contain reverse order comparison should be simplified to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5780: Labels: pull-request-available (was: ) > Always-true OR expressions contain reverse

[jira] [Updated] (CALCITE-4679) Search/sarg simplification leaves is not null(literal) unsimplified

[ https://issues.apache.org/jira/browse/CALCITE-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-4679: Fix Version/s: 1.35.0 Affects Version/s: 1.34.0 > Search/sarg simplification leaves is

[jira] [Updated] (CALCITE-5780) Always-true OR expressions contain reverse order comparison should be simplified to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5780: Description: The following expressions which contain reverse order comparison are always true:

[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

[jira] [Updated] (CALCITE-5780) Always-true OR expressions contain reverse order comparison should be simplified to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5780: Description: The following expressions which contain reverse order comparison are always true:

[jira] [Assigned] (CALCITE-5780) Always-true OR expressions contains reverse order comparison should be simplified to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He reassigned CALCITE-5780: --- Assignee: Runkang He > Always-true OR expressions contains reverse order comparison

[jira] [Updated] (CALCITE-5780) Always-true OR expressions contain reverse order comparison should be simplified to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5780: Summary: Always-true OR expressions contain reverse order comparison should be simplified to

[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

[jira] [Updated] (CALCITE-5777) Simplify 'OperandTypes.STRING.or(OperandTypes.BINARY)' to 'OperandTypes.STRING'

[ https://issues.apache.org/jira/browse/CALCITE-5777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5777: Labels: pull-request-available (was: ) > Simplify

[jira] [Commented] (CALCITE-5779) Implicit column alias for single-column table function does not work

[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732486#comment-17732486 ] Dmitry Sysolyatin commented on CALCITE-5779: Easy fix to use AliasNamespace for table

[jira] [Comment Edited] (CALCITE-5779) Implicit column alias for single-column table function does not work

[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732486#comment-17732486 ] Dmitry Sysolyatin edited comment on CALCITE-5779 at 6/14/23 10:59 AM:

[jira] [Comment Edited] (CALCITE-5779) Implicit column alias for single-column table function does not work

[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732486#comment-17732486 ] Dmitry Sysolyatin edited comment on CALCITE-5779 at 6/14/23 10:59 AM:

[jira] [Assigned] (CALCITE-5779) Implicit column alias for single-column table function does not work

[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5779: -- Assignee: (was: Dmitry Sysolyatin) > Implicit column alias for

[jira] [Updated] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join remove by the foreign-unique constraint in the catalog

[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5756: Labels: pull-request-available (was: ) > Expand ProjectJoinRemoveRule to support inner

[jira] [Assigned] (CALCITE-5779) Implicit column alias for single-column table function does not work

[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5779: -- Assignee: Dmitry Sysolyatin > Implicit column alias for single-column table

[jira] [Updated] (CALCITE-5779) Implicit column alias for single-column table function does not work

[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5779: --- Description: Implicit column alias for single-column table function works only for

[jira] [Updated] (CALCITE-5779) Implicit column alias for single-column table function does not work

[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5779: --- Description: Implicit column alias for single-column table function works only for

[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

[jira] [Commented] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732451#comment-17732451 ] jackylau commented on CALCITE-5778: --- hi [~jiajunbernoulli] [~julianhyde] [~tanclary] will you have

[jira] [Updated] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5778: -- Description: h3. [array_join|https://spark.apache.org/docs/latest/api/sql/index.html#array_join]

[jira] [Updated] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5778: -- Description: h3. [array_join|https://spark.apache.org/docs/latest/api/sql/index.html#array_join]

[jira] [Updated] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5778: -- Description: h3. [array_join|https://spark.apache.org/docs/latest/api/sql/index.html#array_join]

[jira] [Updated] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5778: Labels: pull-request-available (was: ) > Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for

[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

[jira] [Assigned] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5778: - Assignee: jackylau > Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect >

[jira] [Resolved] (CALCITE-5759) 'SEARCH(1, Sarg[IS NOT NULL])' should be simplified to 'TRUE'

[ https://issues.apache.org/jira/browse/CALCITE-5759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-5759. - Fix Version/s: 1.35.0 Resolution: Fixed Fixed via