Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1601

GROUP BY handler fails with subquery in HAVING

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.2
    • 1.2
    • MDB Plugin
    • None
    • 2018-15, 2018-16, 2018-17, 2018-18, 2018-19, 2018-20, 2018-21, 2019-01, 2019-02

    Description

      Conducting the test suite connector crashes when dereferences a NULL pointer:

      MariaDB [test]> set infinidb_vtable_mode=0;
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> explain extended select sum(i) from cs3 group by it having it < (select sum(it) * 5 from cs3);
      +------+-------------+-------+------+---------------+------+---------+------+------+----------+---------------------------------+
      | id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra                           |
      +------+-------------+-------+------+---------------+------+---------+------+------+----------+---------------------------------+
      |    1 | PRIMARY     | NULL  | NULL | NULL          | NULL | NULL    | NULL | NULL |     NULL | Storage engine handles GROUP BY |
      |    2 | SUBQUERY    | NULL  | NULL | NULL          | NULL | NULL    | NULL | NULL |     NULL | Storage engine handles GROUP BY |
      +------+-------------+-------+------+---------------+------+---------+------+------+----------+---------------------------------+
      2 rows in set, 1 warning (0.00 sec)
       
      MariaDB [test]> select sum(i) from cs3 group by it having it < (select sum(it) * 5 from cs3);
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      MariaDB [test]> select * from cs3;
      ERROR 2006 (HY000): MySQL server has gone away
      No connection. Trying to reconnect...
      Connection id:    9
      Current database: test
       
      +------+------+
      | i    | it   |
      +------+------+
      |    5 |    5 |
      |    6 |    3 |
      |   25 |   32 |
      +------+------+
      3 rows in set (0.08 sec)
      

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            drrtuy Roman
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.