Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
2021-8
Description
There seems to be no PR or merge into 6.1.1 as of now. We need to make sure this does not reappear when we make it.
Attachments
Issue Links
- split from
-
MCOL-4613 Garbage result of a union between huge narrow DECIMAL and BIGINT
-
- Closed
-
Build verified: 6.1.1 (Drone #2394)
Result now matches with Innodb.
MariaDB [monty]> DROP TABLE IF EXISTS t1;
Query OK, 0 rows affected, 1 warning (0.120 sec)
MariaDB [monty]> CREATE TABLE t1 (a DECIMAL(17,1), b BIGINT) ENGINE=ColumnStore;
Query OK, 0 rows affected (0.626 sec)
MariaDB [monty]> INSERT INTO t1 VALUES (9999999999999999.9, 999999999999999999);
Query OK, 1 row affected (0.276 sec)
MariaDB [monty]> SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t1) tu;
+----------------------+
| a |
+----------------------+
| 999999999999999999.0 |
| 9999999999999999.9 |
+----------------------+
2 rows in set (0.123 sec)