Thanks Paul, I hadn't seen sqlTypeOf before, that looks perfect for checking this sort of thing.
Dave On Thu, 15 Aug 2019 at 18:04, Paul Rogers <[email protected]> wrote: > 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 < > [email protected]> 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? >
