[jira] [Assigned] (CALCITE-3592) Implement BITNOT scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-3592: -- Assignee: Norman Jordan (was: hailong wang) > Implement BITNOT scalar function > -

[jira] [Commented] (CALCITE-6585) In the Postgres TO_CHAR function, improve caching

[ https://issues.apache.org/jira/browse/CALCITE-6585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17884447#comment-17884447 ] Norman Jordan commented on CALCITE-6585: [~julianhyde]  I have posted a PR. LO

[jira] [Commented] (CALCITE-6585) In the Postgres TO_CHAR function, improve caching

[ https://issues.apache.org/jira/browse/CALCITE-6585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882521#comment-17882521 ] Norman Jordan commented on CALCITE-6585: For now I have time to work on this. G

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882500#comment-17882500 ] Norman Jordan commented on CALCITE-6020: [~mbudiu] What is the status of this t

[jira] [Commented] (CALCITE-6585) In the Postgres TO_CHAR function, improve caching

[ https://issues.apache.org/jira/browse/CALCITE-6585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882484#comment-17882484 ] Norman Jordan commented on CALCITE-6585: A first step here is to split the oper

[jira] [Assigned] (CALCITE-6585) In the Postgres TO_CHAR function, improve caching

[ https://issues.apache.org/jira/browse/CALCITE-6585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6585: -- Assignee: Norman Jordan > In the Postgres TO_CHAR function, improve caching > --

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882199#comment-17882199 ] Norman Jordan commented on CALCITE-6580: [~julianhyde]  I have updated the PR t

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881702#comment-17881702 ] Norman Jordan commented on CALCITE-6580: [~mbudiu] Thanks, that should resolve

[jira] [Comment Edited] (CALCITE-6580) Remove Locale.setDefault

[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881693#comment-17881693 ] Norman Jordan edited comment on CALCITE-6580 at 9/13/24 9:20 PM:

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881697#comment-17881697 ] Norman Jordan commented on CALCITE-6580: Is it possible for the locale of an SQ

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881693#comment-17881693 ] Norman Jordan commented on CALCITE-6580: PostgreSQL will use English as the lan

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881694#comment-17881694 ] Norman Jordan commented on CALCITE-6580: I have attached a PR to this ticket. I

[jira] [Commented] (CALCITE-6572) Add more tests for NULL arguments to TO_CHAR functions

[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881637#comment-17881637 ] Norman Jordan commented on CALCITE-6572: Added some tests to *TO_CHAR* as well.

[jira] [Updated] (CALCITE-6572) Add more tests for NULL result of TO_CHAR PostgreSQL function

[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6572: --- Summary: Add more tests for NULL result of TO_CHAR PostgreSQL function (was: Calcite TO_CH

[jira] [Commented] (CALCITE-6572) Add more tests for NULL result of TO_CHAR PostgreSQL function

[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881129#comment-17881129 ] Norman Jordan commented on CALCITE-6572: Updated the title of this ticket. > A

[jira] [Commented] (CALCITE-6572) Calcite TO_CHAR function is incorrectly marked as returning a non-nullable result

[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881124#comment-17881124 ] Norman Jordan commented on CALCITE-6572: There are quite a few tests here. [ht

[jira] [Assigned] (CALCITE-6572) Calcite TO_CHAR function is incorrectly marked as returning a non-nullable result

[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6572: -- Assignee: Norman Jordan > Calcite TO_CHAR function is incorrectly marked as returnin

[jira] [Commented] (CALCITE-6572) Calcite TO_CHAR function is incorrectly marked as returning a non-nullable result

[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881093#comment-17881093 ] Norman Jordan commented on CALCITE-6572: I'll take a look at this issue this we

[jira] [Commented] (CALCITE-6550) Improve SQL function overloading

[ https://issues.apache.org/jira/browse/CALCITE-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17880405#comment-17880405 ] Norman Jordan commented on CALCITE-6550: I have published a PR. The main idea

[jira] [Commented] (CALCITE-6550) Improve SQL function overloading

[ https://issues.apache.org/jira/browse/CALCITE-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17878247#comment-17878247 ] Norman Jordan commented on CALCITE-6550: [~caicancai] I see that you have a way

[jira] [Commented] (CALCITE-3779) Implement BITAND, BITOR, BITXOR scalar functions

[ https://issues.apache.org/jira/browse/CALCITE-3779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17878222#comment-17878222 ] Norman Jordan commented on CALCITE-3779: Posted a new PR that includes BITAND,

[jira] [Assigned] (CALCITE-3779) Implement BITAND scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-3779: -- Assignee: Norman Jordan > Implement BITAND scalar function > ---

[jira] [Updated] (CALCITE-3779) Implement BITAND, BITOR, BITXOR scalar functions

[ https://issues.apache.org/jira/browse/CALCITE-3779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-3779: --- Summary: Implement BITAND, BITOR, BITXOR scalar functions (was: Implement BITAND scalar fu

[jira] [Created] (CALCITE-6550) Improve SQL function overloading

Norman Jordan created CALCITE-6550: -- Summary: Improve SQL function overloading Key: CALCITE-6550 URL: https://issues.apache.org/jira/browse/CALCITE-6550 Project: Calcite Issue Type: Improvem

[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=17876846#comment-17876846 ] Norman Jordan commented on CALCITE-6308: It looks like all subtasks have been c

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876384#comment-17876384 ] Norman Jordan commented on CALCITE-6020: AVG() of only null values gives a null

[jira] [Updated] (CALCITE-3697) Implement BITCOUNT scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-3697: --- Description: Implement bit_count function MySQL BIT_COUNT: [https://dev.mysql.com/doc/ref

[jira] [Commented] (CALCITE-3697) Implement BITCOUNT scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3697?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876378#comment-17876378 ] Norman Jordan commented on CALCITE-3697: [~julianhyde] I have updated the descr

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876133#comment-17876133 ] Norman Jordan commented on CALCITE-6020: That explains it. Maybe a guard is nee

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876130#comment-17876130 ] Norman Jordan commented on CALCITE-6020: I'd like to understand why the new rul

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876126#comment-17876126 ] Norman Jordan commented on CALCITE-6020: The AVG would get converted to SUM/COU

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876125#comment-17876125 ] Norman Jordan commented on CALCITE-6020: There could be a bug with my change if

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876120#comment-17876120 ] Norman Jordan commented on CALCITE-6020: You are correct that SUM0 will never p

[jira] [Assigned] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6020: -- Assignee: Norman Jordan (was: Zoltan Haindrich) > SqlToRelConverter should not repl

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876114#comment-17876114 ] Norman Jordan commented on CALCITE-6020: [~mbudiu] Let's revert the change if n

[jira] [Commented] (CALCITE-3697) Implement BITCOUNT scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3697?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875671#comment-17875671 ] Norman Jordan commented on CALCITE-3697: I have submitted a new PR (#3972). It

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874325#comment-17874325 ] Norman Jordan commented on CALCITE-6020: [~julianhyde] I have updated the PR [

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873751#comment-17873751 ] Norman Jordan commented on CALCITE-6020: I have played around with creating a n

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873636#comment-17873636 ] Norman Jordan commented on CALCITE-6020: I'm looking into creating a new RelRul

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869042#comment-17869042 ] Norman Jordan commented on CALCITE-6020: I am working on adding more tests, but

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17868493#comment-17868493 ] Norman Jordan commented on CALCITE-6020: [~jhyde] Update PR here. [https://git

[jira] [Commented] (CALCITE-6483) Enable LEN and LENGTH in the correct function libraries

[ https://issues.apache.org/jira/browse/CALCITE-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867428#comment-17867428 ] Norman Jordan commented on CALCITE-6483: Looked through documentation and found

[jira] [Updated] (CALCITE-6483) Enable LEN and LENGTH in the correct function libraries

[ https://issues.apache.org/jira/browse/CALCITE-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6483: --- Summary: Enable LEN and LENGTH in the correct function libraries (was: Add length to Postg

[jira] [Commented] (CALCITE-6472) Add degree based trigonometric functions to PostgreSQL function library

[ https://issues.apache.org/jira/browse/CALCITE-6472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17866855#comment-17866855 ] Norman Jordan commented on CALCITE-6472: Updated the title. > Add degree based

[jira] [Updated] (CALCITE-6472) Add degree based trigonometric functions to PostgreSQL function library

[ https://issues.apache.org/jira/browse/CALCITE-6472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6472: --- Summary: Add degree based trigonometric functions to PostgreSQL function library (was: Add

[jira] [Updated] (CALCITE-6483) Add length to PostgreSQL function library

[ https://issues.apache.org/jira/browse/CALCITE-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6483: --- Summary: Add length to PostgreSQL function library (was: Add position and length to Postgr

[jira] [Updated] (CALCITE-6483) Add length to PostgreSQL function library

[ https://issues.apache.org/jira/browse/CALCITE-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6483: --- Description: PostgreSQL supports the *LENGTH* string function. [https://www.postgresql.org

[jira] [Commented] (CALCITE-6483) Add position and length to PostgreSQL function library

[ https://issues.apache.org/jira/browse/CALCITE-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17866850#comment-17866850 ] Norman Jordan commented on CALCITE-6483: Typo in the query, should have used "I

[jira] [Commented] (CALCITE-6483) Add position and length to PostgreSQL function library

[ https://issues.apache.org/jira/browse/CALCITE-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17866847#comment-17866847 ] Norman Jordan commented on CALCITE-6483: Position is actually a standard functi

[jira] [Created] (CALCITE-6483) Add position and length to PostgreSQL function library

Norman Jordan created CALCITE-6483: -- Summary: Add position and length to PostgreSQL function library Key: CALCITE-6483 URL: https://issues.apache.org/jira/browse/CALCITE-6483 Project: Calcite

[jira] [Commented] (CALCITE-6472) Add degree based trig functions to PostgreSQL function library

[ https://issues.apache.org/jira/browse/CALCITE-6472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17866814#comment-17866814 ] Norman Jordan commented on CALCITE-6472: [~nobigo] Are you suggesting to change

[jira] [Created] (CALCITE-6472) Add degree based trig functions to PostgreSQL function library

Norman Jordan created CALCITE-6472: -- Summary: Add degree based trig functions to PostgreSQL function library Key: CALCITE-6472 URL: https://issues.apache.org/jira/browse/CALCITE-6472 Project: Calcite

[jira] [Commented] (CALCITE-6310) Add REGEXP_REPLACE function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17865232#comment-17865232 ] Norman Jordan commented on CALCITE-6310: I can also enable to two argument vers

[jira] [Commented] (CALCITE-6310) Add REGEXP_REPLACE function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17865231#comment-17865231 ] Norman Jordan commented on CALCITE-6310: Yeah, I should be able to. I'll give i

[jira] [Commented] (CALCITE-6312) Add LOG function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17865224#comment-17865224 ] Norman Jordan commented on CALCITE-6312: [~caicancai] I don't have access to Bi

[jira] [Assigned] (CALCITE-6310) Add REGEXP_REPLACE function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6310: -- Assignee: Norman Jordan (was: James Duong) > Add REGEXP_REPLACE function (enabled i

[jira] [Commented] (CALCITE-6310) Add REGEXP_REPLACE function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17865222#comment-17865222 ] Norman Jordan commented on CALCITE-6310: [~julianhyde] I have reworked the PR.

[jira] [Assigned] (CALCITE-6454) Implement array comparison operators

[ https://issues.apache.org/jira/browse/CALCITE-6454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6454: -- Assignee: Norman Jordan > Implement array comparison operators > ---

[jira] [Commented] (CALCITE-6454) Implement array comparison operators

[ https://issues.apache.org/jira/browse/CALCITE-6454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17862582#comment-17862582 ] Norman Jordan commented on CALCITE-6454: The comparison is applied element by e

[jira] [Commented] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17862572#comment-17862572 ] Norman Jordan commented on CALCITE-5634: [~julianhyde] I have tested that compa

[jira] [Commented] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17862505#comment-17862505 ] Norman Jordan commented on CALCITE-5634: [~nobigo] Thanks for the comment. I ha

[jira] [Commented] (CALCITE-6454) Implement array comparison operators

[ https://issues.apache.org/jira/browse/CALCITE-6454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17862504#comment-17862504 ] Norman Jordan commented on CALCITE-6454: GREATEST and LEAST functions should su

[jira] [Created] (CALCITE-6454) Implement array comparison operators

Norman Jordan created CALCITE-6454: -- Summary: Implement array comparison operators Key: CALCITE-6454 URL: https://issues.apache.org/jira/browse/CALCITE-6454 Project: Calcite Issue Type: Impr

[jira] [Assigned] (CALCITE-6449) Enable PostgreSQL implementations of to_date/to_timestamp

[ https://issues.apache.org/jira/browse/CALCITE-6449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6449: -- Assignee: Norman Jordan > Enable PostgreSQL implementations of to_date/to_timestamp

[jira] [Created] (CALCITE-6449) Enable PostgreSQL implementations of to_date/to_timestamp

Norman Jordan created CALCITE-6449: -- Summary: Enable PostgreSQL implementations of to_date/to_timestamp Key: CALCITE-6449 URL: https://issues.apache.org/jira/browse/CALCITE-6449 Project: Calcite

[jira] [Commented] (CALCITE-6444) Add a function library for Amazon Redshift

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860028#comment-17860028 ] Norman Jordan commented on CALCITE-6444: [~julianhyde] I have updated the PR to

[jira] [Commented] (CALCITE-6444) Add an Amazon Redshift SqlLibrary

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17859734#comment-17859734 ] Norman Jordan commented on CALCITE-6444: I see what you are saying. Something l

[jira] [Comment Edited] (CALCITE-6444) Add an Amazon Redshift SqlLibrary

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856881#comment-17856881 ] Norman Jordan edited comment on CALCITE-6444 at 6/21/24 10:58 PM: ---

[jira] [Commented] (CALCITE-6444) Add an Amazon Redshift SqlLibrary

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856882#comment-17856882 ] Norman Jordan commented on CALCITE-6444: For the PR, I went through the Amazon

[jira] [Commented] (CALCITE-6444) Add an Amazon Redshift SqlLibrary

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856881#comment-17856881 ] Norman Jordan commented on CALCITE-6444: Weird that this didn't link the PR. [

[jira] [Updated] (CALCITE-6444) Add an Amazon Redshift SqlLibrary

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6444: --- Summary: Add an Amazon Redshift SqlLibrary (was: Add a Redshift SqlLibrary) > Add an Am

[jira] [Updated] (CALCITE-6444) Add a Redshift SqlLibrary

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6444: --- Summary: Add a Redshift SqlLibrary (was: Add a RedShift SqlLibrary) > Add a Redshift SqlLi

[jira] [Created] (CALCITE-6444) Add a RedShift SqlLibrary

Norman Jordan created CALCITE-6444: -- Summary: Add a RedShift SqlLibrary Key: CALCITE-6444 URL: https://issues.apache.org/jira/browse/CALCITE-6444 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856867#comment-17856867 ] Norman Jordan commented on CALCITE-5634: I think so. The old one only added the

[jira] [Commented] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856863#comment-17856863 ] Norman Jordan commented on CALCITE-5634: I have created a new PR for this ticke

[jira] [Assigned] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-5634: -- Assignee: Norman Jordan > Enable GREATEST, LEAST functions in PostgreSQL library > -

[jira] [Commented] (CALCITE-6369) Expanding "star" gives ArrayIndexOutOfBoundsException with redundant columns and USING

[ https://issues.apache.org/jira/browse/CALCITE-6369?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17849406#comment-17849406 ] Norman Jordan commented on CALCITE-6369: The problem is from the offset that is

[jira] [Assigned] (CALCITE-6369) Expanding "star" gives ArrayIndexOutOfBoundsException with redundant columns and USING

[ https://issues.apache.org/jira/browse/CALCITE-6369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6369: -- Assignee: Norman Jordan > Expanding "star" gives ArrayIndexOutOfBoundsException with

[jira] [Commented] (CALCITE-6370) AS operator problems with USING clause

[ https://issues.apache.org/jira/browse/CALCITE-6370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17849059#comment-17849059 ] Norman Jordan commented on CALCITE-6370: The project field *product_id* is conv

[jira] [Assigned] (CALCITE-6370) AS operator problems with USING clause

[ https://issues.apache.org/jira/browse/CALCITE-6370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6370: -- Assignee: Norman Jordan > AS operator problems with USING clause > -

[jira] [Commented] (CALCITE-6370) AS operator problems with USING clause

[ https://issues.apache.org/jira/browse/CALCITE-6370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17848766#comment-17848766 ] Norman Jordan commented on CALCITE-6370: I was able to reproduce this issue by

[jira] [Comment Edited] (CALCITE-6370) AS operator problems with USING clause

[ https://issues.apache.org/jira/browse/CALCITE-6370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17848766#comment-17848766 ] Norman Jordan edited comment on CALCITE-6370 at 5/22/24 10:16 PM: ---

[jira] [Commented] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17848707#comment-17848707 ] Norman Jordan commented on CALCITE-5634: The PR linked above only makes the *GR

[jira] [Commented] (CALCITE-6312) Support PostgreSQL LOG

[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17848678#comment-17848678 ] Norman Jordan commented on CALCITE-6312: [~caicancai] Did you open the PR that

[jira] [Commented] (CALCITE-6311) Support PostgreSQL DATE_PART

[ https://issues.apache.org/jira/browse/CALCITE-6311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17847444#comment-17847444 ] Norman Jordan commented on CALCITE-6311: The current implementation gets TimeUn

[jira] [Commented] (CALCITE-6311) Support PostgreSQL DATE_PART

[ https://issues.apache.org/jira/browse/CALCITE-6311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17847062#comment-17847062 ] Norman Jordan commented on CALCITE-6311: Another twist with PostgreSQL. The fir

[jira] [Commented] (CALCITE-6311) Support PostgreSQL DATE_PART

[ https://issues.apache.org/jira/browse/CALCITE-6311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17846738#comment-17846738 ] Norman Jordan commented on CALCITE-6311: Looking into this, it appears that Red

[jira] [Assigned] (CALCITE-6311) Support PostgreSQL DATE_PART

[ https://issues.apache.org/jira/browse/CALCITE-6311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6311: -- Assignee: Norman Jordan > Support PostgreSQL DATE_PART > ---

[jira] [Commented] (CALCITE-6392) Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp

[ https://issues.apache.org/jira/browse/CALCITE-6392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844791#comment-17844791 ] Norman Jordan commented on CALCITE-6392: I have some code for this that could b

[jira] [Created] (CALCITE-6392) Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp

Norman Jordan created CALCITE-6392: -- Summary: Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp Key: CALCITE-6392 URL: https://issues.apache.org/jira/browse/CALCITE-6392 Project:

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

[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6358: --- Summary: Support all PostgreSQL 14 date/time patterns for to_char (was: Support all Postgr

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

[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-6358: -- Assignee: Norman Jordan > Support all PostgreSQL 14 date/time patterns > ---

[jira] [Updated] (CALCITE-6313) Add POWER function for PostgreSQL

[ 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 function for PostgreSQL (was: Add POWER (enabled in Postgres library))

[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&focusedCommentId=17836373#comment-17836373 ] Norman Jordan commented on CALCITE-6313: [~tanclary] There is already a POWER f

[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 POWE

[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&focusedCommentId=17836270#comment-17836270 ] Norman Jordan commented on CALCITE-6358: [~julianhyde] The request on my side i

[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&focusedCommentId=17836258#comment-17836258 ] Norman Jordan commented on CALCITE-6358: [~julianhyde] {*}TO_CHAR(){*}, {*}TO_D

[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&focusedCommentId=17835912#comment-17835912 ] Norman Jordan commented on CALCITE-6358: https://www.postgresql.org/docs/14/fun

  1   2   >