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

2023-07-10 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741847#comment-17741847 ] Benchao Li commented on CALCITE-5681: - [~hongyuguo] Usually we suggest to ask for review in the dev

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

2023-07-10 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741844#comment-17741844 ] Benchao Li commented on CALCITE-5837: - Sounds reasonable to me. > After RexUtil.pullFactors

[jira] [Commented] (CALCITE-5838) derive wrong decimal divide type

2023-07-10 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741843#comment-17741843 ] Benchao Li commented on CALCITE-5838: - You can extend Calcite to specify your own rule for deriving

[jira] [Commented] (CALCITE-5479) FamilyOperandTypeChecker is not readily composable in sequences

2023-07-10 Thread Gian Merlino (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741833#comment-17741833 ] Gian Merlino commented on CALCITE-5479: --- Thank you! > FamilyOperandTypeChecker is not readily

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

2023-07-10 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741832#comment-17741832 ] Guillaume Massé commented on CALCITE-5701: -- Thanks for the review! I fixed all of the points

[jira] [Commented] (CALCITE-5838) derive wrong decimal divide type

2023-07-10 Thread pengfei.zhan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741830#comment-17741830 ] pengfei.zhan commented on CALCITE-5838: --- Can I cherry-pick the implement from spark to calcite to

[jira] [Created] (CALCITE-5838) derive wrong decimal divide type

2023-07-10 Thread pengfei.zhan (Jira)
pengfei.zhan created CALCITE-5838: - Summary: derive wrong decimal divide type Key: CALCITE-5838 URL: https://issues.apache.org/jira/browse/CALCITE-5838 Project: Calcite Issue Type: Bug

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

2023-07-10 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741828#comment-17741828 ] LakeShen commented on CALCITE-5837: --- I tried to trace the source code for the Rexutil.cnfhelper#pull

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

2023-07-10 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5837: -- Description: In my rule, I used the RexUtil.pullFactors to simplify the Filter's condition and I

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

2023-07-10 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5837: -- Description: In my rule, I used the RexUtil.pullFactors to simplify the Filter's condition and I

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

2023-07-10 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5837: -- Description: In my rule, I used the RexUtil.pullFactors to simplify the Filter's condition and I

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

2023-07-10 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5837: -- Summary: After RexUtil.pullFactors method,sometimes the condition order of RexNode is not the same

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

2023-07-10 Thread LakeShen (Jira)
LakeShen created CALCITE-5837: - Summary: After RexUtil.pullFactors method,Sometimes the condition order of RexNode is not the same as before Key: CALCITE-5837 URL: https://issues.apache.org/jira/browse/CALCITE-5837

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

2023-07-10 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5837: -- Description: In my rule, I used the > After RexUtil.pullFactors method,Sometimes the condition

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

2023-07-10 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741823#comment-17741823 ] hongyu guo commented on CALCITE-5681: - Hi [~libenchao] [~julianhyde], Would you be able to review

[jira] [Resolved] (CALCITE-5479) FamilyOperandTypeChecker is not readily composable in sequences

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5479. -- Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-5828) When converting the calcite dialect, it is not determined whether the ordinal number can be used in the order by in the window function

2023-07-10 Thread LiHao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LiHao updated CALCITE-5828: --- Summary: When converting the calcite dialect, it is not determined whether the ordinal number can be used

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

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741811#comment-17741811 ] Julian Hyde commented on CALCITE-5701: -- * Add a {{!type}} line to {{spark.iq}} and make sure it

[jira] [Commented] (CALCITE-5479) FamilyOperandTypeChecker is not readily composable in sequences

2023-07-10 Thread Gian Merlino (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741810#comment-17741810 ] Gian Merlino commented on CALCITE-5479: --- [~julianhyde], do you think you'll have a chance to look

[jira] [Comment Edited] (CALCITE-5828) RelNode to SqlNode, when converting the Order field, a judgment should be added to determine whether it is in the Window

2023-07-10 Thread LiHao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741808#comment-17741808 ] LiHao edited comment on CALCITE-5828 at 7/11/23 2:08 AM: - Thank you for

[jira] [Commented] (CALCITE-5828) RelNode to SqlNode, when converting the Order field, a judgment should be added to determine whether it is in the Window

2023-07-10 Thread LiHao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741808#comment-17741808 ] LiHao commented on CALCITE-5828: Thank you for reminding.^-^ > RelNode to SqlNode, when converting the

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

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741803#comment-17741803 ] Julian Hyde commented on CALCITE-5820: -- So the problem isn't with {{URL.getPath}}; it's with how

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

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741803#comment-17741803 ] Julian Hyde edited comment on CALCITE-5820 at 7/11/23 1:34 AM: --- So the

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

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741801#comment-17741801 ] Julian Hyde commented on CALCITE-5827: -- We can't mark this 'done' until infinity and NaN are

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

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5824. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in

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

2023-07-10 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741795#comment-17741795 ] Runkang He commented on CALCITE-5820: - [~julianhyde] The reason is that {{URL.getPath()}} does not

[jira] [Commented] (CALCITE-5828) RelNode to SqlNode, when converting the Order field, a judgment should be added to determine whether it is in the Window

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741794#comment-17741794 ] Julian Hyde commented on CALCITE-5828: -- Can you please change the summary and description to

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

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741793#comment-17741793 ] Julian Hyde commented on CALCITE-5729: -- I'm not too worried about the difference in data types.

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

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741779#comment-17741779 ] Julian Hyde commented on CALCITE-5820: -- [~Runking], Could you discern why [~vlsi] added

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

2023-07-10 Thread Gregory Hart (Jira)
Gregory Hart created CALCITE-5836: - Summary: Implement Rel2Sql for MERGE Key: CALCITE-5836 URL: https://issues.apache.org/jira/browse/CALCITE-5836 Project: Calcite Issue Type: Improvement

[jira] [Resolved] (CALCITE-5822) Add BIT_LENGTH function (enabled in Spark library)

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5822. -- Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-5822) Add BIT_LENGTH function (enabled in Spark library)

2023-07-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5822: - Affects Version/s: (was: 1.35.0) > Add BIT_LENGTH function (enabled in Spark library) >

[jira] [Updated] (CALCITE-5835) SqlParser.parseQuery() successfully parses DML and DDL statements without throwing a SqlParseException

2023-07-10 Thread Ankit Siva (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5835?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Siva updated CALCITE-5835: Description: I've set up a parser as follows:   {code:java} val config= SqlParser.config()

[jira] [Updated] (CALCITE-5835) SqlParser.parseQuery() successfully parses DML and DDL statements without throwing a SqlParseException

2023-07-10 Thread Ankit Siva (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5835?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Siva updated CALCITE-5835: Description: I've set up a parser as follows:   {code:java} val config= SqlParser.config()

[jira] [Updated] (CALCITE-5835) SqlParser.parseQuery() successfully parses DML and DDL statements without throwing a SqlParseException

2023-07-10 Thread Ankit Siva (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5835?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Siva updated CALCITE-5835: Description: I've set up a parser as follows: {{val config= SqlParser.config()

[jira] [Created] (CALCITE-5835) SqlParser.parseQuery() successfully parses DML and DDL statements without throwing a SqlParseException

2023-07-10 Thread Ankit Siva (Jira)
Ankit Siva created CALCITE-5835: --- Summary: SqlParser.parseQuery() successfully parses DML and DDL statements without throwing a SqlParseException Key: CALCITE-5835 URL:

[jira] [Commented] (CALCITE-5834) Rel to Sql wrong output for correlated subqueries using the same table

2023-07-10 Thread Francesco Gini (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741715#comment-17741715 ] Francesco Gini commented on CALCITE-5834: - I have spent some time looking why this is

[jira] [Updated] (CALCITE-5834) Rel to Sql wrong output for correlated subqueries using the same table

2023-07-10 Thread Francesco Gini (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francesco Gini updated CALCITE-5834: Attachment: unique-alias-patch.patch > Rel to Sql wrong output for correlated subqueries

[jira] [Created] (CALCITE-5834) Rel to Sql wrong output for correlated subqueries using the same table

2023-07-10 Thread Francesco Gini (Jira)
Francesco Gini created CALCITE-5834: --- Summary: Rel to Sql wrong output for correlated subqueries using the same table Key: CALCITE-5834 URL: https://issues.apache.org/jira/browse/CALCITE-5834

[jira] [Updated] (CALCITE-5833) Support literal parsing for AggregateCall

2023-07-10 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rong Rong updated CALCITE-5833: --- Summary: Support literal parsing for AggregateCall (was: Support `getOperandLiteralValue` in

[jira] [Updated] (CALCITE-5833) Support `getOperandLiteralValue` in `Aggregate.AggCallBinding`

2023-07-10 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rong Rong updated CALCITE-5833: --- Description: I wasn't sure if this is the right way to support the feature please share your

[jira] [Updated] (CALCITE-5833) Support `getOperandLiteralValue` in `Aggregate.AggCallBinding`

2023-07-10 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rong Rong updated CALCITE-5833: --- Description: I wasn't sure if this is the right way to support the feature please share your

[jira] [Updated] (CALCITE-5833) Support `getOperandLiteralValue` in `Aggregate.AggCallBinding`

2023-07-10 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rong Rong updated CALCITE-5833: --- Description: I wasn't sure if this is the right way to support the feature please share your

[jira] [Created] (CALCITE-5833) Support `getOperandLiteralValue` in `Aggregate.AggCallBinding`

2023-07-10 Thread Rong Rong (Jira)
Rong Rong created CALCITE-5833: -- Summary: Support `getOperandLiteralValue` in `Aggregate.AggCallBinding` Key: CALCITE-5833 URL: https://issues.apache.org/jira/browse/CALCITE-5833 Project: Calcite

[jira] [Created] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

2023-07-10 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-5832: -- Summary: CyclicMetadataException thrown in complex JOIN Key: CALCITE-5832 URL: https://issues.apache.org/jira/browse/CALCITE-5832 Project: Calcite Issue

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

2023-07-10 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741602#comment-17741602 ] Runkang He edited comment on CALCITE-5820 at 7/10/23 12:57 PM: --- When

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

2023-07-10 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741602#comment-17741602 ] Runkang He commented on CALCITE-5820: - When implementing this function, I found there is a problem

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

2023-07-10 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741600#comment-17741600 ] Runkang He commented on CALCITE-5820: - [~julianhyde] Thanks for remind. > Add PARSE_URL function

[jira] [Comment Edited] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-07-10 Thread winds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741583#comment-17741583 ] winds edited comment on CALCITE-5756 at 7/10/23 12:15 PM: -- Based on the

[jira] [Commented] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-07-10 Thread winds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741583#comment-17741583 ] winds commented on CALCITE-5756: Based on the previous discussion, the `RelOptForeignKey` component has

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5831: - Description: Hi, devs. I noticed that calcite support soundex for BIG_QUERY, MYSQL, POSTGRESQL,

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5831: - Description: Hi, devs. I noticed that calcite support soundex for BIG_QUERY, MYSQL, POSTGRESQL,

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5831: - Description: Hi, devs. I noticed that calcite support soundex for BIG_QUERY, MYSQL, POSTGRESQL,

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5830: - Summary: Add ARRAY_INSERT function(enabled in Spark library) (was: Add ARRAY_INSERT for Spark

[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-5831) Add SOUNDEX function(enabled in Spark library)

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5831: - Description: Hi, devs. I noticed that calcite support soundex for BIG_QUERY, MYSQL, POSTGRESQL,

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741568#comment-17741568 ] Ran Tao commented on CALCITE-5831: -- [~nobigo] thanks. updated. > Add SOUNDEX function(enabled in

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5831: - Summary: Add SOUNDEX function(enabled in Spark library) (was: Add soundex for Spark dialect) > Add

[jira] [Commented] (CALCITE-5830) Add ARRAY_INSERT for Spark dialect

2023-07-10 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741547#comment-17741547 ] xiong duan commented on CALCITE-5830: - [~taoran], To unify the commit info format, How about we

[jira] [Commented] (CALCITE-5831) Add soundex for Spark dialect

2023-07-10 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741546#comment-17741546 ] xiong duan commented on CALCITE-5831: - Hi, [~taoran] , To unify the commit format, How about we

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

2023-07-10 Thread Guoliang Sun (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741509#comment-17741509 ] Guoliang Sun commented on CALCITE-5713: --- Hi, [~julianhyde]. Could you please help me review the

[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] [Created] (CALCITE-5831) Add soundex for Spark dialect

2023-07-10 Thread Ran Tao (Jira)
Ran Tao created CALCITE-5831: Summary: Add soundex for Spark dialect Key: CALCITE-5831 URL: https://issues.apache.org/jira/browse/CALCITE-5831 Project: Calcite Issue Type: Improvement

[jira] [Created] (CALCITE-5830) Add ARRAY_INSERT for Spark dialect

2023-07-10 Thread Ran Tao (Jira)
Ran Tao created CALCITE-5830: Summary: Add ARRAY_INSERT for Spark dialect Key: CALCITE-5830 URL: https://issues.apache.org/jira/browse/CALCITE-5830 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-5799) unnest(a) is wrong if a is structKind.PEEK_FIELDS_NO_EXPAND

2023-07-10 Thread Haojin Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741501#comment-17741501 ] Haojin Wang commented on CALCITE-5799: -- [~julianhyde]   Excuse me, do you have time to look at

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

2023-07-10 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741497#comment-17741497 ] hongyu guo edited comment on CALCITE-5817 at 7/10/23 8:05 AM: -- I change

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

2023-07-10 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741497#comment-17741497 ] hongyu guo edited comment on CALCITE-5817 at 7/10/23 8:05 AM: -- I change

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741498#comment-17741498 ] Ran Tao commented on CALCITE-5729: -- hi, guys. I don't think BYTE_LENGTH can be same as OCTET_LENGTH.

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

2023-07-10 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741497#comment-17741497 ] hongyu guo edited comment on CALCITE-5817 at 7/10/23 7:55 AM: -- I change

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

2023-07-10 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741497#comment-17741497 ] hongyu guo commented on CALCITE-5817: - I change interval type's lead field default to maximum

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao closed CALCITE-5829. Resolution: Duplicate duplicate > Add BYTE_LENGTH function (enabled in BigQuery) >

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741492#comment-17741492 ] Ran Tao commented on CALCITE-5829: -- [~FrankZou] thanks, got it. > Add BYTE_LENGTH function (enabled

[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] [Commented] (CALCITE-5829) Add BYTE_LENGTH function (enabled in BigQuery)

2023-07-10 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741490#comment-17741490 ] Dan Zou commented on CALCITE-5829: -- Hi [~taoran], there is already a jira

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5829: - Description: Returns the string or binary data bit numbers. > SELECT byte_length('Apache Calcite');

[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] [Created] (CALCITE-5829) Add BYTE_LENGTH function (enabled in BigQuery)

2023-07-10 Thread Ran Tao (Jira)
Ran Tao created CALCITE-5829: Summary: Add BYTE_LENGTH function (enabled in BigQuery) Key: CALCITE-5829 URL: https://issues.apache.org/jira/browse/CALCITE-5829 Project: Calcite Issue Type:

[jira] [Comment Edited] (CALCITE-5822) Add BIT_LENGTH function (enabled in Spark library)

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741265#comment-17741265 ] Ran Tao edited comment on CALCITE-5822 at 7/10/23 7:33 AM: --- [~julianhyde] I

[jira] [Created] (CALCITE-5828) RelNode to SqlNode, when converting the Order field, a judgment should be added to determine whether it is in the Window

2023-07-10 Thread LiHao (Jira)
LiHao created CALCITE-5828: -- Summary: RelNode to SqlNode, when converting the Order field, a judgment should be added to determine whether it is in the Window Key: CALCITE-5828 URL:

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

2023-07-10 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5823?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741444#comment-17741444 ] Ran Tao edited comment on CALCITE-5823 at 7/10/23 6:38 AM: --- [~julianhyde] hi,

[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-5827) Add IS_INF and IS_NAN functions (enabled in BigQuery library)

2023-07-10 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5827: -- Description: BigQuery offers the

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

2023-07-10 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5827: -- Description: BigQuery offers the

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

2023-07-10 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5827: -- Summary: Add IS_INF and IS_NAN functions (enabled in BigQuery library) (was: Add TO_HEX and

[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