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

Certain window function queries crash mysqld

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.2.5
    • Fix Version/s: 1.2.6
    • Component/s: MariaDB Server
    • Labels:
      None
    • Sprint:
      2019-06

      Description

      In sql_select.cc optimize_stage2() line 2433, Columnstore has added:

        // @InfiniDB We don't need tmp table for vtable create phase. Plus
      		 
        // to build tmp table may corrupt some field table_name & db_name (for some reason)
      		 
        if (thd->infinidb_vtable.vtable_state == THD::INFINIDB_CREATE_VTABLE)
      		 
      	need_tmp = false;

      Removing this allows the query to run against InnoDB correcty. Investigating other things.

        Attachments

          Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19364 Server crashes on certain window function usage

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              David.Hall David Hall
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.