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

Table 't' is marked as crashed and should be repaired on UPDATE and sql_mode changes

    XMLWordPrintable

    Details

      Description

      Slightly alike to MDEV-11691, but this one is not in upstream and the SQL required is different.

      SET sql_mode='';
      CREATE TABLE t0 (a TIMESTAMP) ENGINE=CSV;
      INSERT INTO t0 VALUES (0);
      RENAME TABLE t0 TO t;
      SET sql_mode='traditional';
      UPDATE t SET a=0;
      

      Leads to:

      10.7.0 1bc82aaf0a7746c0921a94034aff2d51f0d75cd0 (Debug)

      2021-09-10  8:26:50 4 [ERROR] mysqld: Table 't' is marked as crashed and should be repaired
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration