Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
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
- relates to
-
MDEV-20467 Multiple "Warning: Enabling keys got errno 127 on ., retrying"
- Open