[
https://issues.apache.org/jira/browse/CALCITE-7227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18029912#comment-18029912
]
Mihai Budiu edited comment on CALCITE-7227 at 10/14/25 11:18 PM:
-----------------------------------------------------------------
In our compiler I have disabled the following conversions:
* SQRT(x) is rewritten as POW(x, .5); turns out that in many libraries SQRT
can be more precise and faster than POW
* IS (NOT) DISTINCT FROM which is rewritten to something very complicated,
whereas it can be just equals.
Moreover, the convertlet table seems to have functions from a variety of
dialects.
was (Author: JIRAUSER295926):
In our compiler I have disabled the following conversions:
* SQRT(x) is rewritten as POW(x, .5); turns out that in many libraries SQRT can
be more precise and faster than POW
* IS (NOT) DISTINCT FROM which is rewritten to something very complicated,
whereas it can be just equals.
Moreover, the convertlet table seems to have functions from a variety of
dialects.
> There is no way to modify the StandardConvertletTable
> -----------------------------------------------------
>
> Key: CALCITE-7227
> URL: https://issues.apache.org/jira/browse/CALCITE-7227
> Project: Calcite
> Issue Type: Wish
> Components: core
> Affects Versions: 1.40.0
> Reporter: Mihai Budiu
> Priority: Minor
>
> The convertlet table has a lot of functionality, but there is no easy way to,
> let's say, exclude one of the conversions that is undesirable. Copying and
> modifying the whole class is a solution, but it is not great. Adding new
> conversions seems possible, but excluding the existing ones seems impossible.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)