Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR 1690: overflows float #46538

Closed
bajinsheng opened this issue Aug 31, 2023 · 2 comments · Fixed by #53501
Closed

ERROR 1690: overflows float #46538

bajinsheng opened this issue Aug 31, 2023 · 2 comments · Fixed by #53501
Assignees
Labels
affects-6.5 affects-7.1 affects-7.5 affects-8.1 fuzz/sqlancer may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 severity/moderate sig/execution SIG execution type/bug The issue is confirmed as a bug.

Comments

@bajinsheng
Copy link

Bug Report

1. Minimal reproduce step (Required)

CREATE TABLE t0(c0 FLOAT ZEROFILL, PRIMARY KEY(c0));
INSERT INTO t0(c0) VALUES (1);
SELECT t0.c0 FROM t0 WHERE t0.c0!=BIN(-1); -- ERROR 1690 (22003): constant 1.1111111111111112e+63 overflows float

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

The error disappears when I remove the primary key, so it is unexpected.

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

| Release Version: v7.4.0-alpha-239-g4f2f5e1061
Edition: Community
Git Commit Hash: 4f2f5e1
Git Branch: master
UTC Build Time: 2023-08-30 12:06:00
GoVersion: go1.21.0
Race Enabled: false
Check Table Before Drop: false
Store: unistore |

@bajinsheng bajinsheng added the type/bug The issue is confirmed as a bug. label Aug 31, 2023
@bajinsheng
Copy link
Author

bajinsheng commented Aug 31, 2023

/label fuzz/sqlancer

@ti-chi-bot ti-chi-bot bot added may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 labels Sep 4, 2023
@jebter jebter added the sig/execution SIG execution label Sep 4, 2023
@zanmato1984
Copy link
Contributor

This is relative corner so lowering the severity.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-6.5 affects-7.1 affects-7.5 affects-8.1 fuzz/sqlancer may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 severity/moderate sig/execution SIG execution type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants