Description
log10('-Infinity'); log2('-Infinity'); power('Infinity',2)
As above, using the + infinity function in some math functions will report an error in calcite, but mysql and posgtres will not report an error. I think the + infinity parameter is meaningful in mathematics.
--postgres postgres=# select power('Infinity', -2); power ------- 0 (1 row)postgres=# select log('Infinity', 2); log ----- 0 (1 row)postgres=# select log10('Infinity'); log10 ---------- Infinity (1 row)postgres=# select power('Infinity', 2); power ---------- Infinity (1 row) --mysql mysql> select log10('+Infinity'); +--------------------+ | log10('+Infinity') | +--------------------+ | NULL | +--------------------+ 1 row in set, 2 warnings (0.00 sec)mysql> select power('Infinity', 2); +----------------------+ | power('Infinity', 2) | +----------------------+ | 0 | +----------------------+ 1 row in set, 1 warning (0.00 sec)mysql> select power('-Infinity', 2); +-----------------------+ | power('-Infinity', 2) | +-----------------------+ | 0 | +-----------------------+ 1 row in set, 1 warning (0.00 sec)mysql> select log10('-Infinity'); +--------------------+ | log10('-Infinity') | +--------------------+ | NULL | +--------------------+ 1 row in set, 2 warnings (0.00 sec)