You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "duan xiong (Jira)" <ji...@apache.org> on 2021/11/24 15:39:00 UTC
[jira] [Comment Edited] (CALCITE-4888) Unify type inferring logical for Sarg RexLiteral
[ https://issues.apache.org/jira/browse/CALCITE-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17448682#comment-17448682 ]
duan xiong edited comment on CALCITE-4888 at 11/24/21, 3:38 PM:
----------------------------------------------------------------
If you don't think this is a problem, Please add extra SQL unit tests in PR. (I guess can't get the consistent result with PostgreSQL)
was (Author: nobigo):
If you don't think this is a problem, Please add extra SQL unit test. (I guess can't get the consistent result with PostgreSQL)
> Unify type inferring logical for Sarg RexLiteral
> ------------------------------------------------
>
> Key: CALCITE-4888
> URL: https://issues.apache.org/jira/browse/CALCITE-4888
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Jing Zhang
> Priority: Major
> Labels: pull-request-available
> Attachments: image-2021-11-23-10-31-05-137.png
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> There exists some inconsistency to infer type of Sarg RexLiteral.
> 1. The method `RexSargBuilder#getType` in `RexSimplify` using `rexBuilder.typeFactory.leastRestrictive(Util.distinctList(types));`
> 2. The methods `RexBuilder#makeIn` and `RexBuilder#makeBetween` using type of first ranges as Sarg RexLiteral's type.
> It's better to unify type inferring logical for Sarg RexLiteral.
> IMO, I think using `rexBuilder.typeFactory.leastRestrictive(Util.distinctList(types));` is more reasonable.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)