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

                    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

                    Title Spacing in Bjornstrup Chapter, Removing Chapter Number From Contents

                    Image
                    up vote 5 down vote favorite 2 I would like to make it so that the vertical space below the title of each chapter is the same when using the Bjornstrup package (i.e. so that the descenders do not affect the spacing - as shown by the red arrow in the picture below). I think I'm fairly happy with the spacing around "A chapter", so I'd really like titles without descenders (e.g. "Contents") to have the same vertical spacing as "A chapter" below the title. I would also like to remove the large "0" in the contents title. Any help appreciated, as always. documentclass[11pt,a4paper]{book} % Packages[![enter image description here][1]][1] usepackage[left=3.5cm, right=3.5cm, top=4.3cm, bottom=4.25cm]{geometry} usepackage[utf8]{inputenc} usepackage{libertine} usepackage[libertine]{newtx
                    Read more