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

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

    XMLWordPrintable

Details

    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)

      Attachments

        Activity

          People

            Unassigned Unassigned
            igor Igor Babaev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.