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

Function NOT/IF returns incorrect result with decimal argument #11188

Closed
SunRunAway opened this issue Jul 11, 2019 · 1 comment · Fixed by #15016 or #12173
Closed

Function NOT/IF returns incorrect result with decimal argument #11188

SunRunAway opened this issue Jul 11, 2019 · 1 comment · Fixed by #15016 or #12173
Labels
component/expression help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/bug The issue is confirmed as a bug.

Comments

@SunRunAway
Copy link
Contributor

SunRunAway commented Jul 11, 2019 •
edited
Loading

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?
    If possible, provide a recipe for reproducing the error.
select NOT 0.00000001000000000000, IF(0.00000001000000000000, 1, 0);
  1. What did you expect to see?
mysql> select NOT 0.00000001000000000000, IF(0.00000001000000000000, 1, 0);
+----------------------------+----------------------------------+
| NOT 0.00000001000000000000 | IF(0.00000001000000000000, 1, 0) |
+----------------------------+----------------------------------+
|                          0 |                                1 |
+----------------------------+----------------------------------+
1 row in set (0.00 sec)
  1. What did you see instead?
mysql> select NOT 0.00000001000000000000, IF(0.00000001000000000000, 1, 0);
+----------------------------+----------------------------------+
| NOT 0.00000001000000000000 | IF(0.00000001000000000000, 1, 0) |
+----------------------------+----------------------------------+
|                          1 |                                0 |
+----------------------------+----------------------------------+
1 row in set (0.00 sec)
  1. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

8c20289
@SunRunAway SunRunAway added the type/bug The issue is confirmed as a bug. label Jul 11, 2019
@SunRunAway SunRunAway changed the title Function NOT returns incorrect result with decimal argument Function NOT/IF returns incorrect result with decimal argument Jul 11, 2019
@SunRunAway SunRunAway mentioned this issue Jul 12, 2019
Open
37 tasks
@SunRunAway SunRunAway added help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. and removed help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. labels Jul 12, 2019
@SunRunAway SunRunAway linked a pull request Mar 13, 2020 that will close this issue
expression: fix wrong behavior for IF(not_int, *, *) #15016
Merged
@SunRunAway
Copy link
Contributor Author

Fixed by #12173 and #15016

@sduzh sduzh mentioned this issue Mar 13, 2020
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
component/expression help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
1 participant
@SunRunAway