[ 
https://issues.apache.org/jira/browse/CALCITE-7443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18066683#comment-18066683
 ] 

Mihai Budiu commented on CALCITE-7443:
--------------------------------------

Producing an incorrect result is bad.

We have to find the root cause. There's some arithmetic on intervals which 
probably ignores overflows. This example has constant values, but this could 
probably happen for runtime values as well.

> Incorrect simplification for large interval
> -------------------------------------------
>
>                 Key: CALCITE-7443
>                 URL: https://issues.apache.org/jira/browse/CALCITE-7443
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.41.0
>            Reporter: Mihai Budiu
>            Priority: Minor
>
> The following passes as a quidem test:
> {code:java}
>  SELECT INTERVAL 2147483647 years;
> +--------+
> | EXPR$0 |
> +--------+
> | -1     |
> +--------+
> (1 row)
> !ok{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to