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

Jul  9 10:17:56 localhost mysqld: 130709 10:17:56 [Warning] Aborted connection 264 to db: 'test' user: 'root' host: 'localhost' (Unknown error)