[ 
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)

Reply via email to