[jira] [Updated] (CALCITE-5551) Implement SELECT * EXCEPT field

2023-03-02 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5551: Labels: pull-request-available (was: ) > Implement SELECT * EXCEPT field > -

[jira] [Commented] (CALCITE-5551) Implement SELECT * EXCEPT field

2023-03-02 Thread Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695570#comment-17695570 ] Zou commented on CALCITE-5551: -- [~hamnis] could you please add a doc link for this syntax

[jira] [Updated] (CALCITE-5551) Implement SELECT * EXCEPT field

2023-03-02 Thread Erlend Hamnaberg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Erlend Hamnaberg updated CALCITE-5551: -- Description: Some databases like bigquery support SELECT * Except (field1, field2)  

[jira] [Resolved] (CALCITE-5550) Update instructions for requesting Jira account to use self-serve facility

2023-03-02 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang resolved CALCITE-5550. - Resolution: Fixed > Update instructions for requesting Jira account to use self-serve f

[jira] [Commented] (CALCITE-5420) SqlToRel should populate the correlate id of a Project for queries with aggregates

2023-03-02 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695734#comment-17695734 ] libopeng commented on CALCITE-5420: --- [CALCITE-5544|https://issues.apache.org/jira/pro

[jira] [Created] (CALCITE-5552) Returned timestamp is incorrect after the 100:th row

2023-03-02 Thread Magnus Mogren (Jira)
Magnus Mogren created CALCITE-5552: -- Summary: Returned timestamp is incorrect after the 100:th row Key: CALCITE-5552 URL: https://issues.apache.org/jira/browse/CALCITE-5552 Project: Calcite

[jira] [Updated] (CALCITE-5552) Returned timestamp is incorrect after the 100th row

2023-03-02 Thread Magnus Mogren (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Magnus Mogren updated CALCITE-5552: --- Summary: Returned timestamp is incorrect after the 100th row (was: Returned timestamp is i

[jira] [Commented] (CALCITE-5545) Allow for overriding SqlValidator to enable custom SqlNode validation

2023-03-02 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695882#comment-17695882 ] Oliver Lee commented on CALCITE-5545: - I left a comment, otherwise it looks good. T

[jira] [Created] (CALCITE-5553) Calcite RelStructuredTypeFlattener produces bad plan for single field structs

2023-03-02 Thread Andrew Pilloud (Jira)
Andrew Pilloud created CALCITE-5553: --- Summary: Calcite RelStructuredTypeFlattener produces bad plan for single field structs Key: CALCITE-5553 URL: https://issues.apache.org/jira/browse/CALCITE-5553

[jira] [Updated] (CALCITE-5553) Calcite RelStructuredTypeFlattener produces bad plan for single field structs

2023-03-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5553: - Description: A Beam user brought us a query that produces an invalid plan after upgrading to a

[jira] [Commented] (CALCITE-5552) Returned timestamp is incorrect after the 100th row

2023-03-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695914#comment-17695914 ] Julian Hyde commented on CALCITE-5552: -- The most obvious explanation is that your

[jira] [Commented] (CALCITE-3877) In RexWindow, make fields upperBound and lowerBound not-nullable

2023-03-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695919#comment-17695919 ] Julian Hyde commented on CALCITE-3877: -- I was trying to induce categories of aggre

[jira] [Commented] (CALCITE-5543) Implement missing PARSE BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME.

2023-03-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695922#comment-17695922 ] Julian Hyde commented on CALCITE-5543: -- If you want to link two issues, use More >

[jira] [Commented] (CALCITE-5552) Returned timestamp is incorrect after the 100th row

2023-03-02 Thread Magnus Mogren (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695923#comment-17695923 ] Magnus Mogren commented on CALCITE-5552: [~julianhyde] no that is not the case.

[jira] [Commented] (CALCITE-5543) Implement missing PARSE BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME.

2023-03-02 Thread Marieke Gueye (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695934#comment-17695934 ] Marieke Gueye commented on CALCITE-5543: Done thanks ! > Implement missing PAR

[jira] [Updated] (CALCITE-5552) Returned timestamp is incorrect after the 100th row

2023-03-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5552: - Component/s: avatica > Returned timestamp is incorrect after the 100th row > --

[jira] [Commented] (CALCITE-5552) Returned timestamp is incorrect after the 100th row

2023-03-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695959#comment-17695959 ] Julian Hyde commented on CALCITE-5552: -- I did some investigation. (Thanks for the

[jira] [Updated] (CALCITE-5552) Returned timestamp is incorrect after the 100th row

2023-03-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5552: - Affects Version/s: avatica-1.23.0 (was: 1.33.0) > Returned timestamp

[jira] [Resolved] (CALCITE-5545) Allow for overriding SqlValidator to enable custom SqlNode validation

2023-03-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5545. -- Fix Version/s: 1.34.0 Resolution: Fixed Fixed in [4e1952096|https://github.com/apache

[jira] [Commented] (CALCITE-5413) Nested Subqueries with correlated variables are not decorrelated correctly

2023-03-02 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695982#comment-17695982 ] Benchao Li commented on CALCITE-5413: - [~jamesstarr] I'll review this PR in the nex

[jira] [Created] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

2023-03-02 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5554: - Summary: Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY Key: CALCITE-5554 URL: https://issues.apache.org/jira/browse/CALCITE-5554 Project: Calcite

[jira] [Updated] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

2023-03-02 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5554: Labels: pull-request-available (was: ) > Add DAYOFWEEK and DAYOFYEAR as valid synonyms o