In code, It's here under DataType used by AggregateDataDefault.add
public static int getAddProofType(int type) {
switch (type) {
case Value.BYTE:
return Value.LONG;
case Value.FLOAT:
return Value.DOUBLE;
case Value.INT:
return Value.LONG;
case Value.LONG:
return Value.DECIMAL;
case Value.SHORT:
return Value.LONG;
default:
return type;
}
}
for INT column, it will use LONG as the result type.
在 2015年4月1日星期三 UTC+8下午3:28:19，Noel Grandin写道：
>
>
>
> On 2015-03-31 11:26 AM, AWe wrote:
> > We expect that AVG returns the result as float. However, it returns the
> result as Integer.
> > Any ideas?
>
> Read the documentation:
> http://h2database.com/html/functions.html#avg
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
