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

`Lost connection to server during query` error occurred while executing the query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 11.3.2
    • N/A
    • Optimizer
    • x86 and macOS

    Description

      CREATE TABLE t0 (
      c0 decimal(10, 0) NOT NULL,
      c1 float unsigned zerofill NOT NULL,
      PRIMARY KEY (c0, c1)
      );

      INSERT INTO t0 VALUES (-2068985011, 0.75245386), (-668435082, 0.19411194), (-500731198, 0.39079505), (0, 0), (0, 0.9938275), (12196703, 970789000), (919009011, 0.28699672), (1069380201, 0.2576304);

      SELECT t0.c0 FROM t0 GROUP BY t0.c0, t0.c1 OR '' HAVING NOT t0.c0;

      Expected:
      ----

      c0

      ----

      0
      0

      ----

      Result:
      MariaDB [testdb]> SELECT t0.c0 FROM t0 GROUP BY t0.c0, CAST(t0.c1 AS DATE), t0.c0 OR '' HAVING NOT (t0.c0);
      ERROR 2013 (HY000): Lost connection to server during query

      Attachments

        Activity

          People

            Unassigned Unassigned
            yangshijie yangshijie
            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.