Details
- 
    Bug 
- 
    Status: Open (View Workflow)
- 
    Major 
- 
    Resolution: Unresolved
- 
    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.21),(12.1); | 
| SELECT a, a MOD 1.1, a DIV 1.1 FROM t1; | 
| +-------+-----------+ | 
| | a     | a MOD 1.1 | | 
| +-------+-----------+ | 
| |  1.21 |      0.21 | | 
| | 12.10 |      0.10 | | 
| +-------+-----------+
 | 
Looks wrong. The expected result is:
| DROP TABLE IF EXISTS t1; | 
| CREATE TABLE t1 (a DECIMAL(10,2)) ENGINE=InnoDB; | 
| INSERT INTO t1 VALUES (1.21),(12.1); | 
| SELECT a, a MOD 1.1, a DIV 1.1 FROM t1; | 
| +-------+-----------+ | 
| | a     | a MOD 1.1 | | 
| +-------+-----------+ | 
| |  1.21 |      0.11 | | 
| | 12.10 |      0.00 | | 
| +-------+-----------+
 |