Unexpected warning emitted when inserting into a float number
Bug #1002131 reported by
Igor Babaev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Confirmed
|
Medium
|
Alexey Botchkov |
Bug 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)
See also bug #63704 from bugs.mysql.com
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
assignee: | nobody → Alexey Botchkov (holyfoot) |
milestone: | none → 5.2 |
To post a comment you must log in.