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

Table corruption upon altering partitions under debug_dbug= "+d,test_pseudo_invisible"

    XMLWordPrintable

    Details

      Description

      Note: Most likely it's just a limitation of the debug injection, but it's worth checking, just in case.

      --source include/have_partition.inc
       
      CREATE TABLE t1 (i INT) PARTITION BY HASH (i) PARTITIONS 3;
      SET debug_dbug= "+d,test_pseudo_invisible";
      ALTER TABLE t1 COALESCE PARTITION 1;
      SET debug_dbug= "";
      SELECT * FROM t1;
       
      # Cleanup
      DROP TABLE t1;
      

      With InnoDB

      MariaDB [test]> SELECT * FROM t1;
      ERROR 1932 (42S02): Table 'test.t1' doesn't exist in engine
      

      With MyISAM

      MariaDB [test]> SELECT * FROM t1;
      ERROR 1030 (HY000): Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an" from storage engine MyISAM
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sachin.setiya.007 Sachin Setiya
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: