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

SIGSEGV in sub_select_postjoin_aggr

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 12.0.2
    • N/A
    • N/A
    • None
    • Not for Release Notes

    Description

      Crash involving `AVG()` window function in a subquery with `ORDER BY`.

      CREATE DATABASE IF NOT EXISTS HuangHe;
      		 
      USE HuangHe;
      		 
      SELECT * FROM ( SELECT 1 x ) x WHERE ( 's%' IN ( WITH x AS ( SELECT 1 ) SELECT x FROM x ORDER BY AVG ( x ) OVER ( PARTITION BY ( AVG ( x ) ) ) ) );


      mariadbd(_Z24sub_select_postjoin_aggrP4JOINP13st_join_tableb+0x34)[0x57a28c9f3484]
      		 
      mariadbd(_ZN4JOIN10exec_innerEv+0xd21)[0x57a28c9be461]
      		 
      mariadbd(_ZN4JOIN4execEv+0x37)[0x57a28c9be7c7]
      		 
      mariadbd(_ZN30subselect_single_select_engine4execEv+0x149)[0x57a28cd6bf39]

      Attachments

        Activity

          People

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