|
DROP TABLE IF EXISTS cs1;
|
CREATE TABLE cs1 (d6 DECIMAL(18,1))ENGINE=ColumnStore;
|
INSERT INTO cs1 VALUES (-9999.0);
|
SELECT d6, FLOOR(d6) FROM cs1;
|
+---------+-----------+
|
| d6 | FLOOR(d6) |
|
+---------+-----------+
|
| -9999.0 | -10000 |
|
+---------+-----------+
|
Looks wrong. The expected result is:
DROP TABLE IF EXISTS cs1;
|
CREATE TABLE cs1 (d6 DECIMAL(18,1))ENGINE=InnoDB;
|
INSERT INTO cs1 VALUES (-9999.0);
|
SELECT d6, FLOOR(d6) FROM cs1;
|
+---------+-----------+
|
| d6 | FLOOR(d6) |
|
+---------+-----------+
|
| -9999.0 | -9999 |
|
+---------+-----------+
|
|