Re: Documentation for maths operations between different types?

2019-08-19 Thread Divya Gehlot
Hi , Can someone help me guide through to start with update the Drill documentation by adding the missing functions ? Appreciate the pointers / link to update the Drill doc and how can I gather all the information and create the JIRA for it ? Thanks, Divya On Sat, 17 Aug 2019 at 01:06, Paul

Re: Documentation for maths operations between different types?

2019-08-16 Thread Paul Rogers
Hi Divya, Would be great to add to the docs. First step is to gather the info in a JIRA ticket. Then, someone (thanks for volunteering) can update the various tables in the docs. I believe that the documentation is generated via some process other than a direct edit of the MD files in the

Re: Documentation for maths operations between different types?

2019-08-16 Thread Paul Rogers
Hi Dave, Charles and I added the sqlTypeOf() function while writing the book so we could clearly explain types. Drill also has a SQL-standard function, typeOf(), but this tends to report "NULL" if the value is null, regardless of type, which made it hard to explain the behavior of nullable

Re: Documentation for maths operations between different types?

2019-08-16 Thread Divya Gehlot
Can we add this as part of Drill Function docs , will be useful for other ppl as well ? I can help to add , unsure if I have access to edit Drill doc Thanks , Divya On Fri, 16 Aug 2019 at 01:04, Paul Rogers wrote: > Hi Dave, > > As it turns out, improving the detail in function documentation

Re: Documentation for maths operations between different types?

2019-08-16 Thread Dave Challis
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 wrote: > Hi Dave, > > As it turns out, improving the detail in function documentation is a > long-standing request. The historical answer has been to

Re: Documentation for maths operations between different types?

2019-08-15 Thread Paul Rogers
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

Documentation for maths operations between different types?

2019-08-15 Thread Dave Challis
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