Hi Aron Tao, Calcite adheres to SQL standard in that respect (citing): The data types NUMERIC, DECIMAL, INTEGER and SMALLINT are collectively > referred to > as exact numeric types.
The data types FLOAT, REAL, and DOUBLE PRECISION are collectively referred > to as approx- > imate numeric types. In practice the way we represent a number can lead to an exact (scale + precision) or an approximate (base + mantissa) representation, which suits very different needs. Best regards, Alessandro On Thu, 15 Oct 2020 at 16:16, JiaTao Tao <[email protected]> wrote: > In calcite, you can not mod doubles. In Java, you can, in C you can't use > "%" to mod doubles, but you can use fmod. > > Regards! > > Aron Tao > > > JiaTao Tao <[email protected]> 于2020年10月15日周四 下午10:00写道： > > > org.apache.calcite.sql.type.SqlTypeName#APPROX_TYPES > > org.apache.calcite.sql.type.SqlTypeName#NUMERIC_TYPES > > > > Regards! > > > > Aron Tao > > >
