[jira] [Commented] (CALCITE-2359) Inconsistent behavior when casting interval literals to integer

[ https://issues.apache.org/jira/browse/CALCITE-2359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16509945#comment-16509945 ] James Duong commented on CALCITE-2359: -- Pull request: https://github.com/apache/calcite/pull/730

[jira] [Commented] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16511707#comment-16511707 ] James Duong commented on CALCITE-2339: -- * missing MINUTE from the switch * >>> done * I don't

[jira] [Commented] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16513602#comment-16513602 ] James Duong commented on CALCITE-2339: -- PR has been updated. I looked into using CAST, but did

[jira] [Commented] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16495824#comment-16495824 ] James Duong commented on CALCITE-2339: -- Note that it's possible to represent multi-field intervals

[jira] [Commented] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16495869#comment-16495869 ] James Duong commented on CALCITE-2339: -- The other downside I see: If someone used

[jira] [Comment Edited] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16495869#comment-16495869 ] James Duong edited comment on CALCITE-2339 at 5/30/18 11:17 PM: The

[jira] [Commented] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16495902#comment-16495902 ] James Duong commented on CALCITE-2339: -- Tableau does make use of non-interval units such as WEEK

[jira] [Commented] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16501595#comment-16501595 ] James Duong commented on CALCITE-2339: -- I've put up a PR for what I'm thinking should happen:

[jira] [Comment Edited] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16501595#comment-16501595 ] James Duong edited comment on CALCITE-2339 at 6/5/18 4:09 PM: -- I've put up

[jira] [Comment Edited] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16521547#comment-16521547 ] James Duong edited comment on CALCITE-2339 at 6/24/18 4:49 PM: --- Checking

[jira] [Created] (CALCITE-2299) TIMESTAMPADD(SQL_TSI_FRAC_SECOND) should be nanoseconds not microseconds

James Duong created CALCITE-2299: Summary: TIMESTAMPADD(SQL_TSI_FRAC_SECOND) should be nanoseconds not microseconds Key: CALCITE-2299 URL: https://issues.apache.org/jira/browse/CALCITE-2299 Project:

[jira] [Created] (CALCITE-2399) Allow SqlImplementor classes to be extended

James Duong created CALCITE-2399: Summary: Allow SqlImplementor classes to be extended Key: CALCITE-2399 URL: https://issues.apache.org/jira/browse/CALCITE-2399 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-2399) Allow SqlImplementor classes to be extended

[ https://issues.apache.org/jira/browse/CALCITE-2399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16532081#comment-16532081 ] James Duong commented on CALCITE-2399: -- PR: https://github.com/apache/calcite/pull/751 > Allow

[jira] [Updated] (CALCITE-2397) Column Index not getting set on correlationIds

[ https://issues.apache.org/jira/browse/CALCITE-2397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-2397: - Description: During SqlToRel conversion, the column index bitset is not getting set on

[jira] [Commented] (CALCITE-2396) TIMESTAMPADD and DATETIME_PLUS should allow NULL intervals

[ https://issues.apache.org/jira/browse/CALCITE-2396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16532041#comment-16532041 ] James Duong commented on CALCITE-2396: -- Some time units currently allow this but not all.   PR

[jira] [Commented] (CALCITE-2397) Column Index not getting set on correlationIds

[ https://issues.apache.org/jira/browse/CALCITE-2397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16532069#comment-16532069 ] James Duong commented on CALCITE-2397: -- PR: https://github.com/apache/calcite/pull/749 > Column

[jira] [Created] (CALCITE-2398) SqlSelect does not use SqlDialect when unparsing

James Duong created CALCITE-2398: Summary: SqlSelect does not use SqlDialect when unparsing Key: CALCITE-2398 URL: https://issues.apache.org/jira/browse/CALCITE-2398 Project: Calcite Issue

[jira] [Created] (CALCITE-2396) TIMESTAMPADD and DATETIME_PLUS should allow NULL intervals

James Duong created CALCITE-2396: Summary: TIMESTAMPADD and DATETIME_PLUS should allow NULL intervals Key: CALCITE-2396 URL: https://issues.apache.org/jira/browse/CALCITE-2396 Project: Calcite

[jira] [Created] (CALCITE-2397) Column Index not getting set on correlationIds

James Duong created CALCITE-2397: Summary: Column Index not getting set on correlationIds Key: CALCITE-2397 URL: https://issues.apache.org/jira/browse/CALCITE-2397 Project: Calcite Issue

[jira] [Created] (CALCITE-2603) Error double literal with exponential when unparsing with RelToSqlConverter

James Duong created CALCITE-2603: Summary: Error double literal with exponential when unparsing with RelToSqlConverter Key: CALCITE-2603 URL: https://issues.apache.org/jira/browse/CALCITE-2603

[jira] [Created] (CALCITE-2614) Converting datetime_plus to timestampadd should be done recursively

James Duong created CALCITE-2614: Summary: Converting datetime_plus to timestampadd should be done recursively Key: CALCITE-2614 URL: https://issues.apache.org/jira/browse/CALCITE-2614 Project:

[jira] [Commented] (CALCITE-2614) Converting datetime_plus to timestampadd should be done recursively

[ https://issues.apache.org/jira/browse/CALCITE-2614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16644242#comment-16644242 ] James Duong commented on CALCITE-2614: -- I'm open to moving this into RexSimplify.   Adding

[jira] [Commented] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16761955#comment-16761955 ] James Duong commented on CALCITE-2339: -- Thanks Julian. I'll work on updating the PR for this to

[jira] [Commented] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16763767#comment-16763767 ] James Duong commented on CALCITE-2339: -- The build for this PR now fails after merging from master

[jira] [Commented] (CALCITE-2339) JDBC adapter should transform timestamp arithmetic for target database

[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16764016#comment-16764016 ] James Duong commented on CALCITE-2339: -- Thanks! I've rebased on top of the fix for CALCITE-2836.

[jira] [Commented] (CALCITE-6262) CURRENT_TIMESTAMP(P) ignores DataTypeSystem#getMaxPrecision

[ https://issues.apache.org/jira/browse/CALCITE-6262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17818971#comment-17818971 ] James Duong commented on CALCITE-6262: -- I'm picking up this issue now [~tanclary] . >

[jira] [Commented] (CALCITE-5647) RelMdPopulationSize calls rel.estimateRowCount instead of mq.getRowCount

[ https://issues.apache.org/jira/browse/CALCITE-5647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813843#comment-17813843 ] James Duong commented on CALCITE-5647: -- [~rlopez] it seems I cannot edit the title of the JIRA. >

[jira] [Commented] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17835544#comment-17835544 ] James Duong commented on CALCITE-6327: -- This appears to have been fixed as part of CALCITE-6015.

[jira] [Commented] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17835545#comment-17835545 ] James Duong commented on CALCITE-6327: -- Re-assigning to [~mbudiu] since this looks to have been

[jira] [Assigned] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong reassigned CALCITE-6327: Assignee: Mihai Budiu (was: James Duong) > getValidatedNodeTypeIfKnown should never

[jira] [Assigned] (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 ] James Duong reassigned CALCITE-6340: Assignee: James Duong > RelBuilder always creates Project with Convention.NONE during

[jira] [Commented] (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:comment-tabpanel=17835559#comment-17835559 ] James Duong commented on CALCITE-6340: -- The change looks to be calling project.getTraitSet()

[jira] [Assigned] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong reassigned CALCITE-6327: Assignee: James Duong > getValidatedNodeTypeIfKnown should never throw >

[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=17836374#comment-17836374 ] James Duong commented on CALCITE-6313: -- You can have multiple SqlOperator objects that map to the

[jira] [Resolved] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong resolved CALCITE-6327. -- Resolution: Fixed This was fixed in CALCITE-6015 > getValidatedNodeTypeIfKnown should never

[jira] [Updated] (CALCITE-6340) RelBuilder drops set conventions when aggregating over duplicate projected fields

[ https://issues.apache.org/jira/browse/CALCITE-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6340: - Summary: RelBuilder drops set conventions when aggregating over duplicate projected fields

[jira] [Updated] (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 ] James Duong updated CALCITE-6369: - Summary: Expanding "star" gives ArrayIndexOutOfBoundsException with redundant columns and

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

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

[jira] [Comment Edited] (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=17842179#comment-17842179 ] James Duong edited comment on CALCITE-6369 at 4/29/24 10:41 PM: I've

[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=17842179#comment-17842179 ] James Duong commented on CALCITE-6369: -- I've reproduced this problem. It's not clear why there's

[jira] [Comment Edited] (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=17842179#comment-17842179 ] James Duong edited comment on CALCITE-6369 at 4/30/24 5:43 PM: --- I've

[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=17842461#comment-17842461 ] James Duong commented on CALCITE-6369: -- I managed to get this working right with the emp table

[jira] [Updated] (CALCITE-6340) RelBuilder drops traits when aggregating over duplicate projected fields

[ https://issues.apache.org/jira/browse/CALCITE-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6340: - Summary: RelBuilder drops traits when aggregating over duplicate projected fields (was:

[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 ] James Duong reassigned CALCITE-6369: Assignee: (was: James Duong) > Expanding "star" gives

[jira] [Assigned] (CALCITE-6368) Inconsistent handling of COALESCE during validation

[ https://issues.apache.org/jira/browse/CALCITE-6368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong reassigned CALCITE-6368: Assignee: James Duong > Inconsistent handling of COALESCE during validation >

[jira] [Commented] (CALCITE-6368) Inconsistent handling of COALESCE during validation

[ https://issues.apache.org/jira/browse/CALCITE-6368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17846371#comment-17846371 ] James Duong commented on CALCITE-6368: -- [~cbrisson] , I tried this with 1.36 and 1.37 and got the

[jira] [Commented] (CALCITE-6368) Inconsistent handling of COALESCE during validation

[ https://issues.apache.org/jira/browse/CALCITE-6368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17846076#comment-17846076 ] James Duong commented on CALCITE-6368: -- [~cbrisson] , I tried the query above in SqlValidatorTest

[jira] [Created] (CALCITE-6391) Apply mapping to RelCompositeTrait does not apply it to wrapped traits

James Duong created CALCITE-6391: Summary: Apply mapping to RelCompositeTrait does not apply it to wrapped traits Key: CALCITE-6391 URL: https://issues.apache.org/jira/browse/CALCITE-6391 Project:

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

James Duong created CALCITE-6308: Summary: Add PostgreSQL functions up to PostgreSQL v14 Key: CALCITE-6308 URL: https://issues.apache.org/jira/browse/CALCITE-6308 Project: Calcite Issue

[jira] [Created] (CALCITE-6313) Support PostgreSQL POW

James Duong created CALCITE-6313: Summary: Support PostgreSQL POW Key: CALCITE-6313 URL: https://issues.apache.org/jira/browse/CALCITE-6313 Project: Calcite Issue Type: Sub-task

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

James Duong created CALCITE-6311: Summary: Support PostgreSQL DATE_PART Key: CALCITE-6311 URL: https://issues.apache.org/jira/browse/CALCITE-6311 Project: Calcite Issue Type: Sub-task

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

James Duong created CALCITE-6312: Summary: Support PostgreSQL LOG Key: CALCITE-6312 URL: https://issues.apache.org/jira/browse/CALCITE-6312 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-6309) Support PostgreSQL REGEXP_LIKE

James Duong created CALCITE-6309: Summary: Support PostgreSQL REGEXP_LIKE Key: CALCITE-6309 URL: https://issues.apache.org/jira/browse/CALCITE-6309 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-6310) Support PostgreSQL REGEXP_REPLACE

James Duong created CALCITE-6310: Summary: Support PostgreSQL REGEXP_REPLACE Key: CALCITE-6310 URL: https://issues.apache.org/jira/browse/CALCITE-6310 Project: Calcite Issue Type: Sub-task

[jira] [Updated] (CALCITE-6309) Support PostgreSQL REGEXP_LIKE

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6309: - Description: * The Spark version of this is being implemented in CALCITE-6278 * The

[jira] [Created] (CALCITE-6314) Support PostgreSQL RANDOM

James Duong created CALCITE-6314: Summary: Support PostgreSQL RANDOM Key: CALCITE-6314 URL: https://issues.apache.org/jira/browse/CALCITE-6314 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

James Duong created CALCITE-6315: Summary: Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP Key: CALCITE-6315 URL: https://issues.apache.org/jira/browse/CALCITE-6315 Project: Calcite Issue

[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=17824590#comment-17824590 ] James Duong commented on CALCITE-6308: -- Thanks [~tanclary] . I've added you to the RANDOM PR:

[jira] [Updated] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6314: - Summary: Add RANDOM function (enabled in Postgres library) (was: Support PostgreSQL RANDOM)

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

[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825404#comment-17825404 ] James Duong commented on CALCITE-6312: -- [~caicancai] , it seems reasonable to make this work part

[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=17825411#comment-17825411 ] James Duong commented on CALCITE-6308: -- [~caicancai] , would it be possible to list the sub-issues

[jira] [Updated] (CALCITE-6309) Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries)

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6309: - Fix Version/s: 1.37.0 > Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and

[jira] [Updated] (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 ] James Duong updated CALCITE-6310: - Summary: Add REGEXP_REPLACE function (enabled in PostgreSQL library) (was: Add REGEXP_LIKE

[jira] [Comment Edited] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825850#comment-17825850 ] James Duong edited comment on CALCITE-6309 at 3/12/24 10:56 PM: Thanks.

[jira] [Commented] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825850#comment-17825850 ] James Duong commented on CALCITE-6309: -- Thanks. Yes we can do that. I have been investigating and

[jira] [Commented] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825857#comment-17825857 ] James Duong commented on CALCITE-6309: -- Sure, let's have all libraries support the common subset

[jira] [Commented] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827173#comment-17827173 ] James Duong commented on CALCITE-6314: -- I wonder if this is an issue with my account. This is an

[jira] [Comment Edited] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827197#comment-17827197 ] James Duong edited comment on CALCITE-6314 at 3/14/24 6:15 PM: --- I worked

[jira] [Assigned] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong reassigned CALCITE-6314: Assignee: James Duong (was: Tanner Clary) > Add RANDOM function (enabled in Postgres

[jira] [Commented] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827197#comment-17827197 ] James Duong commented on CALCITE-6314: -- I worked with ASF infra to get Contributor permissions to

[jira] [Updated] (CALCITE-6310) Add REGEXP_LIKE function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6310: - Summary: Add REGEXP_LIKE function (enabled in PostgreSQL library) (was: Support PostgreSQL

[jira] [Assigned] (CALCITE-6310) Support PostgreSQL REGEXP_REPLACE

[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong reassigned CALCITE-6310: Assignee: James Duong > Support PostgreSQL REGEXP_REPLACE >

[jira] [Assigned] (CALCITE-6309) Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries)

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong reassigned CALCITE-6309: Assignee: James Duong > Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL

[jira] [Commented] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827757#comment-17827757 ] James Duong commented on CALCITE-6314: -- Yes, my Jira issues were because I was a committer on the

[jira] [Comment Edited] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828550#comment-17828550 ] James Duong edited comment on CALCITE-6327 at 3/20/24 12:28 AM: Note

[jira] [Commented] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828550#comment-17828550 ] James Duong commented on CALCITE-6327: -- To reproduce it (and build a test case), the easiest way

[jira] [Updated] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6309: - Summary: Add REGEXP_LIKE function (enabled in Postgres library) (was: Support PostgreSQL

[jira] [Updated] (CALCITE-6309) Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries)

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6309: - Summary: Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries)

[jira] [Comment Edited] (CALCITE-6309) Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries)

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825850#comment-17825850 ] James Duong edited comment on CALCITE-6309 at 3/13/24 10:27 PM: Thanks.

[jira] [Comment Edited] (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=17848753#comment-17848753 ] James Duong edited comment on CALCITE-6310 at 5/22/24 10:17 PM: The

[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=17848753#comment-17848753 ] James Duong commented on CALCITE-6310: -- The current implementation of REGEXP_REPLACE allows

[jira] [Commented] (CALCITE-3094) Code of method grows beyond 64 KB when joining two tables with many fields

[ https://issues.apache.org/jira/browse/CALCITE-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17852600#comment-17852600 ] James Duong commented on CALCITE-3094: -- This is affecting us as well. There have been a few