[jira] [Updated] (CALCITE-5864) getValueAs reports the wrong number of milliseconds for QUARTER and WEEK

2023-07-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5864: Labels: pull-request-available (was: ) > getValueAs reports the wrong number of

[jira] [Updated] (CALCITE-5861) Optimization rules do not constant-fold expressions in window bounds

2023-07-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5861: Labels: pull-request-available (was: ) > Optimization rules do not constant-fold

[jira] [Updated] (CALCITE-5865) ClassCastException with FLOOR and CEIL on conformances that are not builtin

2023-07-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5865: Labels: pull-request-available (was: ) > ClassCastException with FLOOR and CEIL on

[jira] [Updated] (CALCITE-5860) Decimal type conversion missing scale

2023-07-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5860: Labels: pull-request-available (was: ) > Decimal type conversion missing scale >

[jira] [Updated] (CALCITE-5863) Calcite rejects valid query with multiple ORDER BY columns and constant RANGE bounds in window functions

2023-07-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5863: Labels: pull-request-available (was: ) > Calcite rejects valid query with multiple

[jira] [Updated] (CALCITE-5862) Incorrect semantics of array function enabled in Spark Library

2023-07-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5862: Labels: pull-request-available (was: ) > Incorrect semantics of array function enabled

[jira] [Updated] (CALCITE-5859) Calcite crashes at compilation time when evaluating LEFT(NULL, n) expression

2023-07-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5859: Labels: pull-request-available (was: ) > Calcite crashes at compilation time when

[jira] [Updated] (CALCITE-5830) Add ARRAY_INSERT function(enabled in Spark library)

2023-07-16 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5830: Labels: pull-request-available (was: ) > Add ARRAY_INSERT function(enabled in Spark

[jira] [Updated] (CALCITE-5848) Add BIT_GET and GETBIT function (enabled in Spark library)

2023-07-14 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5848: Labels: pull-request-available (was: ) > Add BIT_GET and GETBIT function (enabled in

[jira] [Updated] (CALCITE-5825) Add URL_ENCODE and URL_DECODE function (enabled in Spark library)

2023-07-14 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5825: Labels: pull-request-available (was: ) > Add URL_ENCODE and URL_DECODE function

[jira] [Updated] (CALCITE-5826) Add FIND_IN_SET function (enabled in Hive and Spark library)

2023-07-13 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5826?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5826: Labels: pull-request-available (was: ) > Add FIND_IN_SET function (enabled in Hive and

[jira] [Updated] (CALCITE-5837) After RexUtil.pullFactors method,sometimes the condition order of RexNode is not the same as before

2023-07-13 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5837: Labels: pull-request-available (was: ) > After RexUtil.pullFactors method,sometimes the

[jira] [Updated] (CALCITE-5843) Legal constant SQL expression with cast causes a parse error

2023-07-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5843: Labels: pull-request-available (was: ) > Legal constant SQL expression with cast causes

[jira] [Updated] (CALCITE-5841) Improve the logic of creating JDBCMeta singleton in calcite plus

2023-07-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5841: Labels: pull-request-available (was: ) > Improve the logic of creating JDBCMeta

[jira] [Updated] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

2023-07-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5839: Labels: pull-request-available (was: ) > EnumerableInterpretable#StaticFieldDetector

[jira] [Updated] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-07-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5732: Labels: pull-request-available (was: ) > EnumerableHashJoin and EnumerableMergeJoin on

[jira] [Updated] (CALCITE-5836) Implement Rel2Sql for MERGE

2023-07-11 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5836: Labels: pull-request-available (was: ) > Implement Rel2Sql for MERGE >

[jira] [Updated] (CALCITE-5831) Add SOUNDEX function(enabled in Spark library)

2023-07-10 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5831: Labels: pull-request-available (was: ) > Add SOUNDEX function(enabled in Spark library)

[jira] [Updated] (CALCITE-5713) SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception

2023-07-10 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5713: Labels: pull-request-available (was: ) > SqlBasicCall's Deep Copy Logic Raises Rule

[jira] [Updated] (CALCITE-5829) Add BYTE_LENGTH function (enabled in BigQuery)

2023-07-10 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5829: Labels: pull-request-available (was: ) > Add BYTE_LENGTH function (enabled in BigQuery)

[jira] [Updated] (CALCITE-5817) The lead field for the interval type should not be validated

2023-07-10 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5817: Labels: pull-request-available (was: ) > The lead field for the interval type should

[jira] [Updated] (CALCITE-5824) Innodb IndexCondition should safely deal with null pointQueryKey

2023-07-10 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5824: Labels: pull-request-available (was: ) > Innodb IndexCondition should safely deal with

[jira] [Updated] (CALCITE-5827) Add IS_INF and IS_NAN functions (enabled in BigQuery library)

2023-07-10 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5827: Labels: pull-request-available (was: ) > Add IS_INF and IS_NAN functions (enabled in

[jira] [Updated] (CALCITE-5821) Add FORMAT_NUMBER function (enabled in Hive and Spark library)

2023-07-09 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5821: Labels: pull-request-available (was: ) > Add FORMAT_NUMBER function (enabled in Hive

[jira] [Updated] (CALCITE-5823) Remove commons-collections dependency from innodb

2023-07-09 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5823?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5823: Labels: pull-request-available (was: ) > Remove commons-collections dependency from

[jira] [Updated] (CALCITE-5820) Add PARSE_URL function (enabled in Hive and Spark library)

2023-07-08 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5820: Labels: pull-request-available (was: ) > Add PARSE_URL function (enabled in Hive and

[jira] [Updated] (CALCITE-5822) Add BIT_LENGTH for spark dialect

2023-07-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5822: Labels: pull-request-available (was: ) > Add BIT_LENGTH for spark dialect >

[jira] [Updated] (CALCITE-5819) Bump commons-collections 3.x to commons-collections4

2023-07-06 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5819?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5819: Labels: pull-request-available (was: ) > Bump commons-collections 3.x to

[jira] [Updated] (CALCITE-5769) Optimizing 'CAST(e AS t) IS NOT NULL' to 'e IS NOT NULL'

2023-07-04 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5769: Labels: pull-request-available (was: ) > Optimizing 'CAST(e AS t) IS NOT NULL' to 'e IS

[jira] [Updated] (CALCITE-5807) Add SUBSTRING_INDEX function (enabled in Spark library)

2023-07-03 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5807: Labels: pull-request-available (was: ) > Add SUBSTRING_INDEX function (enabled in Spark

[jira] [Updated] (CALCITE-5816) Wrong result for query with LEFT SEMI JOIN

2023-07-03 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5816: Labels: pull-request-available (was: ) > Wrong result for query with LEFT SEMI JOIN >

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

2023-07-02 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5782: Labels: pull-request-available (was: ) > Add TO_HEX and FROM_HEX functions (enabled in

[jira] [Updated] (CALCITE-5813) Type inference for REPEAT sql function is incorrect

2023-06-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5813: Labels: pull-request-available (was: ) > Type inference for REPEAT sql function is

[jira] [Updated] (CALCITE-5804) Bump jackson versions to 2.15.2

2023-06-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5804: Labels: pull-request-available (was: ) > Bump jackson versions to 2.15.2 >

[jira] [Updated] (CALCITE-5812) Fix failing ./gradlew tasks

2023-06-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5812: Labels: pull-request-available (was: ) > Fix failing ./gradlew tasks >

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

2023-06-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5740: Labels: pull-request-available (was: ) > Support for AggToSemiJoinRule >

[jira] [Updated] (CALCITE-5809) enable already available functions in Apache Spark Library

2023-06-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5809: Labels: pull-request-available (was: ) > enable already available functions in Apache

[jira] [Updated] (CALCITE-5810) SUBSTRING compile-time evaluation gives wrong result for large lengths

2023-06-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5810: Labels: pull-request-available (was: ) > SUBSTRING compile-time evaluation gives wrong

[jira] [Updated] (CALCITE-5803) Migrate Avatica to Gradle 8.0.0

2023-06-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5803: Labels: pull-request-available (was: ) > Migrate Avatica to Gradle 8.0.0 >

[jira] [Updated] (CALCITE-5681) Support authorization via GRANT and REVOKE DDL commands

2023-06-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5681: Labels: pull-request-available (was: ) > Support authorization via GRANT and REVOKE DDL

[jira] [Updated] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

2023-06-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5805: Labels: pull-request-available (was: ) > SqlValidatorImpl throws AssertionError while

[jira] [Updated] (CALCITE-5798) '(1 < x) IS NOT TRUE' when x is not nullable should be simplified to '1 >= x'

2023-06-25 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5798?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5798: Labels: pull-request-available (was: ) > '(1 < x) IS NOT TRUE' when x is not nullable

[jira] [Updated] (CALCITE-5773) Gradle show tasks fails when creating javadocAggregateIncludingTests

2023-06-23 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5773: Labels: pull-request-available (was: ) > Gradle show tasks fails when creating

[jira] [Updated] (CALCITE-5793) Use NULLS FIRST / LAST when unparsing in BigQuery

2023-06-21 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5793: Labels: pull-request-available (was: ) > Use NULLS FIRST / LAST when unparsing in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5789: Labels: pull-request-available (was: ) > Query with two nested subqueries where the

[jira] [Updated] (CALCITE-5775) Null direction emulation broken for complex expressions on some dialects

2023-06-20 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5775: Labels: pull-request-available (was: ) > Null direction emulation broken for complex

[jira] [Updated] (CALCITE-5786) QuidemTest and DiffRepository write output to build/resources/test causing incremental build issues

2023-06-17 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5786: Labels: pull-request-available (was: ) > QuidemTest and DiffRepository write output to

[jira] [Updated] (CALCITE-5785) Fix fmppMain build tasks so they work with remote build caching

2023-06-17 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5785: Labels: pull-request-available (was: ) > Fix fmppMain build tasks so they work with

[jira] [Updated] (CALCITE-5741) Add support for CONCAT_WS function(enabled in MSSQL, MySQL and Postgresql)

2023-06-17 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5741: Labels: pull-request-available (was: ) > Add support for CONCAT_WS function(enabled in

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

2023-06-16 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5779: Labels: pull-request-available (was: ) > Implicit column alias for single-column table

[jira] [Updated] (CALCITE-5784) Generate the same correlationId for the same query

2023-06-16 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5784: Labels: pull-request-available (was: ) > Generate the same correlationId for the same

[jira] [Updated] (CALCITE-5783) Make table function scan hintable

2023-06-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5783: Labels: pull-request-available (was: ) > Make table function scan hintable >

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

2023-06-14 Thread ASF GitHub Bot (Jira)
[ 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-5777) Simplify 'OperandTypes.STRING.or(OperandTypes.BINARY)' to 'OperandTypes.STRING'

2023-06-14 Thread ASF GitHub Bot (Jira)
[ 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] [Updated] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join remove by the foreign-unique constraint in the catalog

2023-06-14 Thread ASF GitHub Bot (Jira)
[ 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] [Updated] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

2023-06-14 Thread ASF GitHub Bot (Jira)
[ 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] [Updated] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5772: Labels: pull-request-available (was: ) > Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark

[jira] [Updated] (CALCITE-5729) Add BYTE_LENGTH function (enabled in BigQuery library)

2023-06-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5729: Labels: pull-request-available (was: ) > Add BYTE_LENGTH function (enabled in BigQuery

[jira] [Updated] (CALCITE-5751) Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect

2023-06-10 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5751: Labels: pull-request-available (was: ) > Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE

[jira] [Updated] (CALCITE-5771) Apply two different NULL semantics for CONCAT function(enabled in MySQL、Postgresql、BigQuery and MSSQL)

2023-06-10 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5771: Labels: pull-request-available (was: ) > Apply two different NULL semantics for CONCAT

[jira] [Updated] (CALCITE-5759) SEARCH operator with special sarg is not fully simplified

2023-06-09 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5759: Labels: pull-request-available (was: ) > SEARCH operator with special sarg is not fully

[jira] [Updated] (CALCITE-5755) Add to Sarg serialization/deserialization TimestampString

2023-06-08 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5755: Labels: pull-request-available (was: ) > Add to Sarg serialization/deserialization

[jira] [Updated] (CALCITE-5768) SqlImplementor.hasSortByOrdinal is broken

2023-06-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5768: Labels: pull-request-available (was: ) > SqlImplementor.hasSortByOrdinal is broken >

[jira] [Updated] (CALCITE-5761) DATE_TRUNC compile-time evaluation produces wrong results

2023-06-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5761: Labels: pull-request-available (was: ) > DATE_TRUNC compile-time evaluation produces

[jira] [Updated] (CALCITE-5766) Implement SAFE_NEGATE function (enabled for BigQuery)

2023-06-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5766?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5766: Labels: pull-request-available (was: ) > Implement SAFE_NEGATE function (enabled for

[jira] [Updated] (CALCITE-5767) MSSQL fails to unparse properly when sorting by GROUPING expression

2023-06-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5767?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5767: Labels: pull-request-available (was: ) > MSSQL fails to unparse properly when sorting

[jira] [Updated] (CALCITE-5706) Add class PairList

2023-06-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5706: Labels: pull-request-available (was: ) > Add class PairList > -- > >

[jira] [Updated] (CALCITE-5709) Add TO_BASE32 and FROM_BASE32 functions (enabled in BigQuery library)

2023-06-06 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5709: Labels: pull-request-available (was: ) > Add TO_BASE32 and FROM_BASE32 functions

[jira] [Updated] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-06 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5757: Labels: pull-request-available (was: ) > Incorrect return type for BigQuery TRUNC

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5733: Labels: pull-request-available (was: ) > simplify should also simplify for array type >

[jira] [Updated] (CALCITE-5747) Conflicting FLOOR return type between Calcite and BigQuery

2023-06-05 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5747: Labels: pull-request-available (was: ) > Conflicting FLOOR return type between Calcite

[jira] [Updated] (CALCITE-5742) SubstitutionVisitor Causes Infinite Loop when using AggregateOnCalcToAggregateUnifyRule

2023-06-04 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5742: Labels: pull-request-available (was: ) > SubstitutionVisitor Causes Infinite Loop when

[jira] [Updated] (CALCITE-5748) Support Guava 32.0.0-jre

2023-06-03 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5748: Labels: pull-request-available (was: ) > Support Guava 32.0.0-jre >

[jira] [Updated] (CALCITE-5745) CONCAT2 function(enabled in Oracle library) gets wrong result when one of the argument is NULL

2023-06-03 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5745: Labels: pull-request-available (was: ) > CONCAT2 function(enabled in Oracle library)

[jira] [Updated] (CALCITE-5746) Support JDK 19

2023-06-03 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5746: Labels: pull-request-available (was: ) > Support JDK 19 > -- > >

[jira] [Updated] (CALCITE-4555) Invalid zero literal value is used for TIMESTAMP WITH LOCAL TIME ZONE type in RexBuilder

2023-06-03 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4555: Labels: pull-request-available (was: ) > Invalid zero literal value is used for

[jira] [Updated] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

2023-06-02 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5722: Labels: pull-request-available (was: ) > Sarg.isComplementedPoints fails with

[jira] [Updated] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

2023-06-02 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5724: Labels: pull-request-available (was: ) > Generated SQL uses literal values in ORDER BY

[jira] [Updated] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

2023-06-02 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5739: Labels: pull-request-available (was: ) > Add MAP_FROM_ARRAYS for Spark dialect >

[jira] [Updated] (CALCITE-5744) Add STR_TO_MAP for Spark dialect

2023-06-02 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5744: Labels: pull-request-available (was: ) > Add STR_TO_MAP for Spark dialect >

[jira] [Updated] (CALCITE-5728) Add ARRAY_TO_STRING function (enabled in BigQuery library)

2023-06-02 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5728: Labels: pull-request-available (was: ) > Add ARRAY_TO_STRING function (enabled in

[jira] [Updated] (CALCITE-5738) Add SORT_ARRAY for Spark dialect

2023-05-31 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5738: Labels: pull-request-available (was: ) > Add SORT_ARRAY for Spark dialect >

[jira] [Updated] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5736: Labels: pull-request-available (was: ) > Add ARRAY_REVERSE for Spark dialect >

[jira] [Updated] (CALCITE-5735) Implement SAFE_MULTIPLY function (enabled for BigQuery)

2023-05-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5735: Labels: pull-request-available (was: ) > Implement SAFE_MULTIPLY function (enabled for

[jira] [Updated] (CALCITE-5734) Add ARRAY_COMPACT for Spark dialect

2023-05-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5734: Labels: pull-request-available (was: ) > Add ARRAY_COMPACT for Spark dialect >

[jira] [Updated] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5731: Labels: pull-request-available (was: ) > cast to row type should throw exception when

[jira] [Updated] (CALCITE-5701) Add NAMED_STRUCT function (enabled in Spark library)

2023-05-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5701: Labels: pull-request-available (was: ) > Add NAMED_STRUCT function (enabled in Spark

[jira] [Updated] (CALCITE-5425) Should not pushdown filter through aggregate with an empty groupset

2023-05-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5425: Labels: pull-request-available (was: ) > Should not pushdown filter through aggregate

[jira] [Updated] (CALCITE-5730) First nulls are dropped by calcite EnumerableSortLimit Node

2023-05-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5730: Labels: pull-request-available (was: ) > First nulls are dropped by calcite

[jira] [Updated] (CALCITE-5710) Add ARRAY_MAX and ARRAY_MIN for Spark dialect

2023-05-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5710: Labels: pull-request-available (was: ) > Add ARRAY_MAX and ARRAY_MIN for Spark dialect

[jira] [Updated] (CALCITE-5727) RelOptFixture#checkUnchanged should assert planAfter is not present

2023-05-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5727: Labels: pull-request-available (was: ) > RelOptFixture#checkUnchanged should assert

[jira] [Updated] (CALCITE-5721) Capture build scans on ge.apache.org to benefit from deep build insights

2023-05-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5721: Labels: pull-request-available (was: ) > Capture build scans on ge.apache.org to

[jira] [Updated] (CALCITE-4334) LITERAL_AGG, an aggregate function that returns a constant value

2023-05-25 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4334: Labels: pull-request-available (was: ) > LITERAL_AGG, an aggregate function that

[jira] [Updated] (CALCITE-5608) Implement ASINH, ACOSH, ATANH function

2023-05-23 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5608: Labels: pull-request-available (was: ) > Implement ASINH, ACOSH, ATANH function >

[jira] [Updated] (CALCITE-5564) Add parsing and validation for PERCENTILE_CONT/PERCENTILE_DISC functions (enabled in BigQuery)

2023-05-23 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5564: Labels: pull-request-available (was: ) > Add parsing and validation for

[jira] [Updated] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-22 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5703: Labels: patch-available pull-request-available (was: patch-available) > Reduce amount

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-22 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5708: Labels: patch-available pull-request-available (was: patch-available) > Change

[jira] [Updated] (CALCITE-5685) Support MySQL CONVERT function that works on data types

2023-05-22 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5685: Labels: pull-request-available (was: ) > Support MySQL CONVERT function that works on

[jira] [Updated] (CALCITE-5711) Implement the SINGLE_VALUE aggregation in PostgreSQL Dialect

2023-05-22 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5711: Labels: pull-request-available (was: ) > Implement the SINGLE_VALUE aggregation in

[jira] [Updated] (CALCITE-5626) Sub-query with fully qualified table name throws table not found exception in validation phase

2023-05-22 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5626: Labels: pull-request-available (was: ) > Sub-query with fully qualified table name

<    1   2   3   4   5   6   7   8   9   10   >