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

Crash: Sequence functions crash on CTE alias

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.6, 10.11, 11.4, 11.8, 12.3, 13.0, 12.2.2
    • N/A
    • Optimizer - CTE
    • None
    • Ubuntu 24.04
    • Can result in hang or crash

    Description

      The following input will cause MariaDB to crash:

      DROP DATABASE IF EXISTS db;
      CREATE DATABASE db;
      USE db;
       
      CREATE TABLE t (id INT PRIMARY KEY, p INT, o INT, v INT);
      INSERT INTO t VALUES (1,1,1,1);
       
      SELECT ROW_NUMBER() OVER (ORDER BY id) AS rn,
             (WITH x(x) AS (SELECT 1) SELECT LASTVAL(x)) AS seq_value
      FROM t;
      

      Stack Trace:
      mariadbd(my_print_stacktrace+0x30)[0x58fe35def960]
      mariadbd(handle_fatal_signal+0x1f3)[0x58fe3593b843]
      /lib/x86_64-linux-gnu/libc.so.6(+0x45330)[0x7ffa72101330]
      mariadbd(_ZN17Item_func_lastval7val_intEv+0x75)[0x58fe359dffe5]
      mariadbd(_ZNK23Type_handler_int_result18Item_save_in_fieldEP4ItemP5Fieldb+0x26)[0x58fe35864dd6]
      mariadbd(_ZN4Item13save_in_fieldEP5Fieldb+0x39)[0x58fe359666d9]
      mariadbd(+0x922d80)[0x58fe3569ed80]
      mariadbd(+0x91986e)[0x58fe3569586e]
      mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x225)[0x58fe35695bd5]
      mariadbd(_ZN4JOIN10exec_innerEv+0xd11)[0x58fe35661e11]

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              imchifan 刘启帆
              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.