[jira] [Created] (CALCITE-6548) Result type inferred for COVAR_SAMP、COVAR_POP is incorrect

xiong duan created CALCITE-6548: --- Summary: Result type inferred for COVAR_SAMP、COVAR_POP is incorrect Key: CALCITE-6548 URL: https://issues.apache.org/jira/browse/CALCITE-6548 Project: Calcite

[jira] [Resolved] (CALCITE-6546) Hive dialect does not support a sub-query in the FROM clause without alias

[ https://issues.apache.org/jira/browse/CALCITE-6546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan resolved CALCITE-6546. - Resolution: Fixed > Hive dialect does not support a sub-query in the FROM clause without alias

[jira] [Commented] (CALCITE-6546) Hive dialect does not support a sub-query in the FROM clause without alias

[ https://issues.apache.org/jira/browse/CALCITE-6546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876916#comment-17876916 ] xiong duan commented on CALCITE-6546: - Fixed in [1a18264be5|https://github.com/apa

[jira] [Updated] (CALCITE-6547) Result type inferred for STDDEV_SAMP is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-6547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6547: Labels: pull-request-available (was: ) > Result type inferred for STDDEV_SAMP is incorre

[jira] [Assigned] (CALCITE-4744) Defer windowed aggregation function expansion to the planning step

[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-4744: Assignee: (was: Mihai Budiu) > Defer windowed aggregation function expansion to the

[jira] [Assigned] (CALCITE-6547) Result type inferred for STDDEV_SAMP is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-6547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-6547: Assignee: Mihai Budiu > Result type inferred for STDDEV_SAMP is incorrect >

[jira] [Assigned] (CALCITE-4744) Defer windowed aggregation function expansion to the planning step

[ https://issues.apache.org/jira/browse/CALCITE-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-4744: Assignee: Mihai Budiu > Defer windowed aggregation function expansion to the planning s

[jira] [Created] (CALCITE-6547) Result type inferred for STDDEV_SAMP is incorrect

Mihai Budiu created CALCITE-6547: Summary: Result type inferred for STDDEV_SAMP is incorrect Key: CALCITE-6547 URL: https://issues.apache.org/jira/browse/CALCITE-6547 Project: Calcite Issue T

[jira] [Commented] (CALCITE-5182) STDDEV returning NaN values

[ https://issues.apache.org/jira/browse/CALCITE-5182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876911#comment-17876911 ] Mihai Budiu commented on CALCITE-5182: -- This is a duplicate of [CALCITE-6080] > S

[jira] [Commented] (CALCITE-6080) The simplified form after applying AggregateReduceFunctionsRule is giving wrong results for STDDEV, Covariance with double and decimal types.

[ https://issues.apache.org/jira/browse/CALCITE-6080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876910#comment-17876910 ] Mihai Budiu commented on CALCITE-6080: -- This is due to rounding errors in FP compu

[jira] [Updated] (CALCITE-6546) Hive dialect does not support a sub-query in the FROM clause without alias

[ https://issues.apache.org/jira/browse/CALCITE-6546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6546: Labels: pull-request-available (was: ) > Hive dialect does not support a sub-query in th

[jira] [Commented] (CALCITE-6544) Calcite's bigquery Dialect date_add and date_sub functions allow 0000 and BC as results

[ https://issues.apache.org/jira/browse/CALCITE-6544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876882#comment-17876882 ] Caican Cai commented on CALCITE-6544: - [~julianhyde] So is this a bug? I guess all

[jira] [Updated] (CALCITE-6546) Hive dialect does not support a sub-query in the FROM clause without alias

[ https://issues.apache.org/jira/browse/CALCITE-6546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6546: Description: In Hive, the SQL: {code:java} select * from (select * from table1); {code} will thr

[jira] [Updated] (CALCITE-6546) Hive dialect does not support a sub-query in the FROM clause without alias

[ https://issues.apache.org/jira/browse/CALCITE-6546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6546: Environment: (was: In Hive, the SQL: {code:java} select * from (select * from table1); {code}

[jira] [Created] (CALCITE-6546) Hive dialect does not support a sub-query in the FROM clause without alias

xiong duan created CALCITE-6546: --- Summary: Hive dialect does not support a sub-query in the FROM clause without alias Key: CALCITE-6546 URL: https://issues.apache.org/jira/browse/CALCITE-6546 Project: C

[jira] [Resolved] (CALCITE-6308) Add PostgreSQL functions up to PostgreSQL v14

[ https://issues.apache.org/jira/browse/CALCITE-6308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan resolved CALCITE-6308. Resolution: Fixed All subtasks have been completed. See subtasks for further details. >

[jira] [Commented] (CALCITE-6308) Add PostgreSQL functions up to PostgreSQL v14

[ https://issues.apache.org/jira/browse/CALCITE-6308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876847#comment-17876847 ] Mihai Budiu commented on CALCITE-6308: -- Feel free to resolve it. > Add PostgreSQL

[jira] [Commented] (CALCITE-6308) Add PostgreSQL functions up to PostgreSQL v14

[ https://issues.apache.org/jira/browse/CALCITE-6308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876846#comment-17876846 ] Norman Jordan commented on CALCITE-6308: It looks like all subtasks have been c

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876842#comment-17876842 ] Ian Bertolacci commented on CALCITE-5213: - [~libenchao] Looks like that no corr

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876837#comment-17876837 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/26/24 9:13 PM: ---

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876837#comment-17876837 ] Ian Bertolacci commented on CALCITE-5213: - [~libenchao] I now realize the impor

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876825#comment-17876825 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/26/24 7:05 PM: ---

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876828#comment-17876828 ] Ian Bertolacci commented on CALCITE-5213: - It also appears that the decorrelato

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876825#comment-17876825 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/26/24 7:04 PM: ---

[jira] [Resolved] (CALCITE-4806) Lossy CAST is incorrectly simplified

[ https://issues.apache.org/jira/browse/CALCITE-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-4806. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed by some earlier commit, but certified fi

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876825#comment-17876825 ] Ian Bertolacci commented on CALCITE-5213: - So I was able to quickly come up wit

[jira] [Commented] (CALCITE-6545) SqlToRel does not honor expand = false for IN Subquery with literals

[ https://issues.apache.org/jira/browse/CALCITE-6545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876800#comment-17876800 ] Brandon Chong commented on CALCITE-6545: I have a local fix if the community is

[jira] [Created] (CALCITE-6545) SqlToRel does not honor expand = false for IN Subquery with literals

Brandon Chong created CALCITE-6545: -- Summary: SqlToRel does not honor expand = false for IN Subquery with literals Key: CALCITE-6545 URL: https://issues.apache.org/jira/browse/CALCITE-6545 Project: C

[jira] [Commented] (CALCITE-6544) Calcite's bigquery Dialect date_add and date_sub functions allow 0000 and BC as results

[ https://issues.apache.org/jira/browse/CALCITE-6544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876791#comment-17876791 ] Julian Hyde commented on CALCITE-6544: -- Maybe BigQuery's {{DATE}} data type has a

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876789#comment-17876789 ] Ian Bertolacci commented on CALCITE-5213: - Ya we've been looking at that, but t