Bug #18734 ASIN() is treated as user function

• Submitted: 3 Apr 2006 10:25
• Modified: 5 Apr 2006 12:14
• Reporter: Karol Baczewski
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.19-nt-log
• OS: Windows (win xp sp2)
• CPU Architecture: Any

[3 Apr 2006 10:25] Karol Baczewski

Description:
When I use ASIN() like that

SELECT ASIN(2);

The result is: 1.5707963267949

When I use it like that

SELECT ASIN(`id`) FROM `table`;

I get error:

#1305 - FUNCTION database.ASIN does not exist.
It was working fine in MySQL 4.x

How to repeat:
When I use ASIN() like that

SELECT ASIN(2);

The result is: 1.5707963267949

When I use it like that

SELECT ASIN(`id`) FROM `table`;

I get error:

#1305 - FUNCTION database.ASIN does not exist.
It was working fine in MySQL 4.x

[3 Apr 2006 12:38] MySQL Verification Team

Thank you for the bug report. I was unable to repeat the issue
reported. Please notice that ASIN range is -1 to 1 otherwise
it returns NULL and also see you error message happens when
you leave a space between ASIN and the parentheses.

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.19-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table t (id float);
Query OK, 0 rows affected (0.19 sec)

mysql> insert into t values (2),(0.2);
Query OK, 2 rows affected (0.06 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> SELECT ASIN(id) FROM t;
+------------------+
| ASIN(id)         |
+------------------+
| NULL             |
| 0.20135792383202 |
+------------------+
2 rows in set (0.11 sec)

mysql> SELECT ASIN (id) FROM t;
ERROR 1305 (42000): FUNCTION test.ASIN does not exist
mysql>

[5 Apr 2006 13:17] MySQL Verification Team

Notice that in 5.0 or later you can use SQL mode: IGNORE_SPACE for
to lift this restriction.