1 Reply Latest reply on May 22, 2015 1:34 PM by thatJeffSmith-Oracle

    SQLDeveloper v4.0.2.15 (15.21) bug in updates query when binding numbers

    2955824

      Hi,

       

      I saw a bug in sqldeveloper 4.0.2.15 (maybe after ?, can't find this bug with google).

      If you write an update query, and bind a floating number then, see theses few examples :

      0.5 is binded to 0

      1.5 is binded to 1.5

      .5 is binded to 0.5

      So, don't write the 0 before the coma if your number is between 0 and 1.

      In a select query, there is no bug.

      Didn't tryed the insert query.

      Sorry for my english.