You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Liya Fan (Jira)" <ji...@apache.org> on 2020/11/26 06:24:00 UTC

[jira] [Created] (CALCITE-4420) Some simple arithmetic operations can be simplified

Liya Fan created CALCITE-4420:
---------------------------------

             Summary: Some simple arithmetic operations can be simplified
                 Key: CALCITE-4420
                 URL: https://issues.apache.org/jira/browse/CALCITE-4420
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Liya Fan
            Assignee: Liya Fan


Some simple arithmetic operations can be simplified, for example:

a + 0 = a
a - 0 = a
a * 1 = a
a / 1 = a

In our product, we found such scenarios are fairly frequently encountered. For example, some SQL programmers use a * 1.0 as a convenient way to cast {{a}} to floating point type. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)