[jira] [Assigned] (CALCITE-5957) Valid DATE '1945-2-2' is not accepted due to regression

[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky reassigned CALCITE-5957: --- Assignee: Evgeny Stanilovsky > Valid DATE '1945-2-2' is not accepted due t

[jira] [Closed] (CALCITE-5963) Simplify 'x OR NOT(x)' to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo closed CALCITE-5963. --- Resolution: Duplicate > Simplify 'x OR NOT(x)' to TRUE > -- > >

[jira] [Updated] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#translateCast#scaleIntervalToNumber will scale interval to num

[jira] [Commented] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759790#comment-17759790 ] Ran Tao commented on CALCITE-5960: -- thanks, updated the Jira name and stack trace. >

[jira] [Updated] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Summary: CAST failed if SqlTypeFamily of targetType is NULL (was: Inapplicable type should pass throug

[jira] [Commented] (CALCITE-5964) Support additional metadata attributes in GET_TABLES and GET_COLUMNS

[ https://issues.apache.org/jira/browse/CALCITE-5964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759769#comment-17759769 ] Julian Hyde commented on CALCITE-5964: -- Let's look at changes required on server,

[jira] [Updated] (CALCITE-5964) Support additional metadata attributes in GET_TABLES and GET_COLUMNS

[ https://issues.apache.org/jira/browse/CALCITE-5964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5964: - Description: The goal is to add to Avatica a mechanism such that additional metadata fields pe

[jira] [Created] (CALCITE-5964) Support additional metadata attributes in GET_TABLES and GET_COLUMNS

Oliver Lee created CALCITE-5964: --- Summary: Support additional metadata attributes in GET_TABLES and GET_COLUMNS Key: CALCITE-5964 URL: https://issues.apache.org/jira/browse/CALCITE-5964 Project: Calcite

[jira] [Updated] (CALCITE-5964) Support additional metadata attributes in GET_TABLES and GET_COLUMNS

[ https://issues.apache.org/jira/browse/CALCITE-5964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5964: Description: The goal is to add to Avatica a mechanism such that additional metadata fields pert

[jira] [Commented] (CALCITE-4782) Allow 'CAST(numeric AS BOOLEAN)' (if enabled by conformance)

[ https://issues.apache.org/jira/browse/CALCITE-4782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759723#comment-17759723 ] Tanner Clary commented on CALCITE-4782: --- [~julianhyde]Sorry should have clarified

[jira] [Commented] (CALCITE-5960) Inapplicable type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759710#comment-17759710 ] Julian Hyde commented on CALCITE-5960: -- How would you explain this bug to an end u

[jira] [Commented] (CALCITE-5956) Support parsing non-standard collection types

[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759720#comment-17759720 ] Julian Hyde commented on CALCITE-5956: -- [~hongyuguo], I agree we need a syntax for

[jira] [Commented] (CALCITE-4782) Allow 'CAST(numeric AS BOOLEAN)' (if enabled by conformance)

[ https://issues.apache.org/jira/browse/CALCITE-4782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759708#comment-17759708 ] Julian Hyde commented on CALCITE-4782: -- [~tanclary] For which values of n does CAS

[jira] [Commented] (CALCITE-5960) Inapplicable type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759709#comment-17759709 ] Julian Hyde commented on CALCITE-5960: -- Please restore the linefeeds in the stack

[jira] [Commented] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759707#comment-17759707 ] Julian Hyde commented on CALCITE-5678: -- Thanks, [~zstan]; I see that [~Runking] ha

[jira] [Comment Edited] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759707#comment-17759707 ] Julian Hyde edited comment on CALCITE-5678 at 8/28/23 7:34 PM: --

[jira] [Commented] (CALCITE-5957) Valid DATE '1945-2-2' is not accepted due to regression

[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759706#comment-17759706 ] Julian Hyde commented on CALCITE-5957: -- I don't know what the SQL standard says, o

[jira] [Commented] (CALCITE-4189) Simplify 'p OR (p IS NOT TRUE)' to 'TRUE'

[ https://issues.apache.org/jira/browse/CALCITE-4189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759673#comment-17759673 ] Julian Hyde commented on CALCITE-4189: -- Let's deal with similar cases: * {{p OR N

[jira] [Updated] (CALCITE-4189) Simplify 'p OR (p IS NOT TRUE)' to 'TRUE'

[ https://issues.apache.org/jira/browse/CALCITE-4189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4189: - Summary: Simplify 'p OR (p IS NOT TRUE)' to 'TRUE' (was: Simplify 'P OR P IS NOT TRUE' to 'TRU

[jira] [Commented] (CALCITE-5963) Simplify 'x OR NOT(x)' to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759651#comment-17759651 ] Julian Hyde commented on CALCITE-5963: -- Yes, this is a duplicate of CALCITE-4189.

[jira] [Updated] (CALCITE-5953) AggregateCaseToFilterRule may make inaccurate SUM transformation

[ https://issues.apache.org/jira/browse/CALCITE-5953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5953: Labels: pull-request-available (was: ) > AggregateCaseToFilterRule may make inaccurate S

[jira] [Commented] (CALCITE-5963) Simplify 'x OR NOT(x)' to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759620#comment-17759620 ] Zoltan Haindrich commented on CALCITE-5963: --- I think instead of restricting

[jira] [Commented] (CALCITE-5963) Simplify 'x OR NOT(x)' to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759619#comment-17759619 ] hongyu guo commented on CALCITE-5963: - Oops, maybe this case is same as CALCITE-418

[jira] [Commented] (CALCITE-5962) Allow Spark-style syntax "LEFT ANTI JOIN" in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759614#comment-17759614 ] Mingcan Wang commented on CALCITE-5962: --- [~julianhyde] ok, I've already fixed >

[jira] [Updated] (CALCITE-5962) Allow Spark-style syntax "LEFT ANTI JOIN" in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mingcan Wang updated CALCITE-5962: -- Summary: Allow Spark-style syntax "LEFT ANTI JOIN" in Babel parser (was: Add "ANTI" enumerat

[jira] [Assigned] (CALCITE-5963) Simplify 'x OR NOT(x)' to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo reassigned CALCITE-5963: --- Assignee: hongyu guo > Simplify 'x OR NOT(x)' to TRUE > -- > >

[jira] [Updated] (CALCITE-5963) Simplify 'x OR NOT(x)' to TRUE

[ https://issues.apache.org/jira/browse/CALCITE-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5963: Description: When unknownAs is TRUE, or type of x is not nullable, Calcite can simpify: x OR NOT

[jira] [Created] (CALCITE-5963) Simplify 'x OR NOT(x)' to TRUE

hongyu guo created CALCITE-5963: --- Summary: Simplify 'x OR NOT(x)' to TRUE Key: CALCITE-5963 URL: https://issues.apache.org/jira/browse/CALCITE-5963 Project: Calcite Issue Type: New Feature

[jira] [Commented] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759613#comment-17759613 ] Julian Hyde commented on CALCITE-5962: -- Can you fix the summary so that it describ

[jira] [Commented] (CALCITE-5860) Decimal type conversion missing scale

[ https://issues.apache.org/jira/browse/CALCITE-5860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759612#comment-17759612 ] pengfei.zhan commented on CALCITE-5860: --- [~zabetak] Could you help to trigger ano

[jira] [Assigned] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mingcan Wang reassigned CALCITE-5962: - Assignee: Mingcan Wang > Add "ANTI" enumeration join type at JoinType.java > -

[jira] [Updated] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5962: Labels: pull-request-available (was: ) > Add "ANTI" enumeration join type at JoinType.ja

[jira] [Commented] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759562#comment-17759562 ] LiYuE commented on CALCITE-5962: [~shenlang] Thanks for your reply,  we will submit a P

[jira] [Commented] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759561#comment-17759561 ] Mingcan Wang commented on CALCITE-5962: --- I'm doing this right now > Add "ANTI" e

[jira] [Commented] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759555#comment-17759555 ] LakeShen commented on CALCITE-5962: --- I found that in the JoinType class, there is alr

[jira] [Updated] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5962: -- Attachment: image-2023-08-28-19-47-40-712.png > Add "ANTI" enumeration join type at JoinType.java > -

[jira] [Updated] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LiYuE updated CALCITE-5962: --- Description: Currently, Spark SQL supports parsing the "anti join" SQL syntax [Spark anti join|https://spa

[jira] [Updated] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LiYuE updated CALCITE-5962: --- Description: Currently, Spark SQL supports parsing the "anti join" SQL syntax [Spark Anti join syntax|[ht

[jira] [Updated] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LiYuE updated CALCITE-5962: --- Description: Currently, Spark SQL supports parsing the "anti join" SQL syntax [[link title|http://example.

[jira] [Updated] (CALCITE-5962) Add "ANTI" enumeration join type at JoinType.java

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LiYuE updated CALCITE-5962: --- Summary: Add "ANTI" enumeration join type at JoinType.java (was: Add "ANTI JOIN" enumeration type at JoinT

[jira] [Created] (CALCITE-5962) Add "ANTI JOIN" enumeration type at JoinType.java

LiYuE created CALCITE-5962: -- Summary: Add "ANTI JOIN" enumeration type at JoinType.java Key: CALCITE-5962 URL: https://issues.apache.org/jira/browse/CALCITE-5962 Project: Calcite Issue Type: Wish

[jira] [Commented] (CALCITE-5914) Cache compiled regular expressions in SQL function runtime

[ https://issues.apache.org/jira/browse/CALCITE-5914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759490#comment-17759490 ] Thomas Rebele commented on CALCITE-5914: Thank you for the implementation. I th

[jira] [Updated] (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 ] libopeng updated CALCITE-5570: -- Description: There was added a similar support for arrays/multisets at https://issues.apache.org/jir

[jira] [Commented] (CALCITE-5923) Some test cases in `SqlOperatorTest` violates the test fixture's design principle

[ https://issues.apache.org/jira/browse/CALCITE-5923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759481#comment-17759481 ] Evgeny Stanilovsky commented on CALCITE-5923: - [~Runking] yep, i think we n