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

【BUG】【view】debug 版本视图做 insert into ... on duplicate key update操作导致mysqld coredump掉

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.4.6, 10.6.4, 10.2, 10.3, 10.4, 10.5, 10.6
    • N/A
    • Views
    • ubuntu 16.04.4 LTS

    Description

      【重现步骤】
      1、创建表 t1
      CREATE TABLE `t1` (
      `id` int(10) unsigned NOT NULL,
      `r` float NOT NULL,
      PRIMARY KEY (`id`)
      ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
      2、创建视图v1,v2
      create view v1 as select id, if(r=r,1,2) as d from t1;
      create view v2 as
      select id,
      d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d+d as p
      from v1;
      3、执行插入语句
      insert into t1 (id, r)
      select id,p from v2
      on duplicate key update r=p;

      【预期结果】
      插入成功

      【实际结果】
      mysqld coredump

      【备注】
      1、这个问题是在 10.4.6 debug版发现的,随后我又去官网下载了最新的稳定版 10.6.4,发现仍然存在该问题。希望您能尽快修复 bug,同时也麻烦解决后能通知下我。
      2、该问题源于原生用例mysql-test/main/view.test,难道你们没有用 debug 版运行过自己的用例吗?对于这一点我心存疑惑。

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              js niezhibiao
              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.