[jira] [Created] (CALCITE-3884) Return type for SIGN function is incorrect

Juhwan Kim created CALCITE-3884: --- Summary: Return type for SIGN function is incorrect Key: CALCITE-3884 URL: https://issues.apache.org/jira/browse/CALCITE-3884 Project: Calcite Issue Type: Bug

[jira] [Comment Edited] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069217#comment-17069217 ] neoremind edited comment on CALCITE-3878 at 3/28/20, 4:39 AM: -- I didn't

[jira] [Comment Edited] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069217#comment-17069217 ] neoremind edited comment on CALCITE-3878 at 3/28/20, 4:34 AM: -- I didn't

[jira] [Commented] (CALCITE-3881) SqlFunctions#addMonths yields incorrect results in some corner case

[ https://issues.apache.org/jira/browse/CALCITE-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069218#comment-17069218 ] Danny Chen commented on CALCITE-3881: - Thanks for reporting this, [~docete] ~ I think both

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069217#comment-17069217 ] neoremind commented on CALCITE-3878: I didn't expect to bring so deep discussion on this. Sorry to

[jira] [Commented] (CALCITE-2980) Implement the FORMAT clause of the CAST operator

[ https://issues.apache.org/jira/browse/CALCITE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069154#comment-17069154 ] Rui Wang commented on CALCITE-2980: --- I will probably start from a design doc as the implementation

[jira] [Updated] (CALCITE-3876) RelToSqlConverter should not merge a Project that contains a window function that references a window function in input Project

[ https://issues.apache.org/jira/browse/CALCITE-3876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3876: - Summary: RelToSqlConverter should not merge a Project that contains a window function that

[jira] [Updated] (CALCITE-3876) RelToSqlConverter should not merge a Project that contains window function referencing window function in a lower Project

[ https://issues.apache.org/jira/browse/CALCITE-3876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3876: - Component/s: jdbc-adapter > RelToSqlConverter should not merge a Project that contains window

[jira] [Updated] (CALCITE-3876) RelToSqlConverter should not merge a Project that contains window function referencing window function in a lower Project

[ https://issues.apache.org/jira/browse/CALCITE-3876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3876: - Summary: RelToSqlConverter should not merge a Project that contains window function

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069128#comment-17069128 ] Xiening Dai commented on CALCITE-2970: -- [~hyuan][~zabetak][~julianhyde] I create a pull request

[jira] [Assigned] (CALCITE-3876) MergeProjectRule should not combine Projects when top Project contains window function referencing window function from bottom Project

[ https://issues.apache.org/jira/browse/CALCITE-3876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3876: Assignee: Julian Hyde > MergeProjectRule should not combine Projects when top Project

[jira] [Updated] (CALCITE-3876) MergeProjectRule should not combine Projects when top Project contains window function referencing window function from bottom Project

[ https://issues.apache.org/jira/browse/CALCITE-3876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3876: - Summary: MergeProjectRule should not combine Projects when top Project contains window

[jira] [Commented] (CALCITE-3881) SqlFunctions#addMonths yields incorrect results in some corner case

[ https://issues.apache.org/jira/browse/CALCITE-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069076#comment-17069076 ] Julian Hyde commented on CALCITE-3881: -- Your fix only works for 0 <= months < 24. You should make

[jira] [Commented] (CALCITE-3883) Multiple tests can fail if collection ordering is different than expected

[ https://issues.apache.org/jira/browse/CALCITE-3883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069072#comment-17069072 ] Julian Hyde commented on CALCITE-3883: -- Don't necessarily try to make things deterministic. If

[jira] [Commented] (CALCITE-3881) SqlFunctions#addMonths yields incorrect results in some corner case

[ https://issues.apache.org/jira/browse/CALCITE-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069001#comment-17069001 ] Julian Hyde commented on CALCITE-3881: -- Can we have a SQL test case? SqlFunctions.addMonths exists

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17069000#comment-17069000 ] Julian Hyde commented on CALCITE-3878: -- I wish we didn't have to spend time on this, too. Believe,

[jira] [Comment Edited] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068950#comment-17068950 ] Vladimir Sitnikov edited comment on CALCITE-3878 at 3/27/20, 6:08 PM:

[jira] [Comment Edited] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068950#comment-17068950 ] Vladimir Sitnikov edited comment on CALCITE-3878 at 3/27/20, 6:07 PM:

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068950#comment-17068950 ] Vladimir Sitnikov commented on CALCITE-3878: How about replacing: {noformat}

[jira] [Created] (CALCITE-3883) Multiple tests can fail if collection ordering is different than expected

Drew Schmitt created CALCITE-3883: - Summary: Multiple tests can fail if collection ordering is different than expected Key: CALCITE-3883 URL: https://issues.apache.org/jira/browse/CALCITE-3883

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068939#comment-17068939 ] Julian Hyde commented on CALCITE-3878: -- Some of these cases are for collections that are always

[jira] [Resolved] (CALCITE-3882) Remove duplicated code from SqlTypeAssignmentRule

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

[jira] [Updated] (CALCITE-3833) Support SemiJoin in EnumerableMergeJoin

[ https://issues.apache.org/jira/browse/CALCITE-3833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3833: Labels: pull-request-available (was: ) > Support SemiJoin in EnumerableMergeJoin >

[jira] [Resolved] (CALCITE-3864) Supports CONCAT for variable arguments

[ https://issues.apache.org/jira/browse/CALCITE-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu resolved CALCITE-3864. --- Resolution: Fixed > Supports CONCAT for variable arguments >

[jira] [Closed] (CALCITE-3864) Supports CONCAT for variable arguments

[ https://issues.apache.org/jira/browse/CALCITE-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu closed CALCITE-3864. - Resolution: Fixed > Supports CONCAT for variable arguments > -- >

[jira] [Reopened] (CALCITE-3864) Supports CONCAT for variable arguments

[ https://issues.apache.org/jira/browse/CALCITE-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu reopened CALCITE-3864: --- > Supports CONCAT for variable arguments > -- > >

[jira] [Reopened] (CALCITE-3864) Supports CONCAT for variable arguments

[ https://issues.apache.org/jira/browse/CALCITE-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu reopened CALCITE-3864: --- > Supports CONCAT for variable arguments > -- > >

[jira] [Resolved] (CALCITE-3864) Supports CONCAT for variable arguments

[ https://issues.apache.org/jira/browse/CALCITE-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu resolved CALCITE-3864. --- Fix Version/s: 1.23.0 Resolution: Resolved Fixed in

[jira] [Updated] (CALCITE-3882) Remove duplicated code from SqlTypeAssignmentRule

[ https://issues.apache.org/jira/browse/CALCITE-3882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3882: Labels: pull-request-available (was: ) > Remove duplicated code from

[jira] [Created] (CALCITE-3882) Remove duplicated code from SqlTypeAssignmentRule

TANG Wen-hui created CALCITE-3882: - Summary: Remove duplicated code from SqlTypeAssignmentRule Key: CALCITE-3882 URL: https://issues.apache.org/jira/browse/CALCITE-3882 Project: Calcite

[jira] [Resolved] (CALCITE-3846) EnumerableMergeJoin: wrong comparison of composite key with null values

[ https://issues.apache.org/jira/browse/CALCITE-3846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-3846. Resolution: Fixed > EnumerableMergeJoin: wrong comparison of composite key with null values >

[jira] [Updated] (CALCITE-3846) EnumerableMergeJoin: wrong comparison of composite key with null values

[ https://issues.apache.org/jira/browse/CALCITE-3846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3846: --- Fix Version/s: 1.23.0 > EnumerableMergeJoin: wrong comparison of composite key with null values >

[jira] [Commented] (CALCITE-3846) EnumerableMergeJoin: wrong comparison of composite key with null values

[ https://issues.apache.org/jira/browse/CALCITE-3846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068628#comment-17068628 ] Ruben Q L commented on CALCITE-3846: Fixed via

[jira] [Commented] (CALCITE-3881) SqlFunctions#addMonths yields incorrect results in some corner case

[ https://issues.apache.org/jira/browse/CALCITE-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068617#comment-17068617 ] Zhenghua Gao commented on CALCITE-3881: --- [~danny0405] Please take a look at this. Could this

[jira] [Updated] (CALCITE-3881) SqlFunctions#addMonths yields incorrect results in some corner case

[ https://issues.apache.org/jira/browse/CALCITE-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3881: Labels: pull-request-available (was: ) > SqlFunctions#addMonths yields incorrect

[jira] [Updated] (CALCITE-3216) ClassCastException when running aggregate function and window function over Union

[ https://issues.apache.org/jira/browse/CALCITE-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3216: Labels: pull-request-available (was: ) > ClassCastException when running aggregate

[jira] [Updated] (CALCITE-3881) SqlFunctions#addMonths yields incorrect results in some corner case

[ https://issues.apache.org/jira/browse/CALCITE-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenghua Gao updated CALCITE-3881: -- Description: SqlFunctions#addMonths use DateTimeUtils#ymdToUnixDate to calculate the

[jira] [Created] (CALCITE-3881) SqlFunctions#addMonths yields incorrect results in some corner case

Zhenghua Gao created CALCITE-3881: - Summary: SqlFunctions#addMonths yields incorrect results in some corner case Key: CALCITE-3881 URL: https://issues.apache.org/jira/browse/CALCITE-3881 Project:

[jira] [Updated] (CALCITE-3216) ClassCastException when running aggregate function and window function over Union

[ https://issues.apache.org/jira/browse/CALCITE-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TANG Wen-hui updated CALCITE-3216: -- Summary: ClassCastException when running aggregate function and window function over Union

[jira] [Updated] (CALCITE-3864) Supports CONCAT for variable arguments

[ https://issues.apache.org/jira/browse/CALCITE-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TANG Wen-hui updated CALCITE-3864: -- Summary: Supports CONCAT for variable arguments (was: Implement Concat function) >

[jira] [Comment Edited] (CALCITE-3871) Remove dependency of org.apiguardian:apiguardian-api

[ https://issues.apache.org/jira/browse/CALCITE-3871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068545#comment-17068545 ] Vladimir Sitnikov edited comment on CALCITE-3871 at 3/27/20, 10:42 AM:

[jira] [Commented] (CALCITE-3871) Remove dependency of org.apiguardian:apiguardian-api

[ https://issues.apache.org/jira/browse/CALCITE-3871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068545#comment-17068545 ] Vladimir Sitnikov commented on CALCITE-3871: Oh, that was fast. {quote}Stamatis: With this

[jira] [Updated] (CALCITE-3880) Add SortExchange support to RelFieldTrimmer

[ https://issues.apache.org/jira/browse/CALCITE-3880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3880: Labels: pull-request-available (was: ) > Add SortExchange support to RelFieldTrimmer >

[jira] [Comment Edited] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068428#comment-17068428 ] neoremind edited comment on CALCITE-3878 at 3/27/20, 8:54 AM: --

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068428#comment-17068428 ] neoremind commented on CALCITE-3878: [~donnyzone] For code style, I think that is a good advice but

[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 ] ASF GitHub Bot updated CALCITE-3782: Labels: pull-request-available (was: ) > Bitwise operator Bit_And, Bit_OR and Bit_XOR

[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 ] hailong wang updated CALCITE-3782: -- Description: According to the discussion  link CALCITE-3732 , We should make bitwise

[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 ] hailong wang updated CALCITE-3782: -- Description: According to the discussion  [link

[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 ] hailong wang updated CALCITE-3782: -- Description: According to the discussion CALCITE_3732 We should make bitwise operators work

[jira] [Updated] (CALCITE-3880) Add SortExchange support to RelFieldTrimmer

[ https://issues.apache.org/jira/browse/CALCITE-3880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated CALCITE-3880: Description: {code} LogicalProject(EMPNO=[$0])

[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 ] hailong wang updated CALCITE-3782: -- Description: According to the discussion [link

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068416#comment-17068416 ] neoremind commented on CALCITE-3878: [~vladimirsitnikov] The variance does look odd, but score

[jira] [Comment Edited] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068416#comment-17068416 ] neoremind edited comment on CALCITE-3878 at 3/27/20, 8:28 AM: --

[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 ] hailong wang updated CALCITE-3782: -- Description: According to the discussion  > Bitwise operator Bit_And, Bit_OR and Bit_XOR

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068412#comment-17068412 ] Vladimir Sitnikov commented on CALCITE-3878: The variance of the results is odd, however,

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068401#comment-17068401 ] neoremind commented on CALCITE-3878: [~vladimirsitnikov] I update the code to return list, the

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068397#comment-17068397 ] Feng Zhu commented on CALCITE-3878: --- Certainly, changes made by this PR can help to improve the

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068391#comment-17068391 ] Vladimir Sitnikov commented on CALCITE-3878: [~julianhyde], I'm afraid you might confuse

[jira] [Commented] (CALCITE-3878) Make ArrayList creation with initial capacity when size is fixed

[ https://issues.apache.org/jira/browse/CALCITE-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17068389#comment-17068389 ] Vladimir Sitnikov commented on CALCITE-3878: [~neoremind], the benchmark might suffer from

[jira] [Created] (CALCITE-3880) Add SortExchange support to RelFieldTrimmer

Krisztian Kasa created CALCITE-3880: --- Summary: Add SortExchange support to RelFieldTrimmer Key: CALCITE-3880 URL: https://issues.apache.org/jira/browse/CALCITE-3880 Project: Calcite Issue