Skip to content

radians function result does not consistent with MySQL #57671

@gengliqi

Description

@gengliqi

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    affects-5.4This bug affects the 5.4.x(LTS) versions.affects-6.1This bug affects the 6.1.x(LTS) versions.affects-6.5This bug affects the 6.5.x(LTS) versions.affects-7.1This bug affects the 7.1.x(LTS) versions.affects-7.5This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.affects-8.5This bug affects the 8.5.x(LTS) versions.impact/wrong-resultseverity/majorsig/executionSIG executiontype/bugThe issue is confirmed as a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions