Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Description
SET sql_mode=''; |
CREATE TEMPORARY TABLE t (a INT,c VARCHAR(1)) ENGINE=MyISAM; |
INSERT INTO t VALUES (1,''); |
HANDLER t OPEN; |
LOAD DATA LOCAL INFILE '' INTO TABLE t FIELDS TERMINATED BY '' LINES TERMINATED BY ''; |
INSERT INTO t SET c=2; |
HANDLER t READ NEXT; |
DELETE FROM t ORDER BY a LIMIT 1; |
DELETE FROM t; |
INSERT INTO t (a) VALUES (3); |
HANDLER t READ next LIMIT 1; |
Leads to:
10.9.0 b5852ffbeebc3000982988383daeefb0549e058a (Debug) |
10.9.0-dbg>HANDLER t READ next LIMIT 1;
|
ERROR 1194 (HY000): Table 't' is marked as crashed and should be repaired
|
10.9.0 b5852ffbeebc3000982988383daeefb0549e058a (Debug) |
2022-02-21 15:36:58 4 [ERROR] mysql_ha_read: Got error 127 when reading table 't'
|
2022-02-21 15:36:58 4 [ERROR] mysqld: Table 't' is marked as crashed and should be repaired
|