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

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.9
    • 10.4, 10.5, 10.6
    • None

    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

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

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.