Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4771

Connect SE: Connection dies using table_type=pivor

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.3
    • Fix Version/s: 10.0.4
    • Component/s: None
    • Labels:
    • Environment:
      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

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            erkules erkan yanar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: