[jira] [Created] (CALCITE-5492) Adjusting dates based on time zone doesn't always make sense

2023-01-23 Thread Will Noble (Jira)
Will Noble created CALCITE-5492: --- Summary: Adjusting dates based on time zone doesn't always make sense Key: CALCITE-5492 URL: https://issues.apache.org/jira/browse/CALCITE-5492 Project: Calcite

[jira] [Updated] (CALCITE-5492) Adjusting dates based on time zone doesn't always make sense

2023-01-23 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Will Noble updated CALCITE-5492: Priority: Minor (was: Major) > Adjusting dates based on time zone doesn't always make sense > --

[jira] [Assigned] (CALCITE-5492) Adjusting dates based on time zone doesn't always make sense

2023-01-23 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Will Noble reassigned CALCITE-5492: --- Assignee: Will Noble > Adjusting dates based on time zone doesn't always make sense >

[jira] [Commented] (CALCITE-5180) Implement BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME

2023-01-23 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17680068#comment-17680068 ] Oliver Lee commented on CALCITE-5180: - Hey [~julianhyde]  PR ready here: [https://

[jira] [Commented] (CALCITE-5491) Cannot apply 'TIMESTAMPDIFF' to arguments of type 'TIMESTAMPDIFF

2023-01-23 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17680060#comment-17680060 ] Tanner Clary commented on CALCITE-5491: --- [~Sergey Nuyanzin] Ah ok, in that case I

[jira] [Commented] (CALCITE-5491) Cannot apply 'TIMESTAMPDIFF' to arguments of type 'TIMESTAMPDIFF

2023-01-23 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17680059#comment-17680059 ] Sergey Nuyanzin commented on CALCITE-5491: -- yes it works for combinations of

[jira] [Comment Edited] (CALCITE-5491) Cannot apply 'TIMESTAMPDIFF' to arguments of type 'TIMESTAMPDIFF

2023-01-23 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17680058#comment-17680058 ] Tanner Clary edited comment on CALCITE-5491 at 1/23/23 11:16 PM:

[jira] [Commented] (CALCITE-5491) Cannot apply 'TIMESTAMPDIFF' to arguments of type 'TIMESTAMPDIFF

2023-01-23 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17680058#comment-17680058 ] Tanner Clary commented on CALCITE-5491: --- [~Sergey Nuyanzin] This looks great to m

[jira] [Commented] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17680057#comment-17680057 ] Sergey Nuyanzin commented on CALCITE-5489: -- Hi [~tanclary], thanks for the fee

[jira] [Updated] (CALCITE-5491) Cannot apply 'TIMESTAMPDIFF' to arguments of type 'TIMESTAMPDIFF

2023-01-23 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5491: Labels: pull-request-available (was: ) > Cannot apply 'TIMESTAMPDIFF' to arguments of ty

[jira] [Created] (CALCITE-5491) Cannot apply 'TIMESTAMPDIFF' to arguments of type 'TIMESTAMPDIFF

2023-01-23 Thread Sergey Nuyanzin (Jira)
Sergey Nuyanzin created CALCITE-5491: Summary: Cannot apply 'TIMESTAMPDIFF' to arguments of type 'TIMESTAMPDIFF Key: CALCITE-5491 URL: https://issues.apache.org/jira/browse/CALCITE-5491 Project: C

[jira] [Commented] (CALCITE-5488) Avatica double-adjusts timestamps when calling Array.getResultSet()

2023-01-23 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17680016#comment-17680016 ] Will Noble commented on CALCITE-5488: - This is actually a pretty narrow bug. I'll s

[jira] [Commented] (CALCITE-5490) Add a 'naiveMeasures' connection property to allow regular aggregate functions (e.g. SUM, MIN) to be used instead of AGGREGATE

2023-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17680006#comment-17680006 ] Julian Hyde commented on CALCITE-5490: -- Suggestions for a better name than "naiveM

[jira] [Assigned] (CALCITE-5490) Add a 'naiveMeasures' connection property to allow regular aggregate functions (e.g. SUM, MIN) to be used instead of AGGREGATE

2023-01-23 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5490: Assignee: TJ Banghart > Add a 'naiveMeasures' connection property to allow regular aggre

[jira] [Created] (CALCITE-5490) Add a 'naiveMeasures' connection property to allow regular aggregate functions (e.g. SUM, MIN) to be used instead of AGGREGATE

2023-01-23 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-5490: Summary: Add a 'naiveMeasures' connection property to allow regular aggregate functions (e.g. SUM, MIN) to be used instead of AGGREGATE Key: CALCITE-5490 URL: https://issues.apach

[jira] [Commented] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17679989#comment-17679989 ] Tanner Clary commented on CALCITE-5489: --- [~julianhyde] Yes, it looks like the che

[jira] [Updated] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5489: - Affects Version/s: (was: 1.33.0) > Cannot convert TIMESTAMP literal to class > org.apache.

[jira] [Updated] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5489: - Fix Version/s: 1.33.0 > Cannot convert TIMESTAMP literal to class > org.apache.calcite.avatica

[jira] [Commented] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17679971#comment-17679971 ] Julian Hyde commented on CALCITE-5489: -- [~tanclary], As you authored CALCITE-5360,

[jira] [Assigned] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-5489: Assignee: Tanner Clary > Cannot convert TIMESTAMP literal to class > org.apache.calcite

[jira] [Updated] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-5489: - Priority: Blocker (was: Major) > Cannot convert TIMESTAMP literal to class > org.apac

[jira] [Commented] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17679770#comment-17679770 ] Sergey Nuyanzin commented on CALCITE-5489: -- yes it looks like a regression, sa

[jira] [Updated] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-5489: - Description: It seems it stops working after {noformat} [CALCITE-5360] Add TIMESTAMP_AD

[jira] [Updated] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5489: Labels: pull-request-available (was: ) > Cannot convert TIMESTAMP literal to class > or

[jira] [Commented] (CALCITE-5342) Refactor SqlFunctions lastDay, addMonths, subtractMonths to use DateTimeUtils from Avatica

2023-01-23 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17679734#comment-17679734 ] Stamatis Zampetakis commented on CALCITE-5342: -- Thanks for taking care of

[jira] [Commented] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-23 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17679737#comment-17679737 ] Stamatis Zampetakis commented on CALCITE-5489: -- [~Sergey Nuyanzin] Is this