• unknown's avatar
    Bug#6147: Traditional: Assigning a string to a numeric column has unexpected results · 03d411b1
    unknown authored
    The problem was that when converting a string to an exact number,
    rounding didn't work, because conversion didn't understand
    approximate numbers notation.
    Fix: a new function for string-to-number conversion was implemented,
    which is aware of approxinate number notation (with decimal point
    and exponent, e.g. -19.55e-1)
    
    
    include/m_ctype.h:
      Adding new function into MY_CHARSET_HANDLER
      Adding prototypes for 8bit and ucs2 functions.
    mysql-test/r/loaddata.result:
      Fixing results
    mysql-test/r/ps_2myisam.result:
      Fixing results
    mysql-test/r/ps_3innodb.result:
      Fixing results
    mysql-test/r/ps_4heap.result:
      Fixing results
    mysql-test/r/ps_5merge.result:
      Fixing results
    mysql-test/r/ps_6bdb.result:
      Fixing results
    mysql-test/r/rpl_rewrite_db.result:
      Fixing results
    mysql-test/r/select.result:
      Fixing results
    mysql-test/r/sp-vars.result:
      Fixing results
    mysql-test/r/strict.result:
      Fixing results
    mysql-test/r/view.result:
      Fixing results
    mysql-test/r/warnings.result:
      Fixing results
    mysql-test/t/strict.test:
      Fixing results
    sql/field.cc:
      Using new function
    strings/ctype-big5.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-bin.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-cp932.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-euc_kr.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-eucjpms.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-gb2312.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-gbk.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-latin1.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-simple.c:
      Implementing my_strntoull10_8bit
      Adding new function into MY_CHARSET_HANDLER
    strings/ctype-sjis.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-tis620.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-ucs2.c:
      Implementing UCS2 wrapper for 8bit version
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-ujis.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    strings/ctype-utf8.c:
      Adding new function into the MY_CHARSET_HANDLER structure
    mysql-test/r/round.result:
      New BitKeeper file ``mysql-test/r/round.result''
    mysql-test/t/round.test:
      New BitKeeper file ``mysql-test/t/round.test''
    03d411b1
select.result 89.3 KB