• Guilhem Bichot's avatar
    Fix for BUG#37005 "Maria: ALTER TABLE TRANSACTIONAL=0 leaves table transactional inside Maria" · 8ac71501
    Guilhem Bichot authored
    mysql-test/r/maria-page-checksum.result:
      result for new test portion. Without the code fix, you would see a wrong "yes" or "no" in the "Crashsafe" line
      for iterations 2,9,14.
    mysql-test/t/maria-page-checksum.test:
      Adding test for BUG#37005 "Maria: ALTER TABLE TRANSACTIONAL=0 leaves table transactional inside Maria"
    sql/sql_table.cc:
      In ALTER TABLE, we already rebuilt the table entirely if the DEFAULT CHARSET, ROW_FORMAT or PAGE_CHECKSUM
      clauses were used; we have to do the same if the TRANSACTIONAL clause is used, because it affects
      the table inside the engine (for example, Maria makes shorter rows in non-transactional tables).
      Not doing so led to the BUG#37005, where ALTER TABLE TRANSACTIONAL=0 sometimes left the table
      transactional into Maria though not in the frm.
    8ac71501
maria-page-checksum.test 51.1 KB