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

group by push down: HAVING optimized out causes crash

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.5
    • 10.4
    • Optimizer
    • None
    • CentOS 6.9

    Description

      Using an engine that defines the new group by push down API;
      When running this query:

      CREATE TABLE t1 (a int) engine=columnstore;
      INSERT INTO t1 VALUES (1), (2), (1), (3), (2), (1);
      SELECT a FROM t1 GROUP BY a HAVING 1 != 1;
      

      mysqld crashes at sql_select.cc:2431 bzero(curr_tab, sizeof(JOIN_TAB));

      At this point curr_tab is NULL.

      I don't know if it should be NULL (probably should), but we shouldn't be bzero-ing a NULL pointer.

      Attachments

        Activity

          People

            Unassigned Unassigned
            David.Hall David Hall (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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