Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.5
-
None
-
um1-2xpm ; centos7
Description
ColumnStore in auto-switch operational mode fail to process query with Internal error and
aggregation data overflow
| operational_mode | result |
|---|---|
| 0 | pass |
| 1 | fail |
| 2 | fail |
query pass with generic infinidb_vtable_mode = 0 but when set to the auto-switch mode 2 it's returned Internal Error
MariaDB [ffr]> set infinidb_vtable_mode = 2 ;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [ffr]> show variables like '%infinidb_vtable_mode%';
|
+----------------------+-------+
|
| Variable_name | Value |
|
+----------------------+-------+
|
| infinidb_vtable_mode | 2 |
|
+----------------------+-------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [ffr]> select sum(c1) from t1;
|
ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within InfiniDB. Please check the log files for more details. Additional Information: aggregation data overflow.
|
MariaDB [ffr]>
|
|
the same query pass with columnstore generic mode and it would be expected to pass also with auto-switch mode
MariaDB [ffr]> set infinidb_vtable_mode = 0 ;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [ffr]> select sum(c1) from t1;
|
+----------------------+
|
| sum(c1) |
|
+----------------------+
|
| 18446744073709551614 |
|
+----------------------+
|
1 row in set (0.07 sec)
|
|
|
MariaDB [ffr]>
|
|
Attachments
Issue Links
- relates to
-
-
- Closed
-