MYSQL do wrong math with strings [duplicate]












-2
















This question already has an answer here:




  • Is floating point math broken?

    28 answers




Simple sql code gives strange result:



select '0.29'*100;


Result: 28.999999999999996



Another one:



select '0.28'*100;


Result: 28.000000000000004



What's going on? Is it a bug?



I couldn't find any other number that behaves like that.






mysql string math







share|improve this question















marked as duplicate by Amadan, High Performance Mark, Madhur Bhaiya, Giorgos Myrianthous, meowgoesthedog Nov 21 '18 at 8:54


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.























    -2
















    This question already has an answer here:




    • Is floating point math broken?

      28 answers




    Simple sql code gives strange result:



    select '0.29'*100;


    Result: 28.999999999999996



    Another one:



    select '0.28'*100;


    Result: 28.000000000000004



    What's going on? Is it a bug?



    I couldn't find any other number that behaves like that.






    mysql string math







    share|improve this question















    marked as duplicate by Amadan, High Performance Mark, Madhur Bhaiya, Giorgos Myrianthous, meowgoesthedog Nov 21 '18 at 8:54


    This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.





















      -2












      -2








      -2









      This question already has an answer here:




      • Is floating point math broken?

        28 answers




      Simple sql code gives strange result:



      select '0.29'*100;


      Result: 28.999999999999996



      Another one:



      select '0.28'*100;


      Result: 28.000000000000004



      What's going on? Is it a bug?



      I couldn't find any other number that behaves like that.






      mysql string math







      share|improve this question

















      This question already has an answer here:




      • Is floating point math broken?

        28 answers




      Simple sql code gives strange result:



      select '0.29'*100;


      Result: 28.999999999999996



      Another one:



      select '0.28'*100;


      Result: 28.000000000000004



      What's going on? Is it a bug?



      I couldn't find any other number that behaves like that.





      This question already has an answer here:




      • Is floating point math broken?

        28 answers







      mysql string math




      mysql string math






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 21 '18 at 8:06







      Paulius Ščerbinskas

















      asked Nov 21 '18 at 8:05









      Paulius ŠčerbinskasPaulius Ščerbinskas

      41




      41




      marked as duplicate by Amadan, High Performance Mark, Madhur Bhaiya, Giorgos Myrianthous, meowgoesthedog Nov 21 '18 at 8:54


      This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.









      marked as duplicate by Amadan, High Performance Mark, Madhur Bhaiya, Giorgos Myrianthous, meowgoesthedog Nov 21 '18 at 8:54


      This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


























          1 Answer
          1






          active

          oldest

          votes


















          1














          Double is 32-bit, and when you output it's an int, it's 16 bit, and of course there's a loss of precision






          share|improve this answer






























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            1














            Double is 32-bit, and when you output it's an int, it's 16 bit, and of course there's a loss of precision






            share|improve this answer




























              1














              Double is 32-bit, and when you output it's an int, it's 16 bit, and of course there's a loss of precision






              share|improve this answer


























                1












                1








                1







                Double is 32-bit, and when you output it's an int, it's 16 bit, and of course there's a loss of precision






                share|improve this answer













                Double is 32-bit, and when you output it's an int, it's 16 bit, and of course there's a loss of precision







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 21 '18 at 8:28









                LoGanLoGan

                111




                111

















                    -

                    Popular posts from this blog

                    mysqli_query(): Empty query in /home/lucindabrummitt/public_html/blog/wp-includes/wp-db.php on line 1924

                    Image
                    0 I just uploaded a new plugin to my wordpress site and I got this warning: mysqli_query(): Empty query in /home/lucindabrummitt/public_html/blog/wp-includes/wp-db.php on line 1924 Usually if I have a problem, I can find answers on google but this one seems pretty particular and I'm not finding any info on it except for this forum. I'm not terribly techie but if someone can tell me how to read this and how to change it I can follow directions pretty well. Thanks All! PS If I don't have the proper tags here could someone add the appropriate tags? php mysql wordpress share | improve this question asked Nov 16 '18 at 20:41 ...
                    Read more

                    How to change which sound is reproduced for terminal bell?

                    Image
                    3 Recently upgrade to 18.10 from 18.04, and using the terminal is becoming annoying: the new alert sound is a drip ( /usr/share/sounds/gnome/default/alerts/drip.ogg ), and the previous one is still located at ( /usr/share/sounds/ubuntu/stereo/bell.ogg ). My issue is that at the gnome-terminal, when autocompleting or pressing left BOTH sounds are reproduced, at the same time. I want to just have ubuntu/stereo/bell.ogg active, not both . At the moment I have been only able to reduce the volume of the alerts (but still both are played), or turn the alerts down (but I dislike both "solutions"). gnome-terminal 18.10 teminal-bell share | improve this question ...
                    Read more

                    Can I use Tabulator js library in my java Spring + Thymeleaf project?

                    Image
                    0 I want to add Tabulator js to my java project. I added tabulator.min.js, tabulator.min.css to resources folder. After that added to my html page these dependencies as recommending in readme.md. <link rel="stylesheet" th:href="@{/css/tabulator.min.css}"> <script type="text/javascript" th:src="@{/js/tabulator.min.js}"></script> Now my tables view all elements, that I have in the html page, but not correct. In the documentation of Tabulator is example how to create header and table, var table = new Tabulator("#example-table", { columns:[ {title:"Name", field:"name", sorter:"string", width:200, editor:true}, {title:"Age", field:"age", sorter:"...
                    Read more