|
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)
|
|
|