IMO, it is a plain bug in MySQL 5.5+ then. At least a documentation bug, but I believe more than that. -- Peter On Thu, Aug 1, 2013 at 10:35 PM, Roberto Spadim <roberto@spadim.com.br>wrote:
from mysql 5.1, 5.5, 5.6, 5.7 manual
http://dev.mysql.com/doc/refman/5.1/en/mathematical-functions.html#function_...
http://dev.mysql.com/doc/refman/5.5/en/mathematical-functions.html#function_...
http://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html#function_...
http://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html#function_... * *
-
COT(*X*)<http://dev.mysql.com/doc/refman/5.1/en/mathematical-functions.html#function_cot>
Returns the cotangent of *X*.
mysql> *SELECT COT(12);* -> -1.5726734063977 mysql> *SELECT COT(0);* -> NULL
maybe a sql_mode parameter change the output of this function?