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

Connect SE: Connection dies using table_type=pivor

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.3
    • 10.0.4
    • 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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.