Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.4.3, 5.5.1, 5.6.1, 6.1.1
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(10,2)) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES (1.3); |
SELECT a MOD 1.3 FROM t1; |
+-----------+
|
| a MOD 1.3 |
|
+-----------+
|
| 0.30 |
|
+-----------+
|
If I run the same script with MyISAM (or any other engine), the result is as follows:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(10,2)) ENGINE=MyISAM; |
INSERT INTO t1 VALUES (1.3); |
SELECT a MOD 1.3 FROM t1; |
+-----------+
|
| a MOD 1.3 |
|
+-----------+
|
| 0.00 |
|
+-----------+
|