|
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (i INT, d DECIMAL(10,1)) ENGINE=ColumnStore;
|
INSERT INTO t1 VALUES (0, 1.5);
|
UPDATE t1 SET i=d;
|
ERROR 1264 (22003): CAL0002: IDB-2025: Data truncated for column 'i'
|
Looks wrong. It should round decimal to int without errors, like InnoDB does:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (i INT, d DECIMAL(10,1)) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (0, 1.5);
|
UPDATE t1 SET i=d;
|
SELECT * FROM t1;
|
+------+------+
|
| i | d |
|
+------+------+
|
| 2 | 1.5 |
|
+------+------+
|
|