Description:
A simple query results in this error every time:
ERROR 2013 (HY000): Lost connection to MySQL server during query
How to repeat:
mysql> use test;
Database changed
mysql> create temporary table a (
-> x int,
-> y int);
Query OK, 0 rows affected (0.01 sec)
mysql> create temporary table b (
-> x int,
-> y int);
Query OK, 0 rows affected (0.00 sec)
mysql> create temporary table c (
-> x int,
-> primary key (x));
Query OK, 0 rows affected (0.02 sec)
mysql> insert a values (1, 1), (2, 1), (3, 1), (4, 3), (5, 6), (6, 6);
Query OK, 6 rows affected (0.01 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql> insert b values (1, 1), (2, 1), (3, 3), (4, 6), (5, 6), (6, 7);
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql> insert c values (1), (2), (3), (4), (5), (6);
Query OK, 6 rows affected (0.01 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql> select A.x, C.x
-> from a A, b B, c C
-> where A.x = B.x and C.x >= A.y and C.x <= B.y;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
Description: A simple query results in this error every time: ERROR 2013 (HY000): Lost connection to MySQL server during query How to repeat: mysql> use test; Database changed mysql> create temporary table a ( -> x int, -> y int); Query OK, 0 rows affected (0.01 sec) mysql> create temporary table b ( -> x int, -> y int); Query OK, 0 rows affected (0.00 sec) mysql> create temporary table c ( -> x int, -> primary key (x)); Query OK, 0 rows affected (0.02 sec) mysql> insert a values (1, 1), (2, 1), (3, 1), (4, 3), (5, 6), (6, 6); Query OK, 6 rows affected (0.01 sec) Records: 6 Duplicates: 0 Warnings: 0 mysql> insert b values (1, 1), (2, 1), (3, 3), (4, 6), (5, 6), (6, 7); Query OK, 6 rows affected (0.00 sec) Records: 6 Duplicates: 0 Warnings: 0 mysql> insert c values (1), (2), (3), (4), (5), (6); Query OK, 6 rows affected (0.01 sec) Records: 6 Duplicates: 0 Warnings: 0 mysql> select A.x, C.x -> from a A, b B, c C -> where A.x = B.x and C.x >= A.y and C.x <= B.y; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql>