Description:
Server crashes repeatable on query
select group_concat(personNbr order by full_name)
from bug.personView
;
'bug.personView' is a view that joins bug.person on itself.
The bug goes away if
1. smaller number of rows created in the table (it needs approx 1000 )
2. view is replaced with equivalent subselect
3. the first operand of the concatenation (ifnull(c.first_name||' ','')||)
in the view is removed.
4. 'order by' clause removed from the group_concat
CONSOLE LOG
mysql> create database if not exists bug ;
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> drop table if exists bug.persons,bug.numbers ;
Query OK, 0 rows affected (0.00 sec)
mysql> create table bug.numbers (number int);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into bug.numbers values
-> (1), (2), ......, (1083), (1084)
-> ;
Query OK, 1084 rows affected (0.02 sec)
Records: 1084 Duplicates: 0 Warnings: 0
mysql> CREATE TABLE bug.persons ( `personNbr` int(11) NOT NULL auto_increment, `
first_name` varchar(254) default NULL, `last_name` varchar(254) default NULL, `p
arentNbr` int(11) default NULL, PRIMARY KEY (`personNbr`), KEY `parentNbr` (`pa
rentNbr`) )
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into bug.persons
-> select number,'first','last',number from bug.numbers where number between
1 and 1084
-> ;
Query OK, 1084 rows affected (0.02 sec)
Records: 1084 Duplicates: 0 Warnings: 0
mysql> create or replace algorithm=merge view bug.personview as
-> select
-> c.personNbr
-> ,ifnull(c.first_name||' ','')||ifnull(c.Last_name,p.last_name) as full_na
me
-> from bug.persons as c
-> left join bug.persons as p on p.personNbr=c.parentNbr
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> select group_concat(personNbr order by full_name)
-> from bug.personView
-> ;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> select version();
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: *** NONE ***
+-------------------------+
| version() |
+-------------------------+
| 5.0.27-community-nt-log |
+-------------------------+
How to repeat:
run the sql in the attached file