[jira] [Created] (CALCITE-5410) Assertion error on PERCENT_REMAINDER operator with DECIMAL type

Aleksey Plekhanov created CALCITE-5410: -- Summary: Assertion error on PERCENT_REMAINDER operator with DECIMAL type Key: CALCITE-5410 URL: https://issues.apache.org/jira/browse/CALCITE-5410 Project

[jira] [Commented] (CALCITE-5404) Implement BigQuery's POW() and TRUNC() math functions

[ https://issues.apache.org/jira/browse/CALCITE-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641715#comment-17641715 ] Julian Hyde commented on CALCITE-5404: -- [~tanclary], In [814ae6ec|https://github.

[jira] [Resolved] (CALCITE-5385) Add BigQuery as supported library for implemented functions

[ https://issues.apache.org/jira/browse/CALCITE-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5385. -- Fix Version/s: 1.33.0 Resolution: Fixed Fixed in  [326b993f|https://github.com/apache/

[jira] [Commented] (CALCITE-5385) Add BigQuery as supported library for implemented functions

[ https://issues.apache.org/jira/browse/CALCITE-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641612#comment-17641612 ] Tanner Clary commented on CALCITE-5385: --- [~julianhyde] Looks great! That is compl

[jira] [Updated] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhengqiang Duan updated CALCITE-5406: - Description: Hi, community, I am currently using Calcite to help ShardingSphere impleme

[jira] [Updated] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhengqiang Duan updated CALCITE-5406: - Description: Hi, community, I am currently using Calcite to help ShardingSphere impleme

[jira] [Updated] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhengqiang Duan updated CALCITE-5406: - Description: Hi, community, I am currently using Calcite to help ShardingSphere impleme

[jira] [Commented] (CALCITE-5404) Implement BigQuery's POW() and TRUNC() math functions

[ https://issues.apache.org/jira/browse/CALCITE-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641601#comment-17641601 ] Julian Hyde commented on CALCITE-5404: -- In reference.md, I think better descriptio

[jira] [Updated] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhengqiang Duan updated CALCITE-5406: - Issue Type: New Feature (was: Bug) > Support the SELECT DISTINCT ON statement for Post

[jira] [Commented] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641600#comment-17641600 ] Zhengqiang Duan commented on CALCITE-5406: -- Thanks for your suggestion [~julia

[jira] [Comment Edited] (CALCITE-5385) Add BigQuery as supported library for implemented functions

[ https://issues.apache.org/jira/browse/CALCITE-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641595#comment-17641595 ] Julian Hyde edited comment on CALCITE-5385 at 12/1/22 12:30 AM: -

[jira] [Commented] (CALCITE-5385) Add BigQuery as supported library for implemented functions

[ https://issues.apache.org/jira/browse/CALCITE-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641595#comment-17641595 ] Julian Hyde commented on CALCITE-5385: -- [~tanclary], No, your work is great. I hav

[jira] [Updated] (CALCITE-4512) GROUP BY expression with argument name same with SELECT field and alias causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-4512: - Description: {code:java} String sql = "select replace(name, 'a', 'b') as name from users group

[jira] [Commented] (CALCITE-5385) Add BigQuery as supported library for implemented functions

[ https://issues.apache.org/jira/browse/CALCITE-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641573#comment-17641573 ] Tanner Clary commented on CALCITE-5385: --- [~julianhyde] I just saw this but in the

[jira] [Updated] (CALCITE-5404) Implement BigQuery's POW() and TRUNC() math functions

[ https://issues.apache.org/jira/browse/CALCITE-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5404: Labels: pull-request-available (was: ) > Implement BigQuery's POW() and TRUNC() math fun

[jira] [Commented] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641466#comment-17641466 ] Julian Hyde commented on CALCITE-5406: -- I agree with how [~asolimando] is handling

[jira] [Updated] (CALCITE-5159) ARRAY string constructor, and implicit cast from string literal (enabled in PostgreSQL conformance)

[ https://issues.apache.org/jira/browse/CALCITE-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5159: - Summary: ARRAY string constructor, and implicit cast from string literal (enabled in PostgreSQL

[jira] [Resolved] (CALCITE-5159) Postgres dialect should support implicit cast from string literal to array literal

[ https://issues.apache.org/jira/browse/CALCITE-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5159. -- Fix Version/s: 1.33.0 Resolution: Fixed Fixed in [c89bd13c|https://github.com/apache/

[jira] [Commented] (CALCITE-5399) Proj4J license is not compatible with Apache

[ https://issues.apache.org/jira/browse/CALCITE-5399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641444#comment-17641444 ] Julian Hyde commented on CALCITE-5399: -- Looks good, +1 > Proj4J license is not co

[jira] [Commented] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641428#comment-17641428 ] Ruben Q L commented on CALCITE-5409: Thanks for the clarification. > Jdbc doesn't

[jira] [Commented] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641423#comment-17641423 ] Stamatis Zampetakis commented on CALCITE-5409: -- In https://calcite.apache.

[jira] [Commented] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641336#comment-17641336 ] Ruben Q L commented on CALCITE-5409: [~zabetak], thanks for confirming that this is

[jira] [Updated] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-5409: - Fix Version/s: 1.33.0 > Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_N

[jira] [Resolved] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-5409. -- Resolution: Duplicate > Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH

[jira] [Comment Edited] (CALCITE-5399) Proj4J license is not compatible with Apache

[ https://issues.apache.org/jira/browse/CALCITE-5399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641330#comment-17641330 ] Bertil Chapuis edited comment on CALCITE-5399 at 11/30/22 2:07 PM: --

[jira] [Commented] (CALCITE-5399) Proj4J license is not compatible with Apache

[ https://issues.apache.org/jira/browse/CALCITE-5399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641330#comment-17641330 ] Bertil Chapuis commented on CALCITE-5399: - [~julianhyde] I reordered the depend

[jira] [Commented] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641329#comment-17641329 ] Ruben Q L commented on CALCITE-5409: Maybe related to (or duplicate of?) CALCITE-41

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641319#comment-17641319 ] Ulrich Kramer commented on CALCITE-5354: I opened a new one: https://issues.ap

[jira] [Created] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

Ulrich Kramer created CALCITE-5409: -- Summary: Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE Key: CALCITE-5409 URL: https://issues.apache.org/jira/browse/CALCITE-5409 Pro

[jira] [Assigned] (CALCITE-5408) Return type of PERCENTILE_CONT should be the same as sort expression

[ https://issues.apache.org/jira/browse/CALCITE-5408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zou reassigned CALCITE-5408: Assignee: Zou > Return type of PERCENTILE_CONT should be the same as sort expression > -

[jira] [Commented] (CALCITE-5408) Return type of PERCENTILE_CONT should be the same as sort expression

[ https://issues.apache.org/jira/browse/CALCITE-5408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641314#comment-17641314 ] Zou commented on CALCITE-5408: -- I would like to take it > Return type of PERCENTILE_CONT

[jira] [Created] (CALCITE-5408) Return type of PERCENTILE_CONT should be the same as sort expression

Benchao Li created CALCITE-5408: --- Summary: Return type of PERCENTILE_CONT should be the same as sort expression Key: CALCITE-5408 URL: https://issues.apache.org/jira/browse/CALCITE-5408 Project: Calcite

[jira] [Resolved] (CALCITE-5230) Return type of PERCENTILE_DISC should be the same as sort expression

[ https://issues.apache.org/jira/browse/CALCITE-5230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-5230. - Resolution: Fixed Fixed via [https://github.com/apache/calcite/commit/9161a6f529775076eece3cb7

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641304#comment-17641304 ] Jiajun Xie commented on CALCITE-5354: - Hi [~kramerul], The issue is about {*}UNNES

[jira] [Updated] (CALCITE-5230) Return type of PERCENTILE_DISC should be the same as sort expression

[ https://issues.apache.org/jira/browse/CALCITE-5230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5230: Summary: Return type of PERCENTILE_DISC should be the same as sort expression (was: PERCENTILE_D

[jira] [Commented] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641212#comment-17641212 ] Zhengqiang Duan commented on CALCITE-5406: -- Thank you [~asolimando], this info

[jira] [Comment Edited] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641209#comment-17641209 ] Alessandro Solimando edited comment on CALCITE-5406 at 11/30/22 10:11 AM: ---

[jira] [Updated] (CALCITE-5285) CalcReduceExpressionsRule may transform to same rel

[ https://issues.apache.org/jira/browse/CALCITE-5285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-5285: - Fix Version/s: (was: 1.33.0) > CalcReduceExpressionsRule may transform to s

[jira] [Commented] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641209#comment-17641209 ] Alessandro Solimando commented on CALCITE-5406: --- Quoting from [https://ww

[jira] [Commented] (CALCITE-5285) CalcReduceExpressionsRule may transform to same rel

[ https://issues.apache.org/jira/browse/CALCITE-5285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641210#comment-17641210 ] Stamatis Zampetakis commented on CALCITE-5285: -- It seems that no one is wo

[jira] [Updated] (CALCITE-5406) Support the SELECT DISTINCT ON statement for PostgreSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhengqiang Duan updated CALCITE-5406: - Summary: Support the SELECT DISTINCT ON statement for PostgreSQL dialect (was: Calcite

[jira] [Commented] (CALCITE-5406) Calcite parse doesn't support PostgreSQL `select distinct on (user_id) * from t_order` statement

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641200#comment-17641200 ] Zhengqiang Duan commented on CALCITE-5406: -- Yes, you are right, we need to sup

[jira] [Commented] (CALCITE-5406) Calcite parse doesn't support PostgreSQL `select distinct on (user_id) * from t_order` statement

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641198#comment-17641198 ] Alessandro Solimando commented on CALCITE-5406: --- [~duanzhengqiang], thank

[jira] [Commented] (CALCITE-5399) Proj4J license is not compatible with Apache

[ https://issues.apache.org/jira/browse/CALCITE-5399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641165#comment-17641165 ] Martin Desruisseaux commented on CALCITE-5399: -- Yes, if EPSG data are remo

[jira] [Created] (CALCITE-5407) MongoDB: Invalid ARRAY conversion

Tim Nieradzik created CALCITE-5407: -- Summary: MongoDB: Invalid ARRAY conversion Key: CALCITE-5407 URL: https://issues.apache.org/jira/browse/CALCITE-5407 Project: Calcite Issue Type: Bug

[jira] [Assigned] (CALCITE-5406) Calcite parse doesn't support PostgreSQL `select distinct on (user_id) * from t_order` statement

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhengqiang Duan reassigned CALCITE-5406: Assignee: Zhengqiang Duan > Calcite parse doesn't support PostgreSQL `select dis

[jira] [Created] (CALCITE-5406) Calcite parse doesn't support PostgreSQL `select distinct on (user_id) * from t_order` statement

Zhengqiang Duan created CALCITE-5406: Summary: Calcite parse doesn't support PostgreSQL `select distinct on (user_id) * from t_order` statement Key: CALCITE-5406 URL: https://issues.apache.org/jira/browse/CALC

[jira] [Commented] (CALCITE-5406) Calcite parse doesn't support PostgreSQL `select distinct on (user_id) * from t_order` statement

[ https://issues.apache.org/jira/browse/CALCITE-5406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641138#comment-17641138 ] Zhengqiang Duan commented on CALCITE-5406: -- I will try to investigate and fix