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

Server crash in /sql/sql_window.cc:3033 in Window_funcs_sort::setup(THD*, SQL_SELECT*, List_iterator<Item_window_func>&, st_join_table*)

    XMLWordPrintable

Details

    Description

      poc:

      CREATE TABLE v983 ( v984 FLOAT NOT NULL ) ;
       INSERT INTO v983 ( v984 ) VALUES ( 52 ) ;
       UPDATE v983 SET v984 = 46 WHERE v984 = 26 ;
       INSERT INTO v983 ( v984 ) VALUES ( 0 ) , ( 0 ) ;
       WITH v986 AS ( SELECT v984 FROM ( SELECT v984 FROM v983 GROUP BY v984 ) AS v985 ) SELECT v984 FROM v986 WHERE v984 BETWEEN FALSE AND ( ( ( v984 OR NOT v984 ) BETWEEN ( ( ( v984 = ( ( ( ( v984 , v984 ) NOT IN ( SELECT ( 'x' = ( v984 IN ( SELECT v984 FROM ( SELECT v984 FROM ( SELECT DISTINCT ( ( NOT ( 41280532.000000 AND v984 = 9 ) ) = -128 AND v984 = -1 ) % 2147483647 , ( v984 = 71 OR v984 > 'x' ) FROM v983 WHERE v984 = 66 AND ( v984 = 10 OR v984 = 0 OR v984 = 22760412.000000 ) ) AS v987 NATURAL JOIN v983 WHERE v984 BETWEEN FALSE AND ( ( 69654023.000000 = 79 OR 'x' * 35 = 55 ) NOT LIKE 'x' ) ) AS v988 NATURAL JOIN v983 AS v989 UNION SELECT 50 FROM v983 ORDER BY LAST_VALUE ( ( NOT ( v984 * 72 = 10 * NULL ) ) ) OVER x DESC ) ) ) , 'x' FROM v983 ) ) = 'x' * NULL ) IN ( SELECT v984 FROM v983 ) ) < 'x' ) ) ) AND 66525661.000000 ) ) ;
      

      output:
      SUMMARY: AddressSanitizer: SEGV /sql/sql_window.cc:3033 in Window_funcs_sort::setup(THD*, SQL_SELECT*, List_iterator<Item_window_func>&, st_join_table*)

      The full error log is in the attachment.

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              nobody Shihao Wen
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.