Hi Dave,

As it turns out, improving the detail in function documentation is a 
long-standing request. The historical answer has been to either 1) read the 
code, or 2) try it with a test query.

You can use the sqlTypeOf() function to learn the answer to your question:

SELECT sqlTypeOf(cast(1 AS INT) / cast(2 AS INT)) FROM values(1)

Charles Givre patiently tracked down and documented all the Drill functions in 
his appendix to our book "Learning Apache Drill." But, even there, the level of 
detail you request is missing.

Maybe, once you do the research to find the answers you want, you could submit 
a Documentation JIRA ticket with the results so that it can be added to the 

- Paul


    On Thursday, August 15, 2019, 03:55:11 AM PDT, Dave Challis 
<dave.chal...@cipher.ai> wrote:  
 Is there any documentation out there on how mathematical functions are
handled when operating on different types?


* would integer division of 1 / 2 produce a float or double of 0.5? Or an
integer of the same type set to 0?

* if two INT are multipled and produce a result larger than INT can
support, is the result returned as a BIGINT?

Reply via email to