[jira] [Created] (CALCITE-6077) Add FACTORIAL functions (enabled in Hive and Spark library)

2023-10-26 Thread Runkang He (Jira)
Runkang He created CALCITE-6077: --- Summary: Add FACTORIAL functions (enabled in Hive and Spark library) Key: CALCITE-6077 URL: https://issues.apache.org/jira/browse/CALCITE-6077 Project: Calcite

[jira] [Created] (CALCITE-6066) Add HYPOT function (enabled in Spark library)

2023-10-21 Thread Runkang He (Jira)
Runkang He created CALCITE-6066: --- Summary: Add HYPOT function (enabled in Spark library) Key: CALCITE-6066 URL: https://issues.apache.org/jira/browse/CALCITE-6066 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6065) Add HEX and UNHEX function (enabled in Hive and Spark library)

2023-10-21 Thread Runkang He (Jira)
Runkang He created CALCITE-6065: --- Summary: Add HEX and UNHEX function (enabled in Hive and Spark library) Key: CALCITE-6065 URL: https://issues.apache.org/jira/browse/CALCITE-6065 Project: Calcite

[jira] [Created] (CALCITE-5990) Explicit cast to numeric type doesn't check overflow

2023-09-08 Thread Runkang He (Jira)
Runkang He created CALCITE-5990: --- Summary: Explicit cast to numeric type doesn't check overflow Key: CALCITE-5990 URL: https://issues.apache.org/jira/browse/CALCITE-5990 Project: Calcite Issue

[jira] [Created] (CALCITE-5957) Validate DATE '1945-2-2' is not accepted due to regression

2023-08-26 Thread Runkang He (Jira)
Runkang He created CALCITE-5957: --- Summary: Validate DATE '1945-2-2' is not accepted due to regression Key: CALCITE-5957 URL: https://issues.apache.org/jira/browse/CALCITE-5957 Project: Calcite

[jira] [Created] (CALCITE-5923) Some test cases in `SqlOperatorTest` violates the test fixture's design principle

2023-08-13 Thread Runkang He (Jira)
Runkang He created CALCITE-5923: --- Summary: Some test cases in `SqlOperatorTest` violates the test fixture's design principle Key: CALCITE-5923 URL: https://issues.apache.org/jira/browse/CALCITE-5923

[jira] [Created] (CALCITE-5921) SqlOperatorFixture.checkFails and checkAggFails don't check runtime failure

2023-08-13 Thread Runkang He (Jira)
Runkang He created CALCITE-5921: --- Summary: SqlOperatorFixture.checkFails and checkAggFails don't check runtime failure Key: CALCITE-5921 URL: https://issues.apache.org/jira/browse/CALCITE-5921 Project:

[jira] [Created] (CALCITE-5900) Add TO_BASE64URL and FROM_BASE64URL function (enabled in Presto library)

2023-08-05 Thread Runkang He (Jira)
Runkang He created CALCITE-5900: --- Summary: Add TO_BASE64URL and FROM_BASE64URL function (enabled in Presto library) Key: CALCITE-5900 URL: https://issues.apache.org/jira/browse/CALCITE-5900 Project:

[jira] [Created] (CALCITE-5899) Add HAMMING_DISTANCE function (enabled in Presto library)

2023-08-05 Thread Runkang He (Jira)
Runkang He created CALCITE-5899: --- Summary: Add HAMMING_DISTANCE function (enabled in Presto library) Key: CALCITE-5899 URL: https://issues.apache.org/jira/browse/CALCITE-5899 Project: Calcite

[jira] [Created] (CALCITE-5898) Add UUID function (enabled in Presto library)

2023-08-05 Thread Runkang He (Jira)
Runkang He created CALCITE-5898: --- Summary: Add UUID function (enabled in Presto library) Key: CALCITE-5898 URL: https://issues.apache.org/jira/browse/CALCITE-5898 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5897) Add Presto functions

2023-08-05 Thread Runkang He (Jira)
Runkang He created CALCITE-5897: --- Summary: Add Presto functions Key: CALCITE-5897 URL: https://issues.apache.org/jira/browse/CALCITE-5897 Project: Calcite Issue Type: New Feature

[jira] [Created] (CALCITE-5851) Add LEVENSHTEIN function (enabled in Hive and Spark library)

2023-07-14 Thread Runkang He (Jira)
Runkang He created CALCITE-5851: --- Summary: Add LEVENSHTEIN function (enabled in Hive and Spark library) Key: CALCITE-5851 URL: https://issues.apache.org/jira/browse/CALCITE-5851 Project: Calcite

[jira] [Created] (CALCITE-5850) Enable already available functions for Apache Hive library

2023-07-14 Thread Runkang He (Jira)
Runkang He created CALCITE-5850: --- Summary: Enable already available functions for Apache Hive library Key: CALCITE-5850 URL: https://issues.apache.org/jira/browse/CALCITE-5850 Project: Calcite

[jira] [Created] (CALCITE-5849) Add CONV function (enabled in Hive and Spark library)

2023-07-14 Thread Runkang He (Jira)
Runkang He created CALCITE-5849: --- Summary: Add CONV function (enabled in Hive and Spark library) Key: CALCITE-5849 URL: https://issues.apache.org/jira/browse/CALCITE-5849 Project: Calcite

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

2023-07-14 Thread Runkang He (Jira)
Runkang He created CALCITE-5848: --- Summary: Add BIT_GET and GETBIT function (enabled in Spark library) Key: CALCITE-5848 URL: https://issues.apache.org/jira/browse/CALCITE-5848 Project: Calcite

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

2023-07-09 Thread Runkang He (Jira)
Runkang He created CALCITE-5826: --- Summary: Add FIND_IN_SET function (enabled in Hive and Spark library) Key: CALCITE-5826 URL: https://issues.apache.org/jira/browse/CALCITE-5826 Project: Calcite

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

2023-07-09 Thread Runkang He (Jira)
Runkang He created CALCITE-5825: --- Summary: Add URL_ENCODE and URL_DECODE function (enabled in Spark library) Key: CALCITE-5825 URL: https://issues.apache.org/jira/browse/CALCITE-5825 Project: Calcite

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

2023-07-07 Thread Runkang He (Jira)
Runkang He created CALCITE-5821: --- Summary: Add FORMAT_NUMBER function (enabled in Hive and Spark library) Key: CALCITE-5821 URL: https://issues.apache.org/jira/browse/CALCITE-5821 Project: Calcite

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

2023-07-07 Thread Runkang He (Jira)
Runkang He created CALCITE-5820: --- Summary: Add PARSE_URL function (enabled in Hive and Spark library) Key: CALCITE-5820 URL: https://issues.apache.org/jira/browse/CALCITE-5820 Project: Calcite

[jira] [Created] (CALCITE-5815) Simplify 'a = MULTISET[1,2] AND a = MULTISET[2,3]' to 'FALSE'

2023-06-30 Thread Runkang He (Jira)
Runkang He created CALCITE-5815: --- Summary: Simplify 'a = MULTISET[1,2] AND a = MULTISET[2,3]' to 'FALSE' Key: CALCITE-5815 URL: https://issues.apache.org/jira/browse/CALCITE-5815 Project: Calcite

[jira] [Created] (CALCITE-5814) Simplify 'a = MAP[1,2] AND a = MAP[2,3]' to 'FALSE'

2023-06-30 Thread Runkang He (Jira)
Runkang He created CALCITE-5814: --- Summary: Simplify 'a = MAP[1,2] AND a = MAP[2,3]' to 'FALSE' Key: CALCITE-5814 URL: https://issues.apache.org/jira/browse/CALCITE-5814 Project: Calcite Issue

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

2023-06-25 Thread Runkang He (Jira)
Runkang He created CALCITE-5798: --- Summary: '(10 < x) IS NOT TRUE' when x is not nullable should be simplified to '10 >= x' Key: CALCITE-5798 URL: https://issues.apache.org/jira/browse/CALCITE-5798

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

2023-06-14 Thread Runkang He (Jira)
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] [Created] (CALCITE-5759) SEARCH operator with special sarg is not fully simplified

2023-06-06 Thread Runkang He (Jira)
Runkang He created CALCITE-5759: --- Summary: SEARCH operator with special sarg is not fully simplified Key: CALCITE-5759 URL: https://issues.apache.org/jira/browse/CALCITE-5759 Project: Calcite

[jira] [Created] (CALCITE-5680) Wrong plan for multiple IN sub-queries with only literal operands

2023-04-28 Thread Runkang He (Jira)
Runkang He created CALCITE-5680: --- Summary: Wrong plan for multiple IN sub-queries with only literal operands Key: CALCITE-5680 URL: https://issues.apache.org/jira/browse/CALCITE-5680 Project: Calcite

[jira] [Created] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

2023-04-18 Thread Runkang He (Jira)
Runkang He created CALCITE-5661: --- Summary: Introduce another way to convert IN predicate to RelNode when IN list is large Key: CALCITE-5661 URL: https://issues.apache.org/jira/browse/CALCITE-5661

[jira] [Created] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

2023-04-17 Thread Runkang He (Jira)
Runkang He created CALCITE-5655: --- Summary: Wrong plan for multiple IN/SOME sub-queries with OR predicate Key: CALCITE-5655 URL: https://issues.apache.org/jira/browse/CALCITE-5655 Project: Calcite