Re: [Tarantool-discussions] The result type and argument types of the built-in SQL functions.

[Mergen Imeev <imeevma@tarantool.org>]

On Wed, Jul 29, 2020 at 11:54:12AM +0300, Timur Safin wrote:
> 
> I general, I agree that UNSIGNED is unnecessary, but the rest of table
> is pretty much ok with me. (Though blob vs string discussion opened elsewhere
> is important)
> 
> With one small note below...
> 
> : From: Mergen Imeev <imeevma@tarantool.org>
> : Subject: The result type and argument types of the built-in SQL functions.
> : 
> : Hi, Peter!
> : 
> : I would like to ask you a few questions about the result type and argument
> : types of the SQL built-in functions.
> : 
> : I suggest changing the result types of some functions. A table with the
> : current
> : result type and the suggested result type is below.
> : 
> : FUNCTION NAME		CURRENT		SUGGESTED
> : abs			number		number
> : avg			number		double
> : char			string		string
> : character_length	integer		unsigned
> ...
> : soundex			string		string
> : substr			string		string
> : sum			number		number
> : total			number		double
> 
> Why total should be different than sum? (I'd use the same number)
> 
In SQLite TOTAL always returns DOUBLE. SUM may return INTEGER if all values
are of INTEGER type.

> 
> Regards,
> Timur
>