Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
Description
CREATE TABLE t1 ( |
pk BIGINT AUTO_INCREMENT, |
f1 CHAR(15), |
f2 INT, |
v1 CHAR(10) AS (f1) VIRTUAL, |
v2 INT AS (f2) PERSISTENT, |
PRIMARY KEY(pk) |
) ENGINE=MyISAM;
|
|
SET SQL_MODE= 'STRICT_TRANS_TABLES'; |
|
INSERT INTO t1 (f1,f2) VALUES |
('0001',1),('01000100',7),('00011',9),('110100011100',1), |
(NULL,76),('000100101',1),('011011111',0),('01010',3), |
('001001111',8),('01110',4),('0110000011000',1),('101110001110100',4), |
('0101100',5),('0000010001110',1),('101111011100000',9),('00',0), |
('1101000100100',6),(NULL,0),('0',8),('1',8), |
('0',1),('001011100',6),('0111',93),('00001000110111',0),('11110',6), |
('111000010',4),('10101101101110',5),('10',5),('00011101001',29), |
('1',8),('111001',9),('01111',2),('100011011111100',4), |
('1100',8),('101011011110110',1),('10010100101',4),(NULL,244), |
(NULL,1),('0100',109),('11000',8),('0000111',5), |
('1111100000',9),('0010001',9),('01111111000000',1),('011100100',5), |
('100101',2),('0',6),('01000001101101',9),('001110000101',3), |
('1001',0),('10011101000110',0),(NULL,4),('00',8), |
('01',1),('1',5),('101111101011',1),('1010111010',110), |
('11010001001',9),(NULL,8),('11110111',1),('0',8), |
('1111',2),(NULL,71),('11000101',9),('0111111011',61), |
('0',6),('10110011',0),('101010',7),(NULL,7), |
('00111',7),('0',35),('10000101',7),(NULL,9), |
('000000001010',0),(NULL,2),('10111101000',1),(NULL,6), |
('0101000010101',5),('01111000100010',5),('0',3),('01100',2), |
(NULL,6),('0011110',9),('010011',17),('1001',2), |
('01010000110',1),('011000',8),(NULL,9),('010000011',2), |
('111110100100000',8),('10000',0),('0000111110',9),('1101111',4), |
('010110',23),('00110',4),('1',1),('011000110',0), |
('101110',8),('0001010111100',1),('011101',6); |
|
--error 0,ER_DATA_TOO_LONG
|
ALTER TABLE t1 ADD KEY (v2); |
|
# Cleanup
|
DROP TABLE t1; |
10.2 dc2856ad6 |
2018-12-22 17:26:35 139905558898432 [ERROR] mysqld: Index for table './test/#sql-1730_4.MYI' is corrupt; try to repair it
|
^ Found warnings in /data/bld/10.2/mysql-test/var/log/mysqld.1.err
|
Not reproducible on 10.3, 10.4.
Attachments
Issue Links
- relates to
-
MDEV-17619 Error 126 "Index file is crashed" or ER_NOT_KEYFILE and eventual "Table is crashed and last repair failed" upon creation or using table with FULLTEXT key on virtual column
-
- Closed
-