[jira] [Updated] (CALCITE-3955) Remove the first operand of RexCall from SqlWindowTableFunction

[ https://issues.apache.org/jira/browse/CALCITE-3955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3955: --- Fix Version/s: (was: 1.23.0) > Remove the first operand of RexCall from

[jira] [Updated] (CALCITE-3979) Simplification might have removed CAST expression(s) incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-3979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3979: --- Fix Version/s: (was: 1.23.0) > Simplification might have removed CAST expression(s)

[jira] [Updated] (CALCITE-3972) Allow RelBuilder to create RelNode with convention and use it for trait convert

[ https://issues.apache.org/jira/browse/CALCITE-3972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3972: --- Fix Version/s: (was: 1.23.0) > Allow RelBuilder to create RelNode with convention and

[jira] [Updated] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3782: --- Fix Version/s: (was: 1.23.0) > Bitwise operator Bit_And, Bit_OR and Bit_XOR support

[jira] [Created] (CALCITE-3991) the required boolean should always be provided in RelSet.getOrCreateSubset()

Botong Huang created CALCITE-3991: - Summary: the required boolean should always be provided in RelSet.getOrCreateSubset() Key: CALCITE-3991 URL: https://issues.apache.org/jira/browse/CALCITE-3991

[jira] [Created] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

James Kim created CALCITE-3990: -- Summary: Use a more efficient algorithm for cost propagation in Volcano planner Key: CALCITE-3990 URL: https://issues.apache.org/jira/browse/CALCITE-3990 Project:

[jira] [Commented] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104909#comment-17104909 ] Haisheng Yuan commented on CALCITE-3990: Isn't is already doing BFS? > Use a more efficient

[jira] [Commented] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104945#comment-17104945 ] James Kim commented on CALCITE-3990: It is currently using DFS; if the cost of a subset became

[jira] [Comment Edited] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104945#comment-17104945 ] James Kim edited comment on CALCITE-3990 at 5/11/20, 10:40 PM: --- It is

[jira] [Created] (CALCITE-3989) Release Calcite 1.23.0

Haisheng Yuan created CALCITE-3989: -- Summary: Release Calcite 1.23.0 Key: CALCITE-3989 URL: https://issues.apache.org/jira/browse/CALCITE-3989 Project: Calcite Issue Type: Task

[jira] [Updated] (CALCITE-3943) Remove the JSON functions keyword from parser

[ https://issues.apache.org/jira/browse/CALCITE-3943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3943: --- Fix Version/s: (was: 1.23.0) > Remove the JSON functions keyword from parser >

[jira] [Commented] (CALCITE-3987) Allow addition and subtraction operations between DATE and NUMERIC types.

[ https://issues.apache.org/jira/browse/CALCITE-3987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104869#comment-17104869 ] Drew Schmitt commented on CALCITE-3987: --- Ok limiting to a specific conformance mode sounds

[jira] [Updated] (CALCITE-3224) New RexNode-to-Expression CodeGen Implementation

[ https://issues.apache.org/jira/browse/CALCITE-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3224: --- Fix Version/s: (was: 1.23.0) > New RexNode-to-Expression CodeGen Implementation >

[jira] [Issue Comment Deleted] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim updated CALCITE-3990: --- Comment: was deleted (was: It is currently using DFS; if the cost of a subset became cheaper, it

[jira] [Closed] (CALCITE-3992) Beam ZetaSQL supports pure SQL user-defined aggregation functions

[ https://issues.apache.org/jira/browse/CALCITE-3992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed CALCITE-3992. - Resolution: Invalid Created this Jira into the wrong project (should be in Apache Beam, not in Apache

[jira] [Created] (CALCITE-3992) Beam ZetaSQL supports pure SQL user-defined aggregation functions

Rui Wang created CALCITE-3992: - Summary: Beam ZetaSQL supports pure SQL user-defined aggregation functions Key: CALCITE-3992 URL: https://issues.apache.org/jira/browse/CALCITE-3992 Project: Calcite

[jira] [Commented] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104954#comment-17104954 ] Xiening Dai commented on CALCITE-3990: -- Current cost propagation is already done through BFS

[jira] [Commented] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104961#comment-17104961 ] James Kim commented on CALCITE-3990: I was mistakenly working with a older version of the repo. As

[jira] [Closed] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim closed CALCITE-3990. -- Resolution: Duplicate > Use a more efficient algorithm for cost propagation in Volcano planner >

[jira] [Commented] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104963#comment-17104963 ] Xiening Dai commented on CALCITE-3990: -- No problem, [~levv]. Thanks for confirming! > Use a more

[jira] [Commented] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104960#comment-17104960 ] James Kim commented on CALCITE-3990: I accidentally deleted my previous comment so I'll post it

[jira] [Updated] (CALCITE-3150) NPE in UPPER when repeated and combine with LIKE

[ https://issues.apache.org/jira/browse/CALCITE-3150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3150: --- Fix Version/s: (was: 1.23.0) > NPE in UPPER when repeated and combine with LIKE >

[jira] [Updated] (CALCITE-3716) ResultSetMetaData.getTableName should return empty string, not null, when column does not map to a table

[ https://issues.apache.org/jira/browse/CALCITE-3716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3716: --- Fix Version/s: (was: 1.23.0) > ResultSetMetaData.getTableName should return empty

[jira] [Updated] (CALCITE-3732) Implement bit functions and operators

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3732: --- Fix Version/s: (was: 1.23.0) > Implement bit functions and operators >

[jira] [Updated] (CALCITE-3717) Query fails with "division by zero" exception

[ https://issues.apache.org/jira/browse/CALCITE-3717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3717: --- Fix Version/s: (was: 1.23.0) > Query fails with "division by zero" exception >

[jira] [Updated] (CALCITE-3592) Implement BITNOT scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3592: --- Fix Version/s: (was: 1.23.0) > Implement BITNOT scalar function >

[jira] [Updated] (CALCITE-3841) Change downloads page to use downloads.apache.org

[ https://issues.apache.org/jira/browse/CALCITE-3841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3841: --- Fix Version/s: (was: 1.23.0) > Change downloads page to use downloads.apache.org >

[jira] [Updated] (CALCITE-3779) Implement BITAND scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3779: --- Fix Version/s: (was: 1.23.0) > Implement BITAND scalar function >

[jira] [Commented] (CALCITE-3990) Use a more efficient algorithm for cost propagation in Volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104964#comment-17104964 ] James Kim commented on CALCITE-3990: And thank you for the kind explanation. > Use a more

[jira] [Commented] (CALCITE-3979) Simplification might have removed CAST expression(s) incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-3979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104116#comment-17104116 ] Julian Hyde commented on CALCITE-3979: -- Removing casts concerning equality is dangerous, if the

[jira] [Commented] (CALCITE-3679) Allow lambda expressions in SQL queries

[ https://issues.apache.org/jira/browse/CALCITE-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104108#comment-17104108 ] Julian Hyde commented on CALCITE-3679: -- Sorry my comments seemed harsh. Like you, I am a volunteer

[jira] [Commented] (CALCITE-3979) Simplification might have removed CAST expression(s) incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-3979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104169#comment-17104169 ] Zoltan Haindrich commented on CALCITE-3979: --- [~julianhyde] yes it can be dangerousIn this

[jira] [Commented] (CALCITE-3977) RelDecorrelator does not resolve correlation variable with field accesses

[ https://issues.apache.org/jira/browse/CALCITE-3977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104194#comment-17104194 ] Thomas Rebele commented on CALCITE-3977: Indeed, good point. I've added b.field("birthPlace")

[jira] [Created] (CALCITE-3988) Intersect in RelMdRowCount doesn't take into account 'intersect all'

xzh_dz created CALCITE-3988: --- Summary: Intersect in RelMdRowCount doesn't take into account 'intersect all' Key: CALCITE-3988 URL: https://issues.apache.org/jira/browse/CALCITE-3988 Project: Calcite

[jira] [Commented] (CALCITE-3987) Allow addition and subtraction operations between DATE and NUMERIC types.

[ https://issues.apache.org/jira/browse/CALCITE-3987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104540#comment-17104540 ] Chunwei Lei commented on CALCITE-3987: -- Just for curious, What products support this syntax? >

[jira] [Updated] (CALCITE-3982) Simplify FilterMergeRule to rely on RelBuilder instead of RexProgram

[ https://issues.apache.org/jira/browse/CALCITE-3982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated CALCITE-3982: - Summary: Simplify FilterMergeRule to rely on RelBuilder instead of

[jira] [Resolved] (CALCITE-3982) Simplify FilterMergeRule to rely on RelBuilder instead of RexProgram

[ https://issues.apache.org/jira/browse/CALCITE-3982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez resolved CALCITE-3982. -- Fix Version/s: 1.23.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3977) RelDecorrelator does not resolve correlation variable with field accesses

[ https://issues.apache.org/jira/browse/CALCITE-3977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104543#comment-17104543 ] Ruben Q L commented on CALCITE-3977: There is clearly something wrong with the Decorrelator and the

[jira] [Commented] (CALCITE-3988) Intersect in RelMdRowCount doesn't take into account 'intersect all'

[ https://issues.apache.org/jira/browse/CALCITE-3988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104538#comment-17104538 ] Chunwei Lei commented on CALCITE-3988: -- [~xzh_dz] , thanks for the pr. I left some comments. >

[jira] [Commented] (CALCITE-3987) Allow addition and subtraction operations between DATE and NUMERIC types.

[ https://issues.apache.org/jira/browse/CALCITE-3987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104728#comment-17104728 ] Julian Hyde commented on CALCITE-3987: -- Oracle too. (Interestingly, Oracle stores DATE values

[jira] [Commented] (CALCITE-3988) Intersect in RelMdRowCount doesn't take into account 'intersect all'

[ https://issues.apache.org/jira/browse/CALCITE-3988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104740#comment-17104740 ] Julian Hyde commented on CALCITE-3988: -- FYI, you can create links to JIRA cases just by including

[jira] [Commented] (CALCITE-3987) Allow addition and subtraction operations between DATE and NUMERIC types.

[ https://issues.apache.org/jira/browse/CALCITE-3987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17104683#comment-17104683 ] Drew Schmitt commented on CALCITE-3987: --- Teradata supports this syntax. > Allow addition and

[jira] [Resolved] (CALCITE-3969) Method RelTrait.apply(Mappings.Mapping) throws exception when mapping doesn't cover collation or distribution keys

[ https://issues.apache.org/jira/browse/CALCITE-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3969. Resolution: Fixed Fixed in