Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Fixed
- 
    5.6.1, 6.1.1
- 
    None
Description
| 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 |                      | | 
| +---------+----------------------+
 |