[jira] [Assigned] (CALCITE-985) Validate MERGE

[ https://issues.apache.org/jira/browse/CALCITE-985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-985: -- Assignee: Jiajun Xie > Validate MERGE > -- > > Key: CALCITE-985

[jira] [Commented] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738341#comment-17738341 ] Jiajun Xie commented on CALCITE-5805: - Thanks for your information. It seems that I need to add

[jira] [Commented] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738078#comment-17738078 ] Jiajun Xie commented on CALCITE-5805: - `select * from emp where deptno is null` is a SqlNode that

[jira] [Updated] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5805: Description: For the unit test. {code:java} final String sql = "merge into empnullables e "

[jira] [Updated] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5805: Description: For the unit test. {code:java} final String sql = "merge into empnullables e "

[jira] [Updated] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5805: Summary: SqlValidatorImpl throws AssertionError while validating MERGE statement (was:

[jira] [Created] (CALCITE-5805) SelectNamespace throws NullPointerException while validating MERGE statement

Jiajun Xie created CALCITE-5805: --- Summary: SelectNamespace throws NullPointerException while validating MERGE statement Key: CALCITE-5805 URL: https://issues.apache.org/jira/browse/CALCITE-5805

[jira] [Commented] (CALCITE-5796) DELETE statement is not effective

[ https://issues.apache.org/jira/browse/CALCITE-5796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736693#comment-17736693 ] Jiajun Xie commented on CALCITE-5796: - When we execute `JdbcFrontLinqBackTest#testDelete`(Effective

[jira] [Assigned] (CALCITE-5796) DELETE statement is not effective

[ https://issues.apache.org/jira/browse/CALCITE-5796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5796: --- Assignee: Jiajun Xie > DELETE statement is not effective >

[jira] [Updated] (CALCITE-5796) DELETE statement is not effective

[ https://issues.apache.org/jira/browse/CALCITE-5796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5796: Environment: (was: I try to use `DELETE FROM t`, but the table was not affected.  

[jira] [Updated] (CALCITE-5796) DELETE statement is not effective

[ https://issues.apache.org/jira/browse/CALCITE-5796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5796: Description: I try to use `DELETE FROM t`, but the table was not affected.   {code:java} static

[jira] [Created] (CALCITE-5796) DELETE statement is not effective

Jiajun Xie created CALCITE-5796: --- Summary: DELETE statement is not effective Key: CALCITE-5796 URL: https://issues.apache.org/jira/browse/CALCITE-5796 Project: Calcite Issue Type: Bug

[jira] [Comment Edited] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735957#comment-17735957 ] Jiajun Xie edited comment on CALCITE-5688 at 6/22/23 3:06 AM: -- I

[jira] [Updated] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5688: Description: Calcite should support parse truncate syntax like SQL2011 {code:java} ::=  

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735957#comment-17735957 ] Jiajun Xie commented on CALCITE-5688: - I implement it in the server module and change the Jira

[jira] [Updated] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5688: Component/s: server (was: babel) (was: core) > Support

[jira] [Updated] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5688: Issue Type: Improvement (was: Task) Summary: Support TRUNCATE TABLE DDL statement in

[jira] [Resolved] (CALCITE-5751) Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5751. - Resolution: Fixed > Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark

[jira] [Commented] (CALCITE-5751) Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735712#comment-17735712 ] Jiajun Xie commented on CALCITE-5751: - Fixed in

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733889#comment-17733889 ] Jiajun Xie commented on CALCITE-5688: - A new SqlKind usually to be validated, so I need to write

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733850#comment-17733850 ] Jiajun Xie commented on CALCITE-5688: - Because  [~VAE]'s comment. I'm thinking if I should change

[jira] [Comment Edited] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733850#comment-17733850 ] Jiajun Xie edited comment on CALCITE-5688 at 6/18/23 5:08 AM: -- Because 

[jira] [Comment Edited] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733838#comment-17733838 ] Jiajun Xie edited comment on CALCITE-5688 at 6/18/23 2:44 AM: -- hi

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733838#comment-17733838 ] Jiajun Xie commented on CALCITE-5688: - hi [~sumeet.gajjar] : I implemented SQL2011 syntax in Babel

[jira] [Commented] (CALCITE-5779) Implicit column alias for single-column table function should work

[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733686#comment-17733686 ] Jiajun Xie commented on CALCITE-5779: - This seems to be a common bug. Does anyone know how Flink

[jira] [Commented] (CALCITE-5760) SqlOperatorTest::testDateTrunc does not validate results

[ https://issues.apache.org/jira/browse/CALCITE-5760?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17731130#comment-17731130 ] Jiajun Xie commented on CALCITE-5760: - We can execute by using `Fixtures.forOperators(true)`. Here

[jira] [Resolved] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5704. - Resolution: Fixed > Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect >

[jira] [Commented] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17730354#comment-17730354 ] Jiajun Xie commented on CALCITE-5704: - Fixed in

[jira] [Resolved] (CALCITE-5710) Add ARRAY_MAX and ARRAY_MIN for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5710. - Resolution: Fixed > Add ARRAY_MAX and ARRAY_MIN for Spark dialect >

[jira] [Commented] (CALCITE-5710) Add ARRAY_MAX and ARRAY_MIN for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17729132#comment-17729132 ] Jiajun Xie commented on CALCITE-5710: - Fixed in

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17729035#comment-17729035 ] Jiajun Xie commented on CALCITE-5688: - [~sumeet.gajjar] Don't apologize, the community welcomes

[jira] [Commented] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728899#comment-17728899 ] Jiajun Xie commented on CALCITE-5739: - [~jackylau] , Can you try to do similar functions in one PR?

[jira] [Resolved] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5714. - Resolution: Fixed > Add MAP_ENTRIES for Spark dialect > - > >

[jira] [Commented] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728737#comment-17728737 ] Jiajun Xie commented on CALCITE-5714: - Fixed in

[jira] [Resolved] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5723. - Resolution: Fixed > Oracle dialect generates SQL that cannot be recognized by lower version >

[jira] [Commented] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728527#comment-17728527 ] Jiajun Xie commented on CALCITE-5723: - Fixed in

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727752#comment-17727752 ] Jiajun Xie commented on CALCITE-5506: - [~julianhyde] , Thank you. > RelToSqlConverter should

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726877#comment-17726877 ] Jiajun Xie commented on CALCITE-5506: - [~julianhyde]  Do you have time to submit your branch? I am

[jira] [Comment Edited] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726870#comment-17726870 ] Jiajun Xie edited comment on CALCITE-5723 at 5/28/23 1:42 AM: -- Thank you

[jira] [Commented] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726870#comment-17726870 ] Jiajun Xie commented on CALCITE-5723: - Thank you for your explanation.   The PR looks good and

[jira] [Comment Edited] (CALCITE-5725) Support Doris Dialect

[ https://issues.apache.org/jira/browse/CALCITE-5725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726869#comment-17726869 ] Jiajun Xie edited comment on CALCITE-5725 at 5/28/23 1:38 AM: -- 1. It's

[jira] [Commented] (CALCITE-5725) Support Doris Dialect

[ https://issues.apache.org/jira/browse/CALCITE-5725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726869#comment-17726869 ] Jiajun Xie commented on CALCITE-5725: - 1. It's worth mentioning that BabelParser can welcome

[jira] [Commented] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726867#comment-17726867 ] Jiajun Xie commented on CALCITE-5724: - Agree with Hyde. Here is

[jira] [Comment Edited] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726789#comment-17726789 ] Jiajun Xie edited comment on CALCITE-5723 at 5/27/23 10:01 AM: --- Does

[jira] [Commented] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726789#comment-17726789 ] Jiajun Xie commented on CALCITE-5723: - Does oracle(<12) support other similar syntax? > Oracle

[jira] [Resolved] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5695. - Resolution: Fixed > Add MAP_KEYS and MAP_VALUES for Spark dialect >

[jira] [Comment Edited] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17724580#comment-17724580 ] Jiajun Xie edited comment on CALCITE-5695 at 5/21/23 2:32 AM: -- Fixed in

[jira] [Commented] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17724580#comment-17724580 ] Jiajun Xie commented on CALCITE-5695: - Fixed in

[jira] [Commented] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17724477#comment-17724477 ] Jiajun Xie commented on CALCITE-5695: - If there are no other suggestions, I will merge this PR

[jira] [Commented] (CALCITE-5700) Add ARRAY_SIZE and ARRAY_REPEAT for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17723767#comment-17723767 ] Jiajun Xie commented on CALCITE-5700: - Sorry, I ignore it. I will pay attention to future commit

[jira] [Comment Edited] (CALCITE-5700) Add ARRAY_SIZE and ARRAY_REPEAT for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17723315#comment-17723315 ] Jiajun Xie edited comment on CALCITE-5700 at 5/17/23 2:01 AM: -- [~jackylau]

[jira] [Comment Edited] (CALCITE-5700) Add ARRAY_SIZE and ARRAY_REPEAT for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17723315#comment-17723315 ] Jiajun Xie edited comment on CALCITE-5700 at 5/17/23 2:01 AM: -- [~jackylau]

[jira] [Resolved] (CALCITE-5700) Add ARRAY_SIZE and ARRAY_REPEAT for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5700. - Resolution: Fixed > Add ARRAY_SIZE and ARRAY_REPEAT for Spark dialect >

[jira] [Commented] (CALCITE-5700) Add ARRAY_SIZE and ARRAY_REPEAT for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17723315#comment-17723315 ] Jiajun Xie commented on CALCITE-5700: - Fixed in

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17721584#comment-17721584 ] Jiajun Xie commented on CALCITE-5506: - It's a better improvement. Thank you, [~julianhyde] . >

[jira] [Comment Edited] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720282#comment-17720282 ] Jiajun Xie edited comment on CALCITE-5506 at 5/7/23 6:35 AM: - Ok, I find a

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720282#comment-17720282 ] Jiajun Xie commented on CALCITE-5506: - Ok, I find a simple case. * Before my patch. {code:java}

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720281#comment-17720281 ] Jiajun Xie commented on CALCITE-5688: - Besides the core parser, do you know the server parser? It

[jira] [Comment Edited] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720280#comment-17720280 ] Jiajun Xie edited comment on CALCITE-5688 at 5/7/23 6:08 AM: - >From your

[jira] [Comment Edited] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720280#comment-17720280 ] Jiajun Xie edited comment on CALCITE-5688 at 5/7/23 6:03 AM: - >From your

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720280#comment-17720280 ] Jiajun Xie commented on CALCITE-5688: - >From your PR, core parser support rather than babel parser.

[jira] [Comment Edited] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720280#comment-17720280 ] Jiajun Xie edited comment on CALCITE-5688 at 5/7/23 6:02 AM: - >From your

[jira] [Commented] (CALCITE-5547) JOIN USING returns incorrect column names

[ https://issues.apache.org/jira/browse/CALCITE-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17719286#comment-17719286 ] Jiajun Xie commented on CALCITE-5547: - It's not difficult to fix.   {code:java} select empno as

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17718786#comment-17718786 ] Jiajun Xie commented on CALCITE-5506: - [~libenchao] ，I used a more detailed description.   Will

[jira] [Updated] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5506: Summary: RelToSqlConverter should retain the aggregation logic when Project without RexInputRef

[jira] [Updated] (CALCITE-5547) JOIN USING returns incorrect column names

[ https://issues.apache.org/jira/browse/CALCITE-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5547: Description: The query    {code:java} SELECT '' as \"xxx\", * FROM (values (1, 4, 'one')) as

[jira] [Updated] (CALCITE-5547) JOIN USING returns incorrect column names

[ https://issues.apache.org/jira/browse/CALCITE-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5547: Description: The query  {code:java} SELECT '' as \"xxx\", * FROM (values (1, 4, 'one')) as t1(i

[jira] [Commented] (CALCITE-5547) Join using returns incorrect column names

[ https://issues.apache.org/jira/browse/CALCITE-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17718018#comment-17718018 ] Jiajun Xie commented on CALCITE-5547: - The PR is ready: https://github.com/apache/calcite/pull/3183

[jira] [Assigned] (CALCITE-5547) Join using returns incorrect column names

[ https://issues.apache.org/jira/browse/CALCITE-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5547: --- Assignee: Jiajun Xie > Join using returns incorrect column names >

[jira] [Commented] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign

[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17718007#comment-17718007 ] Jiajun Xie commented on CALCITE-5668: - Should core allow dollar sign?   I think babel can do

[jira] [Commented] (CALCITE-5680) Wrong plan for multiple IN sub-queries with only literal operands

[ https://issues.apache.org/jira/browse/CALCITE-5680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17717887#comment-17717887 ] Jiajun Xie commented on CALCITE-5680: - It it a bug, incorrect SQL is more obvious. {code:java}

[jira] [Commented] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17715214#comment-17715214 ] Jiajun Xie commented on CALCITE-5656: - The issue look like CALCITE-5530.   I think my PR can

[jira] [Commented] (CALCITE-5630) Window with rows equivalence error in volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-5630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17714012#comment-17714012 ] Jiajun Xie commented on CALCITE-5630: - HepPlanner has same issue

[jira] [Commented] (CALCITE-5632) Query with ORDER BY and null values NullPointer exception

[ https://issues.apache.org/jira/browse/CALCITE-5632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17710967#comment-17710967 ] Jiajun Xie commented on CALCITE-5632: - In my opinion, if a non-nullable column has a null value, an

[jira] [Commented] (CALCITE-5632) Query with ORDER BY and null values NullPointer exception

[ https://issues.apache.org/jira/browse/CALCITE-5632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17709950#comment-17709950 ] Jiajun Xie commented on CALCITE-5632: - I cannot reproduce your problem in main branch, which

[jira] [Commented] (CALCITE-5637) RelOptRulesTest testPushAggregateThroughJoin7 optimized query not equivalent to the original one

[ https://issues.apache.org/jira/browse/CALCITE-5637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17709948#comment-17709948 ] Jiajun Xie commented on CALCITE-5637: - The result in `agg.iq` is right {code:java} # [CALCITE-5637]

[jira] [Commented] (CALCITE-5637) RelOptRulesTest testPushAggregateThroughJoin7 optimized query not equivalent to the original one

[ https://issues.apache.org/jira/browse/CALCITE-5637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17709947#comment-17709947 ] Jiajun Xie commented on CALCITE-5637: - I think MySQL result that contain two row is error.   If

[jira] [Updated] (CALCITE-5630) Window with rows equivalence error in volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-5630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5630: Description: Here is UT {code:java} @Test void testUnionWindow() { String selectSqlBase =

[jira] [Created] (CALCITE-5630) Window with rows equivalence error in volcano planner

Jiajun Xie created CALCITE-5630: --- Summary: Window with rows equivalence error in volcano planner Key: CALCITE-5630 URL: https://issues.apache.org/jira/browse/CALCITE-5630 Project: Calcite

[jira] [Commented] (CALCITE-5597) SELECT DISTINCT query with ORDER BY column will get error result

[ https://issues.apache.org/jira/browse/CALCITE-5597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707620#comment-17707620 ] Jiajun Xie commented on CALCITE-5597: - Yes, I changed the summary. > SELECT DISTINCT query with

[jira] [Updated] (CALCITE-5597) SELECT DISTINCT query with ORDER BY column will get error result

[ https://issues.apache.org/jira/browse/CALCITE-5597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5597: Summary: SELECT DISTINCT query with ORDER BY column will get error result (was: Column that be

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707249#comment-17707249 ] Jiajun Xie commented on CALCITE-5506: - [~libenchao] , yes. RelFieldTrimmer is correct.   I found

[jira] [Resolved] (CALCITE-5605) Add BigQuery as supported library for CHR

[ https://issues.apache.org/jira/browse/CALCITE-5605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5605. - Fix Version/s: 1.35.0 Resolution: Fixed > Add BigQuery as supported library for CHR >

[jira] [Commented] (CALCITE-5605) Add BigQuery as supported library for CHR

[ https://issues.apache.org/jira/browse/CALCITE-5605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707085#comment-17707085 ] Jiajun Xie commented on CALCITE-5605: - Fixed in

[jira] [Commented] (CALCITE-5588) ArrayIndexOutOfBoundsException on select

[ https://issues.apache.org/jira/browse/CALCITE-5588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705033#comment-17705033 ] Jiajun Xie commented on CALCITE-5588: - This error can be reproduced in join.iq {code:java} > Caused

[jira] [Updated] (CALCITE-5597) Column that be order by should not be aggregated

[ https://issues.apache.org/jira/browse/CALCITE-5597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5597: Summary: Column that be order by should not be aggregated (was: Column that be order by should

[jira] [Created] (CALCITE-5597) Column that be order by should not be aggregate

Jiajun Xie created CALCITE-5597: --- Summary: Column that be order by should not be aggregate Key: CALCITE-5597 URL: https://issues.apache.org/jira/browse/CALCITE-5597 Project: Calcite Issue

[jira] [Created] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

Jiajun Xie created CALCITE-5590: --- Summary: NullPointerException when converting 'in' expression that is used inside select list and group by Key: CALCITE-5590 URL:

[jira] [Commented] (CALCITE-5570) Support nested map type for SqlDataTypeSpec

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17699331#comment-17699331 ] Jiajun Xie commented on CALCITE-5570: - [~Sergey Nuyanzin] , thanks for your review.   I changed

[jira] [Assigned] (CALCITE-5570) Support nested map type for SqlDataTypeSpec

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5570: --- Assignee: Jiajun Xie > Support nested map type for SqlDataTypeSpec >

[jira] [Updated] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5506: Summary: RelToSqlConverter should retain the aggregation logic (was: RelToSqlConverter should

[jira] [Assigned] (CALCITE-5530) RelToSqlConverter[ORDER BY] generates an incorrect field alias when 2 projection fields have the same name

[ https://issues.apache.org/jira/browse/CALCITE-5530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5530: --- Assignee: Jiajun Xie > RelToSqlConverter[ORDER BY] generates an incorrect field alias

[jira] [Resolved] (CALCITE-5518) RelToSql converter generates invalid order of ROLLUP fields

[ https://issues.apache.org/jira/browse/CALCITE-5518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5518. - Fix Version/s: 1.34.0 Resolution: Fixed > RelToSql converter generates invalid order of

[jira] [Commented] (CALCITE-5518) RelToSql converter generates invalid order of ROLLUP fields

[ https://issues.apache.org/jira/browse/CALCITE-5518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693595#comment-17693595 ] Jiajun Xie commented on CALCITE-5518: - Fixed in

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic even if the aggregation function is trimmed

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693594#comment-17693594 ] Jiajun Xie commented on CALCITE-5506: - [~libenchao], I changed the title. Does it precise? >

[jira] [Updated] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic even if the aggregation function is trimmed

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5506: Summary: RelToSqlConverter should retain the aggregation logic even if the aggregation function

[jira] [Commented] (CALCITE-5486) SubQuery not support HAVING alias in where condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693592#comment-17693592 ] Jiajun Xie commented on CALCITE-5486: - [~libenchao], you are right. My solution only for where

[jira] [Commented] (CALCITE-5518) RelToSql converter generates invalid order of ROLLUP fields

[ https://issues.apache.org/jira/browse/CALCITE-5518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17690859#comment-17690859 ] Jiajun Xie commented on CALCITE-5518: - [~julianhyde], your advice is useful. Thank you very much!

[jira] [Commented] (CALCITE-5523) RelToSql converter generates GROUP BY clause with window expression

[ https://issues.apache.org/jira/browse/CALCITE-5523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17687547#comment-17687547 ] Jiajun Xie commented on CALCITE-5523: - In my opinion, it is similar as  CALCITE-4491.   I have

[jira] [Assigned] (CALCITE-5523) RelToSql converter generates GROUP BY clause with window expression

[ https://issues.apache.org/jira/browse/CALCITE-5523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5523: --- Assignee: Jiajun Xie > RelToSql converter generates GROUP BY clause with window

<    1   2   3   4   5   6   >