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

Got error 127 and ER_CRASHED_ON_USAGE upon SELECT from temporary MyISAM table

    XMLWordPrintable

    Details

      Description

      CREATE TEMPORARY TABLE t1 (c VARCHAR(8)) ENGINE=MyISAM;
      INSERT INTO t1 () VALUES ();
      DELETE FROM t1 LIMIT 1;
      SELECT * FROM t1 t1a, t1 t1b;
      OPTIMIZE TABLE t1;
      --error ER_CANT_DROP_FIELD_OR_KEY
      ALTER TABLE t1 DROP x, CHANGE COLUMN IF EXISTS a b BINARY;
      INSERT INTO t1 () VALUES ();
      SELECT * FROM t1 t1a, t1 t1b;
      

      10.2 1d0c2741

      mysqltest: At line 9: query 'SELECT * FROM t1 t1a, t1 t1b' failed: 1194: Table 't1' is marked as crashed and should be repaired
      

      2019-05-31 16:35:51 139826620962560 [ERROR] Got error 127 when reading table '/data/bld/10.2-rel/mysql-test/var/tmp/mysqld.1/#sql6fe2_4_0'
      2019-05-31 16:35:51 139826620962560 [ERROR] mysqld: Table 't1' is marked as crashed and should be repaired
      

      Debug and non-debug builds are equally affected.
      The test case is not applicable to 10.1 which couldn't re-open a temporary table.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: