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