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
Bug
Minor
