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.

Sign up for GitHub

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

Jump to bottom

unexpected: Data Truncated #15608

Open
maddyblue opened this issue Mar 23, 2020 · 5 comments
Open

unexpected: Data Truncated #15608

maddyblue opened this issue Mar 23, 2020 · 5 comments
Assignees
@ichn-hu
Labels
component/expression severity/moderate sig/execution SIG execution type/bug The issue is confirmed as a bug.

Comments

@maddyblue
Copy link

Another unexpected error from some reasonable math.

MySQL [d]> SELECT (0.1 % (0.17186983111376686 / (0.7669647527142911 - ((0.347496123123123 / (0.1 / 0.08980744924)) % 0.1)))) + 0;
ERROR 1265 (01000): Data Truncated
@maddyblue maddyblue added the type/bug The issue is confirmed as a bug. label Mar 23, 2020
@qw4990
Copy link
Contributor

qw4990 commented Mar 24, 2020

@mjibson Thanks for your feedback! We will investigate this problem soon.

@XuHuaiyu XuHuaiyu added the sig/execution SIG execution label Dec 21, 2020
@ichn-hu ichn-hu mentioned this issue Dec 21, 2020
Closed
@ichn-hu
Copy link
Contributor

ichn-hu commented Dec 22, 2020

/assign @ichn-hu

@Defined2014
Copy link
Contributor

It works in master branch right now, maybe we can close this issue. @ichn-hu @tisonkun

@ichn-hu
Copy link
Contributor

ichn-hu commented Oct 26, 2021 •
edited
Loading

can you find the commit that fixes it? maybe this can be helpful https://internals.tidb.io/t/topic/428 @Defined2014

@Defined2014
Copy link
Contributor

can you find the commit that fixes it? maybe this can be helpful https://internals.tidb.io/t/topic/428 @Defined2014

Sorry, I missed something in SQL. It's still can reprocudce. :(

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ichn-hu ichn-hu

Labels
component/expression severity/moderate sig/execution SIG execution type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
7 participants
@maddyblue @zz-jason @qw4990 @XuHuaiyu @Defined2014 @sre-bot @ichn-hu