Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.2
-
None
-
2018-15, 2018-16, 2018-17, 2018-18, 2018-19, 2018-20, 2018-21, 2019-01, 2019-02
Description
Conducting the test suite connector crashes when dereferences a NULL pointer:
MariaDB [test]> set infinidb_vtable_mode=0;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [test]> explain extended select sum(i) from cs3 group by it having it < (select sum(it) * 5 from cs3);
|
+------+-------------+-------+------+---------------+------+---------+------+------+----------+---------------------------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|
+------+-------------+-------+------+---------------+------+---------+------+------+----------+---------------------------------+
|
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Storage engine handles GROUP BY |
|
| 2 | SUBQUERY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Storage engine handles GROUP BY |
|
+------+-------------+-------+------+---------------+------+---------+------+------+----------+---------------------------------+
|
2 rows in set, 1 warning (0.00 sec)
|
|
|
MariaDB [test]> select sum(i) from cs3 group by it having it < (select sum(it) * 5 from cs3);
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [test]> select * from cs3;
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 9
|
Current database: test
|
|
|
+------+------+
|
| i | it |
|
+------+------+
|
| 5 | 5 |
|
| 6 | 3 |
|
| 25 | 32 |
|
+------+------+
|
3 rows in set (0.08 sec)
|