[jira] [Created] (CALCITE-6323) Serialize return type during RelJson.toJson(RexNode node) for SqlKind.SAFE_CAST

2024-03-12 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6323: - Summary: Serialize return type during RelJson.toJson(RexNode node) for SqlKind.SAFE_CAST Key: CALCITE-6323 URL: https://issues.apache.org/jira/browse/CALCITE-6323

[jira] [Created] (CALCITE-6290) Incorrect return type for BigQuery REPEAT

2024-03-04 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6290: - Summary: Incorrect return type for BigQuery REPEAT Key: CALCITE-6290 URL: https://issues.apache.org/jira/browse/CALCITE-6290 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6225) Unparse LOGICAL_AND/OR as BOOLAND_AGG/BOOLOR_AGG for Snowflake

2024-01-25 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6225: - Summary: Unparse LOGICAL_AND/OR as BOOLAND_AGG/BOOLOR_AGG for Snowflake Key: CALCITE-6225 URL: https://issues.apache.org/jira/browse/CALCITE-6225 Project: Calcite

[jira] [Created] (CALCITE-6220) Map MAX/MIN to BOOL_OR/BOOL_AND for Postgres and Redshift

2024-01-22 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6220: - Summary: Map MAX/MIN to BOOL_OR/BOOL_AND for Postgres and Redshift Key: CALCITE-6220 URL: https://issues.apache.org/jira/browse/CALCITE-6220 Project: Calcite

[jira] [Created] (CALCITE-6206) Add library operator mapping for unparsing

2024-01-15 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6206: - Summary: Add library operator mapping for unparsing Key: CALCITE-6206 URL: https://issues.apache.org/jira/browse/CALCITE-6206 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6205) Add BITAND_AGG, BITOR_AGG functions (enabled in Snowflake library)

2024-01-15 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6205: - Summary: Add BITAND_AGG, BITOR_AGG functions (enabled in Snowflake library) Key: CALCITE-6205 URL: https://issues.apache.org/jira/browse/CALCITE-6205 Project:

[jira] [Created] (CALCITE-6198) Add TO_TIMESTAMP_LTZ function (enabled in Snowflake library)

2024-01-12 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6198: - Summary: Add TO_TIMESTAMP_LTZ function (enabled in Snowflake library) Key: CALCITE-6198 URL: https://issues.apache.org/jira/browse/CALCITE-6198 Project: Calcite

[jira] [Created] (CALCITE-6197) TIME_SUB is unparsed incorrectly

2024-01-12 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6197: - Summary: TIME_SUB is unparsed incorrectly Key: CALCITE-6197 URL: https://issues.apache.org/jira/browse/CALCITE-6197 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6196) Remove OVER requirement for BigQuery PERCENTILE_CONT/DISC

2024-01-11 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6196: - Summary: Remove OVER requirement for BigQuery PERCENTILE_CONT/DISC Key: CALCITE-6196 URL: https://issues.apache.org/jira/browse/CALCITE-6196 Project: Calcite

[jira] [Created] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

2024-01-04 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6186: - Summary: Enable DATEDIFF for Snowflake, map to BigQuery equivalents Key: CALCITE-6186 URL: https://issues.apache.org/jira/browse/CALCITE-6186 Project: Calcite

[jira] [Created] (CALCITE-6182) Add LENGTH/LEN function (enabled in Snowflake library)

2023-12-27 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6182: - Summary: Add LENGTH/LEN function (enabled in Snowflake library) Key: CALCITE-6182 URL: https://issues.apache.org/jira/browse/CALCITE-6182 Project: Calcite

[jira] [Created] (CALCITE-6172) Allow aliased operators to re-use existing tests

2023-12-21 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6172: - Summary: Allow aliased operators to re-use existing tests Key: CALCITE-6172 URL: https://issues.apache.org/jira/browse/CALCITE-6172 Project: Calcite Issue

[jira] [Created] (CALCITE-6156) Add ENDSWITH, STARTSWITH functions (enabled in Snowflake library)

2023-12-04 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6156: - Summary: Add ENDSWITH, STARTSWITH functions (enabled in Snowflake library) Key: CALCITE-6156 URL: https://issues.apache.org/jira/browse/CALCITE-6156 Project:

[jira] [Created] (CALCITE-6045) CURRENT_TIMESTAMP has incorrect return type

2023-10-10 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6045: - Summary: CURRENT_TIMESTAMP has incorrect return type Key: CALCITE-6045 URL: https://issues.apache.org/jira/browse/CALCITE-6045 Project: Calcite Issue

[jira] [Created] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

2023-09-21 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6021: - Summary: Add CURRENT_DATETIME function (enabled in BigQuery library) Key: CALCITE-6021 URL: https://issues.apache.org/jira/browse/CALCITE-6021 Project: Calcite

[jira] [Created] (CALCITE-6013) Unnecessary measures added as projects during rel construction

2023-09-18 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6013: - Summary: Unnecessary measures added as projects during rel construction Key: CALCITE-6013 URL: https://issues.apache.org/jira/browse/CALCITE-6013 Project: Calcite

[jira] [Created] (CALCITE-6001) Add default charset per dialect

2023-09-12 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-6001: - Summary: Add default charset per dialect Key: CALCITE-6001 URL: https://issues.apache.org/jira/browse/CALCITE-6001 Project: Calcite Issue Type: New

[jira] [Created] (CALCITE-5983) Add DIV and IEEE_DIVIDE functions (enabled in BigQuery library)

2023-09-07 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5983: - Summary: Add DIV and IEEE_DIVIDE functions (enabled in BigQuery library) Key: CALCITE-5983 URL: https://issues.apache.org/jira/browse/CALCITE-5983 Project: Calcite

[jira] [Created] (CALCITE-5955) Non-aggregate window functions incorrectly contain window frame clause for BigQuery

2023-08-24 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5955: - Summary: Non-aggregate window functions incorrectly contain window frame clause for BigQuery Key: CALCITE-5955 URL: https://issues.apache.org/jira/browse/CALCITE-5955

[jira] [Created] (CALCITE-5933) Add SAFE_DIVIDE function (enabled in BigQuery library)

2023-08-16 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5933: - Summary: Add SAFE_DIVIDE function (enabled in BigQuery library) Key: CALCITE-5933 URL: https://issues.apache.org/jira/browse/CALCITE-5933 Project: Calcite

[jira] [Created] (CALCITE-5932) Add SAFE_SUBTRACT function (enabled in BigQuery library)

2023-08-16 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5932: - Summary: Add SAFE_SUBTRACT function (enabled in BigQuery library) Key: CALCITE-5932 URL: https://issues.apache.org/jira/browse/CALCITE-5932 Project: Calcite

[jira] [Created] (CALCITE-5869) LEAST_RESTRICTIVE does not use inner type of MEASURE for comparisons

2023-07-23 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5869: - Summary: LEAST_RESTRICTIVE does not use inner type of MEASURE for comparisons Key: CALCITE-5869 URL: https://issues.apache.org/jira/browse/CALCITE-5869 Project:

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

2023-07-10 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5827: - Summary: Add TO_HEX and FROM_HEX functions (enabled in BigQuery library) Key: CALCITE-5827 URL: https://issues.apache.org/jira/browse/CALCITE-5827 Project: Calcite

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

2023-06-07 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5766: - Summary: Implement SAFE_NEGATE function (enabled for BigQuery) Key: CALCITE-5766 URL: https://issues.apache.org/jira/browse/CALCITE-5766 Project: Calcite

[jira] [Created] (CALCITE-5757) Incorrect return type for BigQuery TIMESTAMP functions

2023-06-06 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5757: - Summary: Incorrect return type for BigQuery TIMESTAMP functions Key: CALCITE-5757 URL: https://issues.apache.org/jira/browse/CALCITE-5757 Project: Calcite

[jira] [Created] (CALCITE-5747) FLOOR() return type differs from BigQuery

2023-06-02 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5747: - Summary: FLOOR() return type differs from BigQuery Key: CALCITE-5747 URL: https://issues.apache.org/jira/browse/CALCITE-5747 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5735) Implement BigQuery SAFE_MULTIPLY function

2023-05-30 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5735: - Summary: Implement BigQuery SAFE_MULTIPLY function Key: CALCITE-5735 URL: https://issues.apache.org/jira/browse/CALCITE-5735 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5677) Fix unparsing for BigQuery SUBSTR

2023-04-26 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5677: - Summary: Fix unparsing for BigQuery SUBSTR Key: CALCITE-5677 URL: https://issues.apache.org/jira/browse/CALCITE-5677 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-5666) Add ISOWEEK and WEEK(WEEKDAY) to TimeUnit in Avatica

2023-04-20 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5666: - Summary: Add ISOWEEK and WEEK(WEEKDAY) to TimeUnit in Avatica Key: CALCITE-5666 URL: https://issues.apache.org/jira/browse/CALCITE-5666 Project: Calcite

[jira] [Created] (CALCITE-5660) Implement BigQuery Array Subscript Operators

2023-04-18 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5660: - Summary: Implement BigQuery Array Subscript Operators Key: CALCITE-5660 URL: https://issues.apache.org/jira/browse/CALCITE-5660 Project: Calcite Issue

[jira] [Created] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

2023-04-12 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5644: - Summary: Implement BigQuery CONTAINS_SUBSTR Key: CALCITE-5644 URL: https://issues.apache.org/jira/browse/CALCITE-5644 Project: Calcite Issue Type: Task

[jira] [Created] (CALCITE-5610) Implement COTH, CSCH, SECH Functions

2023-03-24 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5610: - Summary: Implement COTH, CSCH, SECH Functions Key: CALCITE-5610 URL: https://issues.apache.org/jira/browse/CALCITE-5610 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5605) Add BigQuery as supported library for CHR

2023-03-22 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5605: - Summary: Add BigQuery as supported library for CHR Key: CALCITE-5605 URL: https://issues.apache.org/jira/browse/CALCITE-5605 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5600) Allow EXTRACT() to accept custom time frames

2023-03-21 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5600: - Summary: Allow EXTRACT() to accept custom time frames Key: CALCITE-5600 URL: https://issues.apache.org/jira/browse/CALCITE-5600 Project: Calcite Issue

[jira] [Created] (CALCITE-5585) Add STRPOS() Function (Enabled for BigQuery)

2023-03-14 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5585: - Summary: Add STRPOS() Function (Enabled for BigQuery) Key: CALCITE-5585 URL: https://issues.apache.org/jira/browse/CALCITE-5585 Project: Calcite Issue

[jira] [Created] (CALCITE-5580) Add SPLIT() Function (Enabled for BigQuery)

2023-03-13 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5580: - Summary: Add SPLIT() Function (Enabled for BigQuery) Key: CALCITE-5580 URL: https://issues.apache.org/jira/browse/CALCITE-5580 Project: Calcite Issue

[jira] [Created] (CALCITE-5579) Allow Time Frames as Valid Expressions

2023-03-13 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5579: - Summary: Allow Time Frames as Valid Expressions Key: CALCITE-5579 URL: https://issues.apache.org/jira/browse/CALCITE-5579 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5565) Implement BigQuery LOG function

2023-03-07 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5565: - Summary: Implement BigQuery LOG function Key: CALCITE-5565 URL: https://issues.apache.org/jira/browse/CALCITE-5565 Project: Calcite Issue Type: Task

[jira] [Created] (CALCITE-5564) Add 2-argument support for PERCENTILE_CONT/DISC

2023-03-07 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5564: - Summary: Add 2-argument support for PERCENTILE_CONT/DISC Key: CALCITE-5564 URL: https://issues.apache.org/jira/browse/CALCITE-5564 Project: Calcite Issue

[jira] [Created] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

2023-03-02 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5554: - Summary: Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY Key: CALCITE-5554 URL: https://issues.apache.org/jira/browse/CALCITE-5554 Project: Calcite

[jira] [Created] (CALCITE-5484) Implement BigQuery DATETIME_SUB

2023-01-17 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5484: - Summary: Implement BigQuery DATETIME_SUB Key: CALCITE-5484 URL: https://issues.apache.org/jira/browse/CALCITE-5484 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-5469) Implement BigQuery DATETIME_ADD/DATETIME_DIFF

2023-01-12 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5469: - Summary: Implement BigQuery DATETIME_ADD/DATETIME_DIFF Key: CALCITE-5469 URL: https://issues.apache.org/jira/browse/CALCITE-5469 Project: Calcite Issue

[jira] [Created] (CALCITE-5464) Implement BigQuery DATE_ADD/DATE_DIFF

2022-12-28 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5464: - Summary: Implement BigQuery DATE_ADD/DATE_DIFF Key: CALCITE-5464 URL: https://issues.apache.org/jira/browse/CALCITE-5464 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5459) Implement BigQuery TIME() Function

2022-12-26 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5459: - Summary: Implement BigQuery TIME() Function Key: CALCITE-5459 URL: https://issues.apache.org/jira/browse/CALCITE-5459 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5454) Update BigQuery Conformance for != and % operators

2022-12-22 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5454: - Summary: Update BigQuery Conformance for != and % operators Key: CALCITE-5454 URL: https://issues.apache.org/jira/browse/CALCITE-5454 Project: Calcite

[jira] [Created] (CALCITE-5452) Add BigQuery LENGTH() as synonym for CHAR_LENGTH()

2022-12-21 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5452: - Summary: Add BigQuery LENGTH() as synonym for CHAR_LENGTH() Key: CALCITE-5452 URL: https://issues.apache.org/jira/browse/CALCITE-5452 Project: Calcite

[jira] [Created] (CALCITE-5449) Implement EXTRACT() Function for BigQuery

2022-12-20 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5449: - Summary: Implement EXTRACT() Function for BigQuery Key: CALCITE-5449 URL: https://issues.apache.org/jira/browse/CALCITE-5449 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5436) Implement DATE, TIME, TIMESTAMP Subtraction Functions (compatible w/ BigQuery)

2022-12-15 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5436: - Summary: Implement DATE, TIME, TIMESTAMP Subtraction Functions (compatible w/ BigQuery) Key: CALCITE-5436 URL: https://issues.apache.org/jira/browse/CALCITE-5436

[jira] [Created] (CALCITE-5432) Implement BigQuery TIME_ADD/TIME_DIFF

2022-12-13 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5432: - Summary: Implement BigQuery TIME_ADD/TIME_DIFF Key: CALCITE-5432 URL: https://issues.apache.org/jira/browse/CALCITE-5432 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5422) Time units to be supported by TIMESTAMP_ADD function

2022-12-06 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5422: - Summary: Time units to be supported by TIMESTAMP_ADD function Key: CALCITE-5422 URL: https://issues.apache.org/jira/browse/CALCITE-5422 Project: Calcite

[jira] [Created] (CALCITE-5404) Implement BigQuery's POW() and TRUNC() math functions

2022-11-28 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5404: - Summary: Implement BigQuery's POW() and TRUNC() math functions Key: CALCITE-5404 URL: https://issues.apache.org/jira/browse/CALCITE-5404 Project: Calcite

[jira] [Created] (CALCITE-5385) Add BigQuery as supported library for implemented functions

2022-11-16 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5385: - Summary: Add BigQuery as supported library for implemented functions Key: CALCITE-5385 URL: https://issues.apache.org/jira/browse/CALCITE-5385 Project: Calcite

[jira] [Created] (CALCITE-5384) Implement LEFT/RIGHT String functions for BigQuery

2022-11-15 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5384: - Summary: Implement LEFT/RIGHT String functions for BigQuery Key: CALCITE-5384 URL: https://issues.apache.org/jira/browse/CALCITE-5384 Project: Calcite