pingcap / tidb

TiDB - the open-source, cloud-native, distributed SQL database designed for modern applications.
https://pingcap.com
Apache License 2.0
37.37k stars 5.86k forks source link

`radians` function result does not consistent with MySQL #57671

Open gengliqi opened 2 hours ago

gengliqi commented 2 hours ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

select radians(1.0e308);
select radians(23);

2. What did you expect to see? (Required)

MySQL 8.3
mysql> select radians(1.0e308);
+------------------------+
| radians(1.0e308)       |
+------------------------+
| 1.7453292519943295e306 |
+------------------------+
1 row in set (0.00 sec)

mysql> select radians(23);
+--------------------+
| radians(23)        |
+--------------------+
| 0.4014257279586958 |
+--------------------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

mysql> select radians(1.0e308);
+------------------+
| radians(1.0e308) |
+------------------+
|                0 |
+------------------+
1 row in set (0.00 sec)

mysql> select radians(23);
+---------------------+
| radians(23)         |
+---------------------+
| 0.40142572795869574 |
+---------------------+
1 row in set (0.00 sec)

4. What is your TiDB version? (Required)

Master

gengliqi commented 2 hours ago

/severity major

gengliqi commented 2 hours ago

/label affects-5.4 /label affects-6.1 /label affects-6.5 /label affects-7.1 /label affects-7.5 /label affects-8.1 /label affects-8.5