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

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2, 10.3, 10.4.6, 10.4, 10.5, 10.6, 10.6.4
    • Fix Version/s: 10.2, 10.3, 10.4, 10.5, 10.6
    • Component/s: Views
    • Labels:
    • Environment:
      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

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            js niezhibiao
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration