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

Historical bugs still reappear in the fixed version

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 11.4, 12.1.1
    • N/A
    • N/A
    • Not for Release Notes

    Description

      Hey, I've noticed that the test case in historical bug 17071 can still be triggered in the fixed version 11.4, and it can also be triggered in version 12.1.1-rc.

      CREATE  TABLE t1 (a INT, b INT NOT NULL, UNIQUE(b));
      		 
      INSERT INTO t1 VALUES (10, 0);
      		 
      CREATE TABLE t2 (c INT);
      		 
      CREATE  ALGORITHM=MERGE VIEW v AS SELECT * FROM t1 JOIN t2;
      		 
      ALTER TABLE t1 ADD d VARCHAR(16);
      		 
      INSERT INTO v (b) VALUES (0) ON DUPLICATE KEY UPDATE a = NULL;
      		 
       
      # Cleanup
      		 
      DROP VIEW v;
      		 
      DROP TABLE t1, t2;

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17071 Server crashes in TABLE_LIST::get_tablenr or ASAN use-after-poison in write_record upon INSERT into view

          • Major - Major loss of function.
          • Confirmed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37702 Historical bugs still reappear in the fixed version

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              Unassigned Unassigned
              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.