List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:May 1 1999 9:30pm
Subject:RE: SIN, COS, etc.. return nulls
View as plain text  
>>>>> "Richard" == Richard Rossi <richard.rossi@stripped> writes:

Richard> Sure,
Richard> Here we go...

mysql> SELECT SIN(40), COS(20), ASIN(0.3), ACOS(0.2), TAN(45);
Richard> +---------+---------+-----------+-----------+---------+
Richard> | SIN(40) | COS(20) | ASIN(0.3) | ACOS(0.2) | TAN(45) |
Richard> +---------+---------+-----------+-----------+---------+
Richard> |    NULL |    NULL |      NULL |      NULL |    NULL |
Richard> +---------+---------+-----------+-----------+---------+
Richard> 1 row in set (0.00 sec)

mysql> SELECT VERSION();
Richard> +----------------------+
Richard> | version()            |
Richard> +----------------------+
Richard> | 3.21.29a-gamma-debug |
Richard> +----------------------+
Richard> 1 row in set (0.33 sec)

Hi!

I have now tested this with the shareware version, and it seams that
you are right;  The shareware version returns NULL for all the above
functions, while the registered version returns the correct values.

The above wasn't intended with the shareware version;  There must have 
been some library conflict when we built the shareware version..

Sorry, but to be able to use trigonometric functions, you must get the
registered MySQL version.

Regards,
Monty
Thread
SIN, COS, etc.. return nullsRichard Rossi29 Apr
  • SIN, COS, etc.. return nullsMichael Widenius30 Apr
RE: SIN, COS, etc.. return nullsRichard Rossi30 Apr
  • RE: SIN, COS, etc.. return nullsMichael Widenius2 May
    • Compiling 3.22.22 ProblemFraser MacKenzie2 May
      • Re: Compiling 3.22.22 ProblemFraser MacKenzie2 May
      • Compiling 3.22.22 ProblemMichael Widenius2 May
Re: Compiling 3.22.22 ProblemFraser MacKenzie2 May
Re: Compiling 3.22.22 ProblemFraser MacKenzie2 May
  • Re: Compiling 3.22.22 ProblemGreg Patterson2 May
    • Re: Compiling 3.22.22 ProblemFraser MacKenzie2 May