Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-719

LP:1002131 - Unexpected warning emitted when inserting into a float number

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 10.0.10
        • Component/s: None

          Description

          The following sequence of commands produces an unexpected warning in MariaDB 5.2/5.5:

          MariaDB [test]> CREATE TABLE t1 (f FLOAT);
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> INSERT INTO t1 VALUES ('1.');
Query OK, 1 row affected, 1 warning (0.00 sec)

MariaDB [test]> SHOW WARNINGS;
+---------+------+----------------------------------------+
| Level   | Code | Message                                |
+---------+------+----------------------------------------+
| Warning | 1265 | Data truncated for column 'f' at row 1 |
+---------+------+----------------------------------------+
1 row in set (0.00 sec)

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #63704 Conversion of '1.' to a number gives error 1265 (WARN_DATA_TRUNCATED)

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  ratzpo Rasmus Johansson added a comment -

                  Launchpad bug id: 1002131

                  Show
                  ratzpo Rasmus Johansson added a comment - Launchpad bug id: 1002131
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  fixed in mysql-5.6.5

                  Show
                  serg Sergei Golubchik added a comment - fixed in mysql-5.6.5
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Fixed in 10.0.10 by the following revision:
                  http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/4052

                  revno: 4052
revision-id: sanja@montyprogram.com-20140314073116-nklb0jkjd4t1w40n
parent: monty@mariadb.org-20140313144311-hmphz2gup3qdjlp9
committer: sanja@montyprogram.com
branch nick: work-maria-10.0-MDEV-5819
timestamp: Fri 2014-03-14 09:31:16 +0200
message:
  MDEV-5819: MySQL Bug #13500371 63704: CONVERSION OF '1.' TO A NUMBER GIVES ERROR 1265 (WARN_DATA_TRUNCATED)
  
  Fix by MySQL ported
                  Show
                  elenst Elena Stepanova added a comment - Fixed in 10.0.10 by the following revision: http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/4052 revno: 4052 revision-id: sanja@montyprogram.com-20140314073116-nklb0jkjd4t1w40n parent: monty@mariadb.org-20140313144311-hmphz2gup3qdjlp9 committer: sanja@montyprogram.com branch nick: work-maria-10.0-MDEV-5819 timestamp: Fri 2014-03-14 09:31:16 +0200 message: MDEV-5819: MySQL Bug #13500371 63704: CONVERSION OF '1.' TO A NUMBER GIVES ERROR 1265 (WARN_DATA_TRUNCATED) Fix by MySQL ported

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      igor Igor Babaev
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: