Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.6.1, 6.1.1
-
Fix Version/s: 6.1.1
-
Component/s: PrimProc
-
Labels: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 | |
|
+---------+----------------------+
|