[jira] [Commented] (CALCITE-6362) JSON_OBJECT. Internal representation of DATE values leaks into resulting JSON object

[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836420#comment-17836420 ] Alessandro Solimando commented on CALCITE-6362: --- [~mzhuravkov] if you consider the

[jira] [Commented] (CALCITE-6362) JSON_OBJECT. Internal representation of DATE values leaks into resulting JSON object

[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836413#comment-17836413 ] Maksim Zhuravkov commented on CALCITE-6362: --- [~mbudiu], thank you. The expression with an

[jira] [Updated] (CALCITE-6362) JSON_OBJECT. Internal representation of DATE values leaks into resulting JSON object

[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated CALCITE-6362: -- Summary: JSON_OBJECT. Internal representation of DATE values leaks into resulting

[jira] [Commented] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836376#comment-17836376 ] James Starr commented on CALCITE-5743: -- [~leepb]Yes, that looks correct follow my suggestion, but

[jira] [Resolved] (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:all-tabpanel ] Tanner Clary resolved CALCITE-2980. --- Fix Version/s: 1.37.0 Resolution: Fixed Merged via

[jira] [Commented] (CALCITE-6313) Add POWER (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836374#comment-17836374 ] James Duong commented on CALCITE-6313: -- You can have multiple SqlOperator objects that map to the

[jira] [Comment Edited] (CALCITE-6313) Add POWER (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836374#comment-17836374 ] James Duong edited comment on CALCITE-6313 at 4/11/24 10:58 PM: You can

[jira] [Commented] (CALCITE-6313) Add POWER (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836373#comment-17836373 ] Norman Jordan commented on CALCITE-6313: [~tanclary] There is already a POWER function that

[jira] [Updated] (CALCITE-6340) RelBuilder always creates Project with Convention.NONE during aggregate_

[ https://issues.apache.org/jira/browse/CALCITE-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6340: Labels: pull-request-available (was: ) > RelBuilder always creates Project with

[jira] [Assigned] (CALCITE-6313) Add POWER (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6313: -- Assignee: Norman Jordan > Add POWER (enabled in Postgres library) >

[jira] [Updated] (CALCITE-6313) Add POWER (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6313: --- Summary: Add POWER (enabled in Postgres library) (was: Support PostgreSQL POW) > Add

[jira] [Commented] (CALCITE-6361) Uncollect.deriveUncollectRowType crashes if the input data is not a collection

[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836363#comment-17836363 ] Mihai Budiu commented on CALCITE-6361: -- This is an assertion failure: {code:java}

[jira] [Commented] (CALCITE-6357) Calcite enforces select arguments count to be same as row schema fields which causes aliases to be ignored

[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836338#comment-17836338 ] Julian Hyde commented on CALCITE-6357: -- We added {{RelRoot}} way back in CALCITE-819 to express

[jira] [Commented] (CALCITE-6357) Calcite enforces select arguments count to be same as row schema fields which causes aliases to be ignored

[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836303#comment-17836303 ] Kenneth Knowles commented on CALCITE-6357: -- I'm still stuck on the idea that if I write

[jira] [Commented] (CALCITE-6358) Support all PostgreSQL 14 date/time patterns

[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836284#comment-17836284 ] Julian Hyde commented on CALCITE-6358: -- Yes, in theory, it might. I don't have time to look at the

[jira] [Commented] (CALCITE-6362) JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object

[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836274#comment-17836274 ] Mihai Budiu commented on CALCITE-6362: -- I guess that the spec for JSON_OBJECT is not really clear

[jira] [Commented] (CALCITE-6358) Support all PostgreSQL 14 date/time patterns

[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836270#comment-17836270 ] Norman Jordan commented on CALCITE-6358: [~julianhyde] The request on my side is for 

[jira] [Commented] (CALCITE-6358) Support all PostgreSQL 14 date/time patterns

[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836261#comment-17836261 ] Julian Hyde commented on CALCITE-6358: -- In Calcite, the set of format elements is tied to

[jira] [Commented] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836260#comment-17836260 ] Mihai Budiu commented on CALCITE-6265: -- It looks to me like the right course of action is to file

[jira] [Commented] (CALCITE-6358) Support all PostgreSQL 14 date/time patterns

[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836258#comment-17836258 ] Norman Jordan commented on CALCITE-6358: [~julianhyde] {*}TO_CHAR(){*}, {*}TO_DATE(){*},

[jira] [Comment Edited] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836187#comment-17836187 ] Ruben Q L edited comment on CALCITE-6265 at 4/11/24 2:06 PM: - FYI, this fix

[jira] [Comment Edited] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836187#comment-17836187 ] Ruben Q L edited comment on CALCITE-6265 at 4/11/24 1:47 PM: - FYI, this fix

[jira] [Comment Edited] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836187#comment-17836187 ] Ruben Q L edited comment on CALCITE-6265 at 4/11/24 1:45 PM: - FYI, this fix

[jira] [Commented] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836187#comment-17836187 ] Ruben Q L commented on CALCITE-6265: FYI, this fix caused a few regressions on my project: A) one

[jira] [Commented] (CALCITE-6362) JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object

[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836181#comment-17836181 ] Alessandro Solimando commented on CALCITE-6362: --- I agree that getting a string with the

[jira] [Updated] (CALCITE-6362) JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object

[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated CALCITE-6362: -- Description: When a CAST function is used inside a JSON_OBJECT, then resulting JSON

[jira] [Updated] (CALCITE-6362) JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object

[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated CALCITE-6362: -- Component/s: core > JSON_OBJECT. Internal representation DATE values leaks into

[jira] [Created] (CALCITE-6362) JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object

Maksim Zhuravkov created CALCITE-6362: - Summary: JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object Key: CALCITE-6362 URL: https://issues.apache.org/jira/browse/CALCITE-6362

[jira] [Commented] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836172#comment-17836172 ] libopeng commented on CALCITE-5743: --- {code:java} LogicalProject(A=[$0])