Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.2.0
-
None
-
None
-
2018-14, 2018-15, 2018-16, 2018-17
Description
The CS crashes trying to print out a zero pointer Item_ident.field_name. Normally server returns hardcoded 'tmp_field' value.
The steps to reproduce:
MariaDB [cs]> show create table cs1;
|
+-------+--------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+--------------------------------------------------------------------------------------------------------------------------+
|
| cs1 | CREATE TABLE `cs1` (
|
`i` int(11) DEFAULT NULL,
|
`it` int(11) DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=latin1 |
|
+-------+--------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [cs]> select * from cs1;
|
+------+------+
|
| i | it |
|
+------+------+
|
| 1 | 2 |
|
| 3 | 4 |
|
| 25 | 26 |
|
| 25 | 1 |
|
+------+------+
|
4 rows in set (0.06 sec)
|
|
MariaDB [cs]> select sum(i)+1 from cs1 group by i;
|
+----------+
|
| sum(i)+1 |
|
+----------+
|
| 4 |
|
| 2 |
|
| 51 |
|
+----------+
|
3 rows in set (0.02 sec)
|
|
MariaDB [cs]> set infinidb_vtable_mode=0;
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [cs]> select sum(i)+1 from cs1 group by i;
|
Attachments
Issue Links
- relates to
-
MCOL-1510 GROUP BY handler doesn't support operations on aggregate functions when projecting columns.
- Closed