|
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a DECIMAL(10,1)) ENGINE=ColumnStore;
|
INSERT INTO t1 VALUES (-1.6);
|
SELECT CEIL(a), LEFT('abc', CEIL(a)) FROM t1;
|
+---------+----------------------+
|
| CEIL(a) | LEFT('abc', CEIL(a)) |
|
+---------+----------------------+
|
| -1 | abc |
|
+---------+----------------------+
|
Looks wrong. The expected result is:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a DECIMAL(10,1)) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (-1.6);
|
SELECT CEIL(a), LEFT('abc', CEIL(a)) FROM t1;
|
+---------+----------------------+
|
| CEIL(a) | LEFT('abc', CEIL(a)) |
|
+---------+----------------------+
|
| -1 | |
|
+---------+----------------------+
|
|