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

Server crash with insert statement containing DEFAULT into view

    XMLWordPrintable

Details

    Description

      When trying to insert a row into a view using the DEFAULT keyword, the server exits with signal 11:

      stack_bottom = 0x7ff658047e30 thread_stack 0x48000
      /usr/sbin/mysqld(my_print_stacktrace+0x2b)[0x7ff658a8608b]
      /usr/sbin/mysqld(handle_fatal_signal+0x422)[0x7ff658639902]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0xf880)[0x7ff657caa880]
      /usr/sbin/mysqld(_ZN18Item_default_value4walkEM4ItemFbPhEbS1_+0x36)[0x7ff65865ca56]
      /usr/sbin/mysqld(_Z24check_view_single_updateR4ListI4ItemEPS1_P10TABLE_LISTPyb+0x94)[0x7ff6584c6614]
      /usr/sbin/mysqld(+0x3ecc6c)[0x7ff6584c6c6c]
      /usr/sbin/mysqld(_Z20mysql_prepare_insertP3THDP10TABLE_LISTP5TABLER4ListI4ItemEPS7_S8_S8_15enum_duplicatesPPS6_bbb+0x2cb)[0x7ff6584c865b]
      /usr/sbin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x1c8)[0x7ff6584c9158]
      /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3281)[0x7ff6584e0961]
      /usr/sbin/mysqld(+0x409cba)[0x7ff6584e3cba]
      /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x14f8)[0x7ff6584e5298]
      /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x47b)[0x7ff6585a76fb]
      /usr/sbin/mysqld(handle_one_connection+0x47)[0x7ff6585a77d7]
      /usr/sbin/mysqld(+0x6d2ab0)[0x7ff6587acab0]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x8062)[0x7ff657ca3062]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7ff656322a3d]

      # Table:
      CREATE TABLE `temp` (
        `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
        `test` tinyint(3) unsigned NOT NULL DEFAULT '0',
        PRIMARY KEY (`id`)
      );
       
      # View:
      CREATE VIEW `temp_view` AS (
      select  `temp`.`id` AS `id`,  `temp`.`test` AS `test` from `temp`);
       
      # Insert stmt:
      INSERT INTO `temp_view` SET `test` = DEFAULT;

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            falcon Joshua Gardynik
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.