Skip to content

radians function with <> operator returns incorrect result #57661

@apollodafoni

Description

@apollodafoni

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table lrr_test(`COL1` int);
insert into lrr_test values(23);
select col1, radians(col1) from lrr_test where radians(col1) <> radians(23);

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

Empty set

v8.4.0 can return correctly, this is a regression

3. What did you see instead (Required)

+------+---------------------+
| col1 | radians(col1) |
+------+---------------------+
| 23 | 0.40142572795869574 |
+------+---------------------+

4. What is your TiDB version? (Required)

Release Version: v8.5.0-alpha-201-g6e22b8cb13
Edition: Community
Git Commit Hash: 6e22b8c
Git Branch: HEAD
UTC Build Time: 2024-11-22 09:09:32
GoVersion: go1.23.3
Race Enabled: false
Check Table Before Drop: false
Store: tikv

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions