Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.3
-
None
-
Linux/Ubuntu/Precise/LXContainer
Description
Creating a pivot table (Connect SE) and selecting from the table works.
Doing a second select the connection dies.
MariaDB [test]> select * from pivottet; |
ERROR 2013 (HY000): Lost connection to MySQL server during query |
MariaDB [test]> create table pivottet engine=connect table_type=pivot tabname=salary; |
Query OK, 0 rows affected (0.02 sec) |
MariaDB [test]> select * from pivottet; |
+--------+------+-----+------+-----+ |
| sellet | 1 | 2 | 3 | 4 |
|
+--------+------+-----+------+-----+ |
| 1 | 100 | 300 | 1000 | 0 |
|
| 2 | 1000 | 100 | 0 | 0 |
|
| 3 | 0 | 0 | 0 | 500 |
|
+--------+------+-----+------+-----+ |
3 rows in set (0.00 sec) |
MariaDB [test]> select * from pivottet; |
ERROR 2013 (HY000): Lost connection to MySQL server during query |
That is written into the error log:
Jul 9 10:17:56 localhost mysqld: 130709 10:17:56 [Warning] Aborted connection 264 to db: 'test' user: 'root' host: 'localhost' (Unknown error)
|
Regards
Erkan