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 documentation. Thanks, - 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? E.g.: * 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?